MiniExcel
MiniExcel copied to clipboard
Fast, Low-Memory, Easy Excel .NET helper to import/export/template spreadsheet (support Linux, Mac)
  `System.NotSupportedException: 'This stream from ZipArchiveEntry does not support seeking.'` 
### Excel Type - [X] XLSX - [ ] XLSM - [ ] CSV - [ ] OTHER ### Upload Excel File [DateTimeFormat.xlsx](https://github.com/MiniExcel/MiniExcel/files/9430857/DateTimeFormat.xlsx) ### MiniExcel Version 1.26.5 ### Description When...
Hi, I want to update some cell from a column in an existing xlsx. 1. open the xlsx 2. read line by line and update the last column "STATUS" depending...
In an attempt to use DynamicColumns with IDataReader i converted the reader into an IEnumerable using the following method: ```c# private IEnumerable AsDict(IDataReader dataReader) { while (dataReader.Read()) { yield return...
### Excel Type - [x] XLSX - [ ] XLSM - [ ] CSV - [ ] OTHER ### Upload Excel File Please attach your issue file by dragging or...
### Excel Type - [X] XLSX - [ ] XLSM - [ ] CSV - [ ] OTHER ### Upload Excel File [issue.xlsx](https://github.com/mini-software/MiniExcel/files/14552008/issue.xlsx) ### MiniExcel Version 1.31.3 ### Description Cell...
构造函数中创建文件失败,导致_positionFs等变量是null,析构函数中使用_positionFs.Name造成了崩溃。 建议: 1、将临时文件存到 Path.GetTempPath() 返回的路径中。因为在asp.net中当前路径是c:\\windows\\system32\\inetsrv,这会有权限问题 2、析构函数需改进 3、新建OpenXml.SharedStringsDiskCache实例的地方使用using确保用完马上释放
I need to repeat the table and note values in the sheet with the sample template. Can you share with me how to do it? I want make like this...
### Excel Type - [X] XLSX - [ ] XLSM - [ ] CSV - [ ] OTHER ### Upload Excel File [SourceFile.xlsx](https://github.com/mini-software/MiniExcel/files/14446622/SourceFile.xlsx) (Note that the names included are not...
模板填充 Excel 的时候希望增加几个特殊标签。 {{@RowIndex}} 可以直接写入行号 {{@Sum}} 可以直接计算列数值总和 {{@Max}} 可以直接计算列数值最大值 {{@Min}} 可以直接计算列数值最小值 {{@Avg}} 可以直接计算列数值平均值