search

mini-software / MiniExcel

Fast, Low-Memory, Easy Excel .NET helper to import/export/template spreadsheet (support Linux, Mac)
https://www.nuget.org/packages/MiniExcel/
Apache License 2.0
2.81k stars 342 forks source link

多Sheet XLSX文件，MiniExcel读取数据时间过长 #611

Open chenzanyu opened 5 months ago

chenzanyu commented 5 months ago

Excel Type

Upload Excel File

Please attach your issue file by dragging or droppng, selecting or pasting them.

MiniExcel Version

Description

chenzanyu commented 5 months ago

温通仪3.0板子BOM清单20240207(4)_638475701695276993.xlsx

chenzanyu commented 5 months ago

这个Excel文件，如果修改每个sheet的title公司名称，读取可以在2秒以内完成，原文件需要>40秒才能成功读取

chenzanyu commented 5 months ago

下面是读取XLSX文件代码

OpenXmlConfiguration configuration = new OpenXmlConfiguration() { FillMergedCells = true };
var source_Rows = MiniExcel.Query(stream, configuration: configuration).ToList();