MiniExcel icon indicating copy to clipboard operation
MiniExcel copied to clipboard

有合併儲存格與過濾時,使用Template會出錯

Open satanbaby opened this issue 2 years ago • 1 comments

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);

❌有合併儲存格且有過濾 錯誤: image

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

✔只有過濾 正常: image

satanbaby avatar Apr 26 '23 01:04 satanbaby

我新開一個 Excel 檔案 然後把需求端給的內容手動貼上 就正常了

我用樣板也出錯 同樣合併儲存格

jakeuj avatar Jun 14 '23 02:06 jakeuj