test/MiniExcel
1
0
Fork 0
mirror of https://gitee.com/dotnetchina/MiniExcel.git synced 2024-11-29 18:38:08 +08:00
Code Issues Actions Packages Projects Releases Wiki Activity
685 Commits 1 Branch 83 Tags 36 MiB
master
Commit Graph

685 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
Wei Lin
f6992131ec Rollback commit 2024-05-10 21:30:51 +08:00
Geek
6eb30eb97a
NET Core不落地导出Excel支持 (#588) 
* 增加可用范围

* NET Core不落地导出Excel

1.废除FastMode, 支持http响应流直接输出(取消了流回退功能,见解释)
2.每1000行进行重刷一次,节约内存
3不使用new List导致迭代器全部计算浪费内存
4.解释:
在OpenXML中，<x:dimension ref="..."/> 元素指定了工作表中使用的单元格区域，它定义了工作表中所有单元格的最小矩形范围。这个元素是可选的，因为Excel和其他兼容的电子表格程序通常能够在没有这个元素的情况下打开文件，并计算出实际使用的单元格范围。

然而，省略 <x:dimension ref="..."/> 可能会导致性能问题，尤其是在处理大型工作表时。如果存在这个元素，电子表格程序可以直接定位到工作表中的活动区域，而不需要扫描整个工作表来确定哪些单元格包含数据。这可以减少文件打开的时间和内存使用量。

所以，如果你在乎打开文件的性能，特别是对于大型的工作表，最好是包含 <x:dimension ref="..."/> 元素。但如果你在生成的文件中遇到兼容性问题，或者你正在处理的是小型工作表，并且不太关心打开文件的性能，那么你可以选择省略它。

在OpenXML SDK中，如果你使用OpenXmlWriter来写入工作表，你可以选择是否写入这个元素。如果你决定省略它，确保你的电子表格程序能够在没有这个元素的情况下正确处理文件。

* 4.1 NET Core不落地导出Excel

* 更新 README.zh-CN.md
 2024-05-03 22:20:13 +08:00
AZ
e8fb1a564d
fix #585 (#586) 
* fix #585

* fix issue number in test
 2024-04-27 08:18:12 +08:00
Johannes Barta
623ecc87a9
Bugfix/dynamic columns not working (#581) 
* Fix DynamicExcelColumn configuration while saving IDictionary values

* adapt using

---------

Co-authored-by: Johannes Barta <johannes.barta@buhlergroup.com>
 2024-04-13 00:10:16 +08:00
hansen
9e3f1bd58d
[fix] when first row(s) is empty, query return data will not contain the empty row(s) (#578) 
Co-authored-by: hansen <hansen@bytedance.com>
 2024-03-31 23:50:19 +08:00
Jef
b27b169e2a
Make System.DateOnly available as date in Excel (#576) 
* Format the code and remove trailing whitespaces

* Update Visual Studio gitignore template

* Refactor: rename variables, add comments

* Support writing DateOnly type to Excel

---------

Co-authored-by: Jef Van den Brandt <Jef.VandenBrandt@cheops.be>
 2024-03-31 23:49:31 +08:00
Wei Lin
9eb23d9bdf doc: update link 2024-03-31 23:45:13 +08:00
Jef
567d70b888
Allow ampersand in sheet names (#574) 
* Write out XML encoded sheet names

* Fix culture errors when running unit tests

* Force dot as decimal separator column width, fixes bug triggered by TestIssueI4ZYUU

---------

Co-authored-by: Jef Van den Brandt <Jef.VandenBrandt@cheops.be>
 2024-03-24 21:32:13 +08:00
duszekmestre
7894e28c4d
Use true async processing for excel writer (#573) 
* Use true async processing for excel writer

* Add async processing to other methods

---------

Co-authored-by: Lukasz Arciszewski <lukasz.arciszewski@accenture.com>
 2024-03-24 21:27:47 +08:00
Wei Lin
4a667791d7 Merge branch 'master' of https://github.com/shps951023/MiniExcel 2024-03-06 15:44:20 +08:00
Wei Lin
4a480727c2 Merge branch 'master' of https://github.com/shps951023/MiniExcel 2024-03-06 15:44:16 +08:00
Wei Lin
1b8708d67d Merge branch 'master' of https://github.com/shps951023/MiniExcel 2024-03-06 15:24:08 +08:00
Wei Lin
6151c3f335 Fix propInfo.Key missing 2024-03-06 15:24:01 +08:00
PurplestViper
b17506f0cb
修复可空枚举转换失败问题 (#567) 2024-02-21 20:08:23 +08:00
Paweł Szybiak
e6a481383d
Add functionality that allows you to read and write the visibility of excel sheets (Issue #531) (#563) 
* Read and write excel documents using DynamicExcelSheet and ExcelSheetAttribute

* Fix in generating the default sheet name

---------

Co-authored-by: Paweł Szybiak <pawel.szybiak@vsoft.pl>
 2024-02-03 13:02:29 +08:00
Nikolai Norum Hansen
71f9775e37
Issue 422 (#562) 
* Ensure linq deferred execution when saving enumerable

* Consolidate some code between DataReader and Enumerable

* Add test for issue 422 linq deferred execution

* Remove genericType out parameter

* Use index instead of count for variable names
 2024-01-28 11:21:28 +08:00
Paweł Szybiak
cd1166cc10
Using DynamicConfiguration when writing data using DataTable (#561) 
Co-authored-by: Paweł Szybiak <pawel.szybiak@vsoft.pl>
 2024-01-20 17:33:00 +08:00
Wei Lin
cfdc452a98 doc: benefit link 2024-01-14 15:43:30 +08:00
Paweł Szybiak
3d63587d9c
Read empty string as null (#555) (#556) 
Co-authored-by: Paweł Szybiak <pawel.szybiak@vsoft.pl>
 2024-01-07 21:05:21 +08:00
Wei Lin
55153d87df
01/13 希望能更換掉民進黨 
01/13 希望能更換掉民進黨
 2024-01-07 13:15:04 +08:00
Wei
dfabbf0c52 [doc] update dapper query description 2023-12-27 12:04:37 +08:00
Peter Parke
8bf92ac5d2
Update README.zh-CN.md (#554) 
update Dapper demo
 2023-12-27 12:00:00 +08:00
Wei
4baaf46974 [Unit Test] Issue 553 2023-12-27 09:47:29 +08:00
Wei
bd1f7d5b21 [doc] Fix dapper query wrong description #552 2023-12-27 09:23:03 +08:00
Wei
e1b79513bb [Bug] SaveAsByTemplate rowInfo.IEnumerableMercell.Height null exception 2023-12-27 08:44:40 +08:00
Paweł Szybiak
abfc7adcb8
Throw custom exception when column not found (#543) 
Co-authored-by: Paweł Szybiak <pawel.szybiak@vsoft.pl>
 2023-12-13 20:19:41 +08:00
Wei
205c763625 update desc 2023-10-30 08:23:22 +08:00
阿翰
02fc4d4856
!12 解决数据库字段映射实体类型是枚举类型时，有脏数据的情况下解释出来类型信息出错的问题 
Merge pull request !12 from wulaohu/master
 2023-09-19 07:59:33 +00:00
wulaohu
62806c3aac 解决数据库字段映射实体类型是枚举类型时，有脏数据的情况下解释出来类型信息出错的问题 2023-09-07 10:31:31 +08:00
Wei
f1498a2d16 update documents 2023-08-10 15:17:30 +08:00
eynarhaji
ee2b198aff
Add support for merge limit (#521) 
* add support for grouped cells

* fix for rows after endgroup

* minor fix for text after grouping

* fix unit tests

* fix unit tests and docs

* minor fix

* Add support to vertical merge cells

* minor fixes in merge cells

* minor fix

* fix complex scenario

* finalize changes

* Add support for if/elseif/else statements

* add merge tag

* add merge-tag

* update readme

* minor fix

* minor fix

* minor fix

* Update MiniExcelLibs.csproj

* Add support for merge limit

* update test cases

* rollback

---------

Co-authored-by: Wei Lin <shps951002@gmail.com>
 2023-08-09 14:18:57 +08:00
eynarhaji
9811ef9fbb
Add @merge and @endmerge tags (#519) 
* add support for grouped cells

* fix for rows after endgroup

* minor fix for text after grouping

* fix unit tests

* fix unit tests and docs

* minor fix

* Add support to vertical merge cells

* minor fixes in merge cells

* minor fix

* fix complex scenario

* finalize changes

* Add support for if/elseif/else statements

* add merge tag

* add merge-tag

* update readme

* minor fix

* minor fix

* minor fix

* Update MiniExcelLibs.csproj

---------

Co-authored-by: Wei Lin <shps951002@gmail.com>
 2023-08-07 18:27:29 +08:00
ivan132
c592b7723a
bugfix:修复R1C1引用转A1引用 bug (#515) 2023-07-21 09:45:36 +08:00
Grzegorz Gruszczyk
986af41289
Make use of dynamic columns when generating sheet by IDataReader to change column names & widths (#514) 2023-07-21 09:42:31 +08:00
Wei
b009975ca3 Doc : qq group - 3 2023-07-07 16:23:50 +08:00
Wei Lin
e86c3dd9e2 [Doc] remark and doc of support property cache #23 (via @RRQM_Home) 2023-06-22 13:57:02 +08:00
阿翰
6517fb2d48
!11 将反射赋值优化为表达式树赋值 
Merge pull request !11 from 若汝棋茗/master
 2023-06-19 16:06:11 +00:00
若汝棋茗
81d602208d 将反射赋值优化为表达式树赋值 2023-06-19 09:37:27 +08:00
0MG-DEN
7850be8b6f
Fix EnableWriteNullValueCell null error (#500) 
* Fix EnableWriteNullValueCell null error

* Revert previous if/else statement
 2023-06-15 22:03:00 +08:00
plcly
ee3c1efac4
Fix DateTime Style Error (#502) 
Co-authored-by: admin <admin@DESKTOP>
 2023-06-15 22:02:15 +08:00
Wei Lin
645a7cf87a update version and doc cn 2023-05-28 12:24:22 +08:00
Wei Lin
c62b881e27 Fix EnableWriteNullValueCell bool error 2023-05-28 12:10:29 +08:00
0MG-DEN
42eab33e45
Add option to skip null values when writing to Excel (#497) 
* Add option to skip null values when writing to Excel

* Rename option to skip null values

* Update README
 2023-05-28 11:55:56 +08:00
Argo Zhang
b8c3e3dc36
fix: 修复读取 sheet 错误问题 (#493) 2023-05-28 11:53:15 +08:00
Jean-Sébastien Gervais
7a1958100c
489 fix calc chain.xml (#491) 
* flush and recreate xl/calChain.xml file containing index of cell with functions.  Need to parse worksheets.xml.rels to get worksheet ids

* need to reopen stream after StreamWriter gets disposed out of it's using context

---------

Co-authored-by: Jean-Sebastien Gervais <jsgervais84@gmail.com>
Co-authored-by: Wei Lin <shps951002@gmail.com>
 2023-05-09 22:28:15 +08:00
Wei Lin
171b881944 Merge branch 'master' of https://github.com/shps951023/MiniExcel 2023-05-09 22:19:38 +08:00
Jean-Sébastien Gervais
38a1796e4b
parse class public properties and public fields (#490) 
* parse class public properties and public fields

* cleaner; the else non will never hit as PropertyInfoOrFieldInfo = None only happens for dictionnary row info, which is handled in another if else branch

---------

Co-authored-by: Jean-Sebastien Gervais <jsgervais84@gmail.com>
 2023-05-09 22:16:11 +08:00
Wei Lin
5490a02409 update CN document 2023-05-02 00:44:28 +08:00
eynarhaji
0559847ecc
Add supprt for if/elseif/else statements inside cell (#487) 
* add support for grouped cells

* fix for rows after endgroup

* minor fix for text after grouping

* fix unit tests

* fix unit tests and docs

* minor fix

* Add support to vertical merge cells

* minor fixes in merge cells

* minor fix

* fix complex scenario

* finalize changes

* Add support for if/elseif/else statements
 2023-05-02 00:36:15 +08:00
Vinicius Lourenço
1bd853affe
fix: bad csv (#472) 
* feat(csv): add option to force quotes in all csv

* fix(csv): quote the delimiter and also \n and \r
 2023-03-12 10:25:32 +08:00