EPPlus数组维度超出了支持范围。System.OutOfMemoryException开发者社区

link之家

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

文章/答案/技术大牛

发布

    public ExcelPackage ExcelPackageFromCsvStream(Stream csvStream)
        var excelPackage = new ExcelPackage();
        var workSheet = excelPackage.Workbook.Worksheets.Add("Sheet1");
        var csvFormat = new ExcelTextFormat
            Delimiter = ',',
            TextQualifier = '"',
            DataTypes = new[] { eDataTypes.String }
        using (var sr = new StreamReader(csvStream))
            int i = 1;
            foreach (var line in sr.ReadLines("\r\n"))
                workSheet.Cells["A" + i].LoadFromText(line, csvFormat);
        return excelPackage;
    }

    public List<ExcelPackage> ExcelPackagesFromCsvStream(Stream csvStream, int batchSize)
        var excelPackages = new List<ExcelPackage>();
        int currentPackage = -1; // so that first package will have the index 0
        var csvFormat = new ExcelTextFormat
            Delimiter = ',',
            TextQualifier = '"',
            DataTypes = new[] {eDataTypes.String}
        using (var sr = new StreamReader(csvStream))
            int index = 1;
            foreach (var line in sr.ReadLines("\r\n"))
                if ((index - 1) % batchSize == 0)
                    var excelPackage = new ExcelPackage();
                    excelPackage.Workbook.Worksheets.Add("Sheet1");
                    excelPackages.Add(excelPackage);
                    currentPackage++;
                    index = 1;
                excelPackages[currentPackage].Workbook.Worksheets.First().Cells["A" + index].LoadFromText(line, csvFormat);

问 EPPlus数组维度超出了支持范围。System.OutOfMemoryException EN

回答 1

Stack Overflow用户