Change title cell style?

[simonqbs]

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

[rigofunc]

Good suggestion, disable style setting or change the background/foreground color?

[simonqbs]

Both options would be good to have, and also what kind of fill pattern to use maybe.

[mrtylerzhou]

I have the same question,the checker header style does't looks very good.It is better that user can customize or by default remove it.

[rigofunc]

This weekend will release a version for fixing this issues

[mrtylerzhou]

Also address another small problem,when use the toExcelContent extension method to export excel file as attachment,it is ok to set the extension as xlsx, but to set it as xls,when open the exported file,excel will give an alert that the file is corrupted or unsafe,do you want to open it anyway?.Though the file itself is not corrupted at all and everything just fine when open it.but the alert is annoying.I do not know whether you have ever came across with this problem,i guess that maybe the same content(xxx.toExcencontent) treated as both xls and xlsx cause the problem.

[rigofunc]

Had a fix for this. Use following code to disable title cell style

Excel.Setting.TitleCellStyleApplier = null;

[rigofunc]

@simonqbs @mrtylerzhou v1.2.2 had been released for fixing this issues

[rigofunc]

@mrtylerzhou

Also address another small problem,when use the toExcelContent extension method to export excel file as attachment,it is ok to set the extension as xlsx, but to set it as xls,when open the exported file,excel will give an alert that the file is corrupted or unsafe,do you want to open it anyway?.Though the file itself is not corrupted at all and everything just fine when open it.but the alert is annoying.I do not know whether you have ever came across with this problem,i guess that maybe the same content(xxx.toExcencontent) treated as both xls and xlsx cause the problem.

this fix release not solve this issues

[mrtylerzhou]

thanks for your clarification