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
Jed Samok
9de96abba8
add QueryRange test and docs.（#634） ( #635 )
2024-07-19 22:04:44 +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
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
Wei Lin
9eb23d9bdf
doc: update link
2024-03-31 23:45:13 +08:00
Wei Lin
cfdc452a98
doc: benefit link
2024-01-14 15:43:30 +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
bd1f7d5b21
[doc] Fix dapper query wrong description #552
2023-12-27 09:23:03 +08:00
Wei
b009975ca3
Doc : qq group - 3
2023-07-07 16:23:50 +08:00
Wei Lin
645a7cf87a
update version and doc cn
2023-05-28 12:24:22 +08:00
Wei Lin
6358ce4efd
doc : add chinese readme desc
2023-02-21 23:03:17 +08:00
Wei Lin
4a45f045c3
[New] support function to custom separator
2023-01-07 13:52:18 +08:00
Wei Lin
a319bdb682
update doc
2022-12-27 16:22:32 +08:00
Wei Lin
418a1093c4
[New] support excel enum description string to enum #289
2022-12-27 16:16:39 +08:00
Wei Lin
e662a8b28b
update video link
2022-12-27 10:14:10 +08:00
Wei Lin
b0a2d97923
update tutorial video link
2022-12-23 14:10:01 +08:00
Wei Lin
4138786cb5
Doc:Taobao Store
2022-11-27 20:49:21 +08:00
Wei Lin
a30d3bbda9
[New] SaveAs support FastMode
2022-11-09 22:44:52 +08:00
WeiLin
492ddd555a
doc update qq group 2
2022-09-22 22:37:13 +08:00
WeiLin
d4365111bc
[New] Support CSV Insert #I4X92G (via @shps951023)
2022-09-19 21:17:47 +08:00
WeiLin
379328afe8
1.26.3
...
- [OPT] Export default buffersize from 1024 bytes -> 1024 * 512 bytes
- [New] Export support custom buffersize
- [New] SaveAsByTemplate number use InvariantCulture (via @psxbox)
2022-06-07 23:42:23 +08:00
WeiLin
1fe758bedd
[Doc] fix spelling mistake
2022-05-02 15:34:43 +08:00
WeiLin
7b8ff93587
[Bug] Fixed DynamicColumnAttribute Ignore, Index error #377
2022-04-22 00:48:02 +08:00
WeiLin
227e0793d2
[Bug] Fixed DynamicColumnAttribute Ignore, Index error #377
2022-04-22 00:36:05 +08:00
Wei
bd236e666c
[Doc] update link
2022-04-18 13:23:50 +08:00
WeiLin
d5672af72a
[Doc] update 1.26.1 document
2022-04-17 16:15:09 +08:00
WeiLin
c197010b34
[New] Support dynamic column setting
2022-04-12 23:31:15 +08:00
Wei
2302d14ec8
- [New] support DynamicExcelColumnAttribute
...
- [Doc] ExcelColumnAttribute
2022-04-12 21:37:12 +08:00
Wei
13c8a01886
[doc] update release document
2022-04-04 01:23:41 +08:00
Wei
f9d3a2b370
- [Bug] Fixed QueryAsDataTable read big file will throw NotImplementedException #360
...
- [Doc] Reading big file by disk-base cache
2022-04-03 13:17:50 +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
c5108d3a09
[Doc] update topic
2022-03-14 12:07:32 +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
a222e2a4f8
[New] Support System.ComponentModel.DisplayName's [DisplayName] as title [#I4TXGT]
2022-02-16 16:20:42 +08:00
Wei
c46a03dfc7
[New] Support GetReader method #328 #290
2022-02-14 16:22:59 +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
67eddb9239
Doc : add donate link
2022-01-28 05:32:36 +08:00
Wei
a3693db188
[New] ExcelFormat support DateTimeOffset/Decimal/double etc. type format #I49RZH #312 #305
2022-01-22 17:02:16 +08:00
Wei
1416af71c0
- [New] Support byte file import/export
...
- [New] SaveAs support to convert byte[] value to base64 string
- [New] Query support to convert base64 value to byte[]
- [New] OpenXmlConfiguration add `ConvertByteArrayToBase64String` to turn on/off base64 convertor
2022-01-21 17:21:14 +08:00
Wei
0ee399d4f0
- New : SaveAs support convert bytes to base64 to store data #318
...
- Fix : File convert to base64 value out of cell
#319
2022-01-21 15:12:48 +08:00
Wei
45e4a57c20
[New] SaveAs support image #304
2022-01-21 12:01:22 +08:00
