MiniExcel
MiniExcel copied to clipboard
有合併儲存格與過濾時,使用Template會出錯
Excel Type
- [x] XLSX
- [ ] XLSM
- [ ] CSV
- [ ] OTHER
Upload Excel File
Please attach your issue file by dragging or droppng, selecting or pasting them.
e.g : testTemplate.xlsx
MiniExcel Version
Description
var value = new Dictionary<string, object>()
{
["P"] = new[] {
new {Name="John", Age = 10 },
new {Name="Peter", Age = 18 },
new {Name="Joe", Age = 20 },
}
};
using FileStream stream = File.Create(Path.Combine(path, "test.xlsx"));
stream.SaveAsByTemplate(templatePath, value);
❌有合併儲存格且有過濾 錯誤:

✔有合併儲存格但沒過濾 正常:

✔只有過濾 正常:

我新開一個 Excel 檔案 然後把需求端給的內容手動貼上 就正常了
我用樣板也出錯 同樣合併儲存格