arch / fluentexcel Goto Github PK

Designing a extension point for easy extend the exist functionalities. Such as FromAnnotations() like @tupunco done.

Currently, the the first row is the title row, but, in some cases (e.g. exporting to the specify excel template, the title row had exist), the title row SHOULD be ignored.

Currently, if without any configuration, the default behavior is using the POCO's property as title, but the better solution is:
assume the property name is PropertyName, the title SHOULD be Property Name

Add fc.Property(r => r.PropName).HasConverter(Func<object, object> converter) method like @tupunco done.

麻烦问下 怎么锁定某行或锁定某列

Hello, I'd like to let you know that I'd like to do a lot of modification basing on your code soon. The main purpose is to mitigate the performance issue of NPOI while processing large excel file. I'm currently considering using EPPlus or something else as the underlying layer. And I may also do other changes too.
So here to make you aware of it. And I'd like to also know from you that if it's OK to still use the word "FluentExcel" in the name of this mentioned new project or should I choose another name?

Glad to hear from you. Thank you.

我需要按照姓名和出诊日期来合并，我使用fluentexcel导出的excel

as per title and exception is Invalid column index (-1). I guess is the config index is -1 when AutoIndex is set to ture

Hi!
Is it possible to change title cell style in an easy way? Currently it is hardcoded in IEnumerableNpoiExtensions.cs.

Excel.Load执行完毕后，MemoryStream 被自动释放了，由于该流对象还需要进行二次使用，故此我认为Load方法不应该释放外部的流对象

Currently we using ToExcel to save the IEnumerable to excel file, but in .NET work, the name SaveTo is more idioms

Currently, all the data will be save to one sheet, but, if the data is very very large, the excel maybe throw OutOfMemoryException, so SHOULD provides some methods to split the data to multiple sheets.

导出字节流 标题变成了 1PX

1、当我获取一个 Excel 表格，但是我无法确定它有多少列, 应该如何准确的获取它。我尽可能需要获取 标题头。
2、如何导出 DataTable 以及 dynamic 类型的数据

您好，我想咨询下能否用FluentExcel写入图片

不对.NET更新了吗? 而专注 Core 更新吗？

Currently only load the data from excel first sheet or specified sheet, but if the data very very large, SHOULD support load from multiple sheets.