excel EPPLUS在单元格值中插入超过1000个字符

5m1hhzi4 于 2023-04-07 发布在其他

关注(0)|答案(1)|浏览(195)

有没有办法在单元格值中插入超过1000个字符？现在它被切断了。也许有没有办法追加值？
我找不到关于这个主题的任何东西。我遍历了OfficeOpenXml.ExcelWorksheet.Cell之后的所有选项，没有找到任何东西。现在我像这样设置单元格值：OfficeOpenXml.ExcelWorksheet.Cell[A1].Value = 'something'和something this 'something'超过1000个字符。

excel

来源：https://stackoverflow.com/questions/75930893/epplus-insert-more-than-1000-characters-in-cell-value

1条答案

按热度按时间

bnl4lu3b1#

下面的代码使用EPPlus 6.2创建了一个包含4001个C2字符的Excel工作表，以z结尾：

using OfficeOpenXml;

ExcelPackage.LicenseContext = LicenseContext.NonCommercial;

var file = new FileInfo("MyWorkbook.xlsx");
file.Delete();
using var package = new ExcelPackage(file);

var worksheet = package.Workbook.Worksheets.Add("Inventory");
//Add the headers
worksheet.Cells[1, 1].Value = "ID";
worksheet.Cells[1, 2].Value = "Product";
worksheet.Cells[1, 3].Value = "Notes";

//Add some items...
worksheet.Cells["A2"].Value = 12001;
worksheet.Cells["B2"].Value = "Nails";
worksheet.Cells["C2"].Value = new String('a',4000) + "z";

worksheet.Cells["C3"].Formula = "LEN(C2)";
package.Save();