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

258 Commits

Author SHA1 Message Date
BaatenHannes
92b295d4b2
Async implementation of freezing top row (#684) 
* Add async implementation of frozen rows and columns

* Add unit tests for async implementation of frozen rows and columns

* Fix formatting and delete temp file in unit test

* move freezing top row implementation to DefaultOpenXml.cs
 2024-11-02 19:19:10 +08:00
Rami O. Hassan
a0797a53f6
Upgrade to .NET 8.0 and refactor input value extraction (#681) 
* Upgrade to .NET 8.0

* Add tests
 2024-11-02 19:12:59 +08:00
aulickiDnv
436aaa80c9
Yield empty self-closing row tags as empty row during query. (#673) 2024-09-28 18:24:12 +08:00
Nikolai Norum Hansen
29d4ee8af8
Fix dimension writing in FastMode (#659) 
* Add tests for fast mode

* Fix dimension writing in FastMode
 2024-08-25 15:59:32 +08:00
meld-cp
67e97f36b5
Fix Issue 632, refactor sheet styles (#640) 
* fix for issue 606

* fix formatting

* add test

* refactor sheet styles, fix #632

* change tabs to spaces
 2024-07-22 21:32:04 +08:00
Wei Lin
c68d092dec MiniExcelIssue2024Tests & Issue627 2024-07-21 19:58:13 +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
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
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
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
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
Wei Lin
5cce5e4d4b Test: update to .net6.0 2024-05-16 23:08:59 +08:00
Wei Lin
b7bc3cce57 Bug: fix sharedStrings ref #549 2024-05-12 17:44:27 +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
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
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
Wei Lin
4a480727c2 Merge branch 'master' of https://github.com/shps951023/MiniExcel 2024-03-06 15:44:16 +08:00
Wei Lin
6151c3f335 Fix propInfo.Key missing 2024-03-06 15:24:01 +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
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
4baaf46974 [Unit Test] Issue 553 2023-12-27 09:47:29 +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
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
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
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
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
eynarhaji
5a941f7b5b
Minor fixes in group merges (#469) 
* 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
 2023-02-22 18:09:05 +08:00
eynarhaji
b8f08a6697
Add support for merge vertical cells automatically (#467) 
* 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
 2023-02-20 21:45:08 +08:00
eynarhaji
1520b76fd3
add support for grouped cells (#464) 
* add support for grouped cells

* fix for rows after endgroup

* minor fix for text after grouping
 2023-02-15 22:23:01 +08:00
Wei Lin
4a45f045c3 [New] support function to custom separator 2023-01-07 13:52:18 +08:00
Wei Lin
418a1093c4 [New] support excel enum description string to enum #289 2022-12-27 16:16:39 +08:00
dependabot[bot]
97bd05df42
Bump Newtonsoft.Json from 13.0.1 to 13.0.2 in /tests/MiniExcelTests (#456) 
Bumps [Newtonsoft.Json](https://github.com/JamesNK/Newtonsoft.Json) from 13.0.1 to 13.0.2.
- [Release notes](https://github.com/JamesNK/Newtonsoft.Json/releases)
- [Commits](https://github.com/JamesNK/Newtonsoft.Json/compare/13.0.1...13.0.2)

---
updated-dependencies:
- dependency-name: Newtonsoft.Json
  dependency-type: direct:production
...

Signed-off-by: dependabot[bot] <support@github.com>

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
 2022-12-27 14:19:19 +08:00
Wei Lin
dc0119050d increase VSTEST_CONNECTION_TIMEOUT: 90000 2022-12-27 13:06:08 +08:00
Wei Lin
239d0aca09 fix unit test dotnet yml 2022-12-27 12:16:19 +08:00
Wei Lin
689cf5d78e upgrade to .net6.0 2022-12-27 12:02:39 +08:00
Wei Lin
a30d3bbda9 [New] SaveAs support FastMode 2022-11-09 22:44:52 +08:00
Wei Lin
72b471a9d1 Support Assembly Strong Name Signature #450 2022-10-29 22:55:16 +08:00
WeiLin
d4365111bc [New] Support CSV Insert #I4X92G (via @shps951023) 2022-09-19 21:17:47 +08:00
WeiLin
0996ab8032 [New] Support DateTimeOffset and ExcelFormat #430 (via @Lightczx , @shps951023 ) 2022-09-18 23:24:46 +08:00
WeiLin
2e9c310396 [Optimization] SaveAs by datareader support dimension #231 2022-09-18 22:49:00 +08:00
WeiLin
b01e28c5df [Bug] Fixed MiniExcel.SaveAsByTemplate error when value is List<Dictionary<string, object>> #413 2022-09-09 23:02:52 +08:00