MiniExcel
MiniExcel copied to clipboard
mini-software
Fast, Low-Memory, Easy Excel .NET helper to import/export/template spreadsheet (support Linux, Mac)
 ```C# void Main() { var value = new[] { new Dto{Name="Jack",Type=UserType.General}, new Dto{Name="Leo",Type=UserType.Admin}, }; var path = Path.GetTempPath() + Guid.NewGuid() + ".xlsx"; Console.WriteLine(path); MiniExcel.SaveAs(path,value); var rows = MiniExcel.Query(path); Console.WriteLine(rows);...
### Excel Type - [x] XLSX ### MiniExcel Version 0.18.0 ### Description 当用户导入的.xlsx文件 表格尾部存在许多空行时，系统会出现如下错误，读取不了Excel的数据。毕竟表格一下拉都是空行，用户很多时候也分辨不出来空行。看有没好的方式优化下读取方式？ Message：An item with the same key has already been added. Key: 0 Stack: at System.ThrowHelper.ThrowAddingDuplicateWithKeyArgumentException[T](T key)...
### 功能需求 对于已有的excel文件可以插入一个新的sheet，并保存相关数据。
### Excel Type - [ ] CSV ### Upload Excel File Please attach your issue file by dragging or droppng, selecting or pasting them. [22.XLS](https://github.com/shps951023/MiniExcel/files/7140750/22.XLS) ### MiniExcel Version 最新 ###...
Like Dapper ```C# /// /// Finds best constructor /// /// DataReader column names /// DataReader column types /// Matching constructor or default one public ConstructorInfo FindConstructor(string[] names, Type[] types) {...
  
Like Dapper:   record 
Metadata
Owner
Metadata
Fast, Low-Memory, Easy Excel .NET helper to import/export/template spreadsheet (support Linux, Mac)