test/MiniExcel
1
0
Fork 0
mirror of https://gitee.com/dotnetchina/MiniExcel.git synced 2024-12-02 03:47:41 +08:00
Code Issues Actions Packages Projects Releases Wiki Activity
672 Commits 1 Branch 83 Tags 36 MiB
1.34.0
Commit Graph

672 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
Wei Lin
228b3c180f Fix NU5039 The readme file 'README.md' does not exist in the package 2024-07-21 20:05:45 +08:00
Wei Lin
c68d092dec MiniExcelIssue2024Tests & Issue627 2024-07-21 19:58:13 +08:00
Wei Lin
4c4cbe5fd4 Merge branch 'master' of https://github.com/mini-software/MiniExcel 2024-07-21 19:56:55 +08:00
Wei Lin
12aa2fe131 README-NuGet & 1.34.0 release 2024-07-21 19:56:37 +08:00
meld-cp
92170f1fc2
Reduce memory requirements when processing templates + template formulas (#638) 
* fix for issue 606

* fix formatting
 2024-07-20 20:27:13 +08:00
Jed Samok
9de96abba8
add QueryRange test and docs.（#634） (#635) 2024-07-19 22:04:44 +08:00
duszekmestre
7ecf0ffe69
Fix empty data reader issue. (#629) 
Co-authored-by: Lukasz Arciszewski <lukasz.arciszewski@accenture.com>
 2024-07-13 09:21:49 +08:00
meld-cp
c0c8621e94
Merge pull request #631 from meld-cp/master 
add docs for Freeze Panes
 2024-07-13 12:28:15 +12:00
meld-cp
364841f92e add docs for Freeze Panes 2024-07-13 12:26:14 +12:00
meld-cp
4fd14f2174
Merge pull request #630 from meld-cp/master 
Fix potential endless loop
 2024-07-13 12:07:35 +12:00
meld-cp
8db86219fc code formatting 2024-07-13 12:00:40 +12:00
meld-cp
04866cf46c fix potential endless loop 2024-07-13 11:58:13 +12:00
meld-cp
bb86a9e8ab
Fix problem with multi-line when using Query (#628) 
* Fix problem with multi-line when using Query

* fix broken test

* Add another test for issue 507
 2024-07-12 23:17:16 +08:00
meld-cp
1cd491cc13
Add freeze panes (#626) 
* add template formula example images

* add template formula example to readme

* add template formula example to readme

* get basics working

* add config option

* add WritePanes method, remove FreezeTopRow, add FreezeRowCount and FreezeColumnCount options, add unit test

* add xml methods to WorksheetXml

* remove unused namespaces

* revert disable file delete

* add freeze panes feature to table and idatareader
 2024-07-11 22:57:36 +08:00
Gary Jia
273fe9756f
Merge pull request #624 from jiaguangli/master 
add all type nullable support
 2024-07-08 10:06:12 +08:00
Gary Jia
d786ba36ee
Update TypeHelper.cs 
add all type nullable support

Signed-off-by: Gary Jia <35099424+jiaguangli@users.noreply.github.com>
 2024-07-08 10:00:40 +08:00
Gary Jia
ecc049765d
Merge pull request #623 from jiaguangli/master 
add dateTime nullable support
 2024-07-08 09:34:58 +08:00
Gary Jia
5230c8d273
Add DateTime Nullale support 
Update TypeHelper.cs

Signed-off-by: Gary Jia <35099424+jiaguangli@users.noreply.github.com>
 2024-07-08 09:29:20 +08:00
Wei Lin
a51bfbe7c7 1.33.0 2024-07-07 13:29:28 +08:00
meld-cp
1cab06e464
Add docs for template formulas (#622) 
* add template formula example images

* add template formula example to readme

* add template formula example to readme
 2024-07-07 13:01:16 +08:00
meld-cp
1caf3fee3b add $= formula handling with $enumrowstart/end placeholder replacments (#621) 
Co-authored-by: meld-cp <18450687+meld-cp@users.noreply.github.com>
 2024-07-06 20:04:50 +08:00
Wei Lin
b3a980cf2a .NET Foundation requirement: Code of Conduct&CoC enforcement announcement 2024-06-29 15:43:46 +08:00
Wei Lin
219c86c5ae .NET Foundation requirement: Code of Conduct&CoC enforcement announcement 2024-06-29 12:36:26 +08:00
vov4uk
6bcf5dd89d
Update README (#618) 
* Update README

* Link PackageReadmeFile

* Signed commit
 2024-06-25 00:20:38 +08:00
DancePanda42
00a445c6bd
Custom DateTime format (#616) 
* - goto/jumpmark

* + generate numberformats

* + `FormatId`

* ~ first working shot

* ~ assign responsibilities correctly

* ~ fix last test issues

* + extend tests

* ~ clean up

* ~ simplify `DateOnly` handling

* + `DateOnly` to Tests

* Update ExcelOpenXmlSheetWriter.cs

Update GenerateSheetByIDataReader

* + datetime format for async part

---------

Co-authored-by: Gary Jia <35099424+jiaguangli@users.noreply.github.com>
 2024-06-13 21:26:26 +08:00
Gary Jia
12bb1c0028
add nullable type support (#614) 2024-06-10 10:48:48 +08:00
Timon Arendt
0c878b1542
Added missing Autofilter assignment for DataTable export (#610) 
* Added missing Autofilter assignment for DataTable export

* Fixed autofilter being written before EndSheetData
 2024-05-27 23:35:03 +08:00
duszekmestre
c79c64d478
Reuse code between async/sync methods (#602) 
* Reuse code between async/sync methods

* Update checkout action

* Change access modifiers

---------

Co-authored-by: Lukasz Arciszewski <lukasz.arciszewski@accenture.com>
 2024-05-23 18:56:43 +08:00
duszekmestre
fdfe883904
CSV enumeration and code reusage (#600) 
* 1900 year DateTime correction

* Rewrite CSV enumeration

* Maximize code reusage

* Reuse OADate correction

* Update to latest version of CodeQL

* Update CodeQL to v3

---------

Co-authored-by: Lukasz Arciszewski <lukasz.arciszewski@accenture.com>
 2024-05-19 14:29:15 +08:00
duszekmestre
49bc8e99ed
1900 year DateTime correction (#599) 
Co-authored-by: Lukasz Arciszewski <lukasz.arciszewski@accenture.com>
 2024-05-17 21:29:11 +08:00
wangboshun
4d1ee8e327
Update DynamicConfiguration format (#595) 
Update  DynamicConfiguration format
 2024-05-17 21:26:34 +08:00
Wei Lin
5cce5e4d4b Test: update to .net6.0 2024-05-16 23:08:59 +08:00
Wei Lin
b24b35acad Remove bug with Portable.System.DateTimeOnly and only support DateOnly .NET6^ 2024-05-16 22:20:03 +08:00
Wei Lin
361fb964f4 .NET5^ support image ReadOnlySpan<byte> 2024-05-16 22:17:49 +08:00
Wei Lin
ae4e68fbf8 update release doc 2024-05-12 18:00:22 +08:00
Wei Lin
11857e17ff 1.32.0 2024-05-12 17:57:43 +08:00
Wei Lin
b7bc3cce57 Bug: fix sharedStrings ref #549 2024-05-12 17:44:27 +08:00
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