dotnetcore / dotnetcore/Magicodes.IE

分批次导入同一个Sheet该怎么操作?

Open
#579 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
C#
Stars
2.2k
Forks
495
PR merge metrics
No merged PRs in 30d

Description

我试图使用excelExporter.Append().SeparateByRow() 但在循环中
for (int i = 1; i <= writeCount; i++)
{
searchModel.Current = i;
var ms = GetData(searchModel, exportSettingModel.SelectDataSql);
var ms3 = ms.Copy();
if(i==1)
excelExporter=excelExporter.Append(ms);
else
{

excelExporter=excelExporter.SeparateByRow().Append(ms3);
}

}
ShiftTabelModel我标记了 [ExcelExporter(Name = "测试",AutoFitAllColumn = true, MaxRowNumberOnASheet = 10002)]
会报错ExportShit导出Error:Value cannot be null. (Parameter 'A sheet with the name already exists:测试')
使用excelExporter.Append(ms).SeparateByRow().Append(ms3); 同上也会报错
ExportShit导出Error:Value cannot be null. (Parameter 'A sheet with the name already exists:测试') at Magicodes.ExporterAndImporter.Excel.ExcelExporter.Append[T](ICollection`1 dataItems, String sheee)
如果改为每次都是不同的sheet就可以
for (int i = 1; i <= writeCount; i++)
{
searchModel.Current = i;
var ms = GetData(searchModel, exportSettingModel.SelectDataSql);
var ms3 = ms.Copy();
if(i==1)
excelExporter=excelExporter.Append(ms,"sheet");
else
{

excelExporter=excelExporter.SeparateByRow().Append(ms3,$"sheet{i}");
}

}
1.是否是bug或我设置不对
2.希望后续可以出一个按行来追加的时候可以新增配置选择表头或忽略表头而不是展示空白行

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.