Wei Lin
8e4112160c
1.35.0
2024-11-09 11:46:11 +08:00
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
Eulises Vargas
f0fe803d6a
Formula attribute added to support in rows with dto or dynamic attrib… ( #679 )
...
* Formula attribute added to support in rows with dto or dynamic attributes
* Change Formula attribute to ColumnType (Value, Formula)
---------
Co-authored-by: Eulises Vargas <eulises.vargas@iconstruye.onmicrosoft.com>
2024-10-15 23:09:27 +08:00
aulickiDnv
436aaa80c9
Yield empty self-closing row tags as empty row during query. ( #673 )
2024-09-28 18:24:12 +08:00
Wei Lin
831c814788
1.34.2
2024-09-14 20:11:56 +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
Amos
6d81ddc59f
perf csv insert ( #653 )
2024-08-16 23:44:51 +08:00
Argo Zhang
b20ed40f81
feat(MiniExcelDataReaderBase): add MniExcelDataReaderBase class to simplify code ( #651 )
...
* feat: 增加 MiniExcelDataReaderBase 基类
* refactor: 使用基类精简代码
* Update MiniExcelDataReaderBase.cs
Signed-off-by: Wei Lin <shps951002@gmail.com>
---------
Signed-off-by: Wei Lin <shps951002@gmail.com>
Co-authored-by: Wei Lin <shps951002@gmail.com>
2024-08-15 20:37:15 +08:00
Amos
4b7f1696db
Fix QueryAsDataTable can't read Excel with only header rows ( #647 )
...
* Fixed an issue with QueryAsDataTable that only header rows cannot be read correctly
* handling null value
2024-08-13 22:27:47 +08:00
Wei Lin
6161e299fd
1.34.1
2024-08-10 16:53:57 +08:00
Gary Jia
c92aa0dc17
bug: Cannot do this for multiple selection ( #641 )
...
When tabSelected="1", the resulting Excel will say "Cannot do this for multiple selected areas"
Signed-off-by: Gary Jia <35099424+jiaguangli@users.noreply.github.com>
2024-07-27 08:48:40 +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
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
