Commit Graph

638 Commits

Author SHA1 Message Date
Wei Lin
375c142d17
Merge pull request #355 from isdaniel/refactor/combine-condition
重購合併判斷
2022-04-02 11:31:18 +08:00
danielshih
72306101d2 重購合併判斷 2022-04-02 10:30:54 +08:00
Wei
12b6b25d0f [Bug] SaveAs by datareader, sometime it will add one more autoFilter column #352 2022-03-29 23:31:54 +08:00
Wei Lin
268e997641
Merge pull request #350 from isdaniel/feature/async-enhancement
async enhancement.
2022-03-28 11:49:30 +08:00
danielshih
201c5c419d add more test case 2022-03-26 22:49:27 +08:00
danielshih
bc2f9070f0 async enhancement.
1. add cancellationToken
2. add ConfigureAwait avoid UI context Switch.
2022-03-26 22:29:49 +08:00
Wei Lin
1298da120d
Merge pull request #348 from isdaniel/isdaniel/add-ObsoleteAttribute
ObsoleteAttribte for not recommended method.
2022-03-26 20:25:34 +08:00
danielshih
c8e42a07b6 ObsoleteAttribte for not recommended method. 2022-03-26 13:45:24 +08:00
Wei Lin
bbb0601479
Merge pull request #346 from Weilence/feat-cache-sharedstrings
feat: cache sharedstrings in sqlite
2022-03-26 01:37:25 +08:00
罗威
b50044005a fix: unit test 2022-03-25 10:21:55 +08:00
罗威
ac5af32fcf fix: DbList clear 2022-03-25 09:24:35 +08:00
罗威
0c53afdafd chron: DbList use static count 2022-03-25 08:58:23 +08:00
罗威
ef8b834088 fix: cache test 2022-03-25 07:58:41 +08:00
罗威
65ad0f7e4c feat: cache sharedstrings in sqlite 2022-03-24 23:46:54 +08:00
Wei
bbe29ae1b3 [New] SaveAs support overwriteFile parameter for enable/unable overwriting exist file #307 2022-03-19 21:14:20 +08:00
Wei
60ef6fc856 Add unit test for nullable type mapping of SaveAs and Query 2022-03-18 17:02:20 +08:00
Wei
1be0e07eb7 1.24.3 2022-03-18 16:13:44 +08:00
Wei
33fd7dfc9d [Bug] Fixed when CultureInfo likesff-Latn , datareader field type is datetime that will get error OA Date format #343 2022-03-18 16:11:24 +08:00
Wei
7c065eb93e [Bug] Fixed multiple threads Async error 'The given key N was not present in the dictionary' #344 2022-03-18 13:29:50 +08:00
Wei
070e8924e6 1.24.2 2022-03-18 01:28:42 +08:00
Wei
03ce5b70c2 - [Bug] Fiexd Query multiple same title will cause startcell to get wrong column index #I4YCLQ
- [OPT] Optimize Query<T> algorithm
2022-03-18 01:27:47 +08:00
Wei
c5108d3a09 [Doc] update topic 2022-03-14 12:07:32 +08:00
Wei
9a92d74fa0 [Bug] Fixed QueryAsync not return dynamic type 2022-03-14 11:57:23 +08:00
Wei
309d649c64 [Bug] fixed QueryAsync configulation not working #338 2022-03-14 11:34:49 +08:00
Wei
73cc5fe583 Test : add gb2312 unit test 2022-03-14 09:09:35 +08:00
阿翰
f135392882
!4 新增MiniExcelDynamic类,解决多sheets遍历因sharedstring每次重复遍历导致速度很慢的问题
Merge pull request !4 from dzx815/master
2022-03-13 07:19:07 +00:00
dd
aeb569d1cb 新增MiniExcelDynamic类,对多sheet遍历提速 2022-03-13 15:04:52 +08:00
Wei
9d23e32c9b - [New] Query support strict open xml, thanks [Weilence (Lowell)](https://github.com/Weilence) #335
- [New] SaveAs use the configured CultureInfo to write format cell value, thanks [0xced (Cédric Luthi)](https://github.com/0xced) #333
- [New] SaveAsByTemplate will clean template string when parameter is IEnumerable and empty collection. #I4WM67
2022-03-09 23:15:11 +08:00
Wei
6ae635bf26 [New] SaveAsByTemplate default ignore template missing parameter key exception, OpenXmlConfiguration.IgnoreTemplateParameterMissing can control it. #I4WXFB 2022-03-09 22:48:15 +08:00
Wei Lin
15e92b3b25
Merge pull request #335 from Weilence/master
Support strict open xml
2022-03-09 08:09:35 +08:00
罗威
912a16b911 支持Strict Open Xml 2022-03-08 20:32:05 +08:00
罗威
f0bce37e82 支持Strict Open Xml 2022-03-08 18:24:29 +08:00
罗威
25f5811888 支持Strict Open Xml 2022-03-08 17:18:58 +08:00
罗威
a7a18b0040 支持Strict Open Xml 2022-03-08 17:18:04 +08:00
Wei Lin
1f24c671cb
Merge pull request #333 from 0xced/use-configured-culture
Use the configured culture when writing cell values
2022-03-08 08:51:17 +08:00
Cédric Luthi
1716567a5f Use the configured culture when writing cell values
This makes `TestIssue312()` pass on a computer where the current culture is a French culture. Assert.Equal("12,345.68", rows[1].A) would fail because the value would be serialized as `12 345,68` instead of `12,345.68`.

Also simplify the implementation of the Excel and CSV writers by getting rid of both `ExcelFormatToStringMethod` and `ExcelcultureToStringMethod` which are replaced by testing if the value implements the `IFormattable` interface.
2022-03-07 16:46:10 +01:00
Wei
e5cc813ab0 [Bug] SaveAs CSV when value is DataTable, if Key contains " then column name will not show "。 #I4WDA9 2022-03-04 16:39:13 +08:00
Wei
14586c739c [Bug] Fix when CultureInfo like Czech will get invalid output with decimal numbers #331 2022-03-03 11:42:46 +08:00
Wei
a222e2a4f8 [New] Support System.ComponentModel.DisplayName's [DisplayName] as title [#I4TXGT] 2022-02-16 16:20:42 +08:00
Wei
9b6c2c3d0d [Bug] Fix extra GetDataReader method 2022-02-14 16:37:35 +08:00
Wei
c46a03dfc7 [New] Support GetReader method #328 #290 2022-02-14 16:22:59 +08:00
Wei
d016c2c524 [New] New efficiency byte array Converter #327 2022-02-12 16:25:30 +08:00
Wei
4e076289d6 [Doc] update logo 2022-02-12 16:15:53 +08:00
Wei
3deedcb2e0 - [Breaking Change] Remove Byte Array to base64 Converter
- [Breaking Change] Replace `ConvertByteArrayToBase64String` by `EnableConvertByteArray`
2022-02-12 16:05:05 +08:00
Wei
f2f5e6d497 [Bug] SaveAs file error (Excel cell max length 32,767 characters) #327 2022-02-12 15:51:57 +08:00
Wei
5db234d019 - [New] SaveAs support to custom CultureInfo #316
- [New] Query support to custom CultureInfo #316
2022-02-12 09:51:08 +08:00
Wei
ebc05c508d [New] Query support to custom CultureInfo 2022-02-10 17:13:11 +08:00
Wei
e4b9a99e2e - [New] SaveAs CSV support to custom CultureInfo
- [Doc] Update logo icon
2022-02-08 10:53:47 +08:00
Wei
57751a2257 [Bug] Fix SaveAs multiple sheet value error "Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded." #325 2022-02-07 10:29:47 +08:00
Wei
67eddb9239 Doc : add donate link 2022-01-28 05:32:36 +08:00