XLSB files cannot be read

first post: LucasNET2 wrote: Hi, first I would like to thank for this software, its amazing. I d...

latest post: MDeLeon wrote: ClosedXML doesn't handle .xlsb files because it's essentially a wra...

Does ClosedXML resolve OpenXML's package issue when writing excel files greater than 10MB?

first post: MichaelMcCoy wrote: Hi, When writing an excel file greater than 10MB in size on a web...

latest post: MDeLeon wrote: ClosedXML doesn't use FeedData so you should be in the clear. That ...

Empty cells value on header

first post: DamienDuff wrote: I have a problem where clearing or simply inserting an empty value ...

latest post: MDeLeon wrote: You can't have a table with an empty header/column. Excel doesn't a...

Applyiing password in excel file using closedXml

first post: hasham123 wrote: Hi, I have a requirement where i have to write data to excelwork...

Bijective base-26

first post: jeremyjee wrote: Hi, FWIW, i've written a much less featured xlsx reader/writer for ...

latest post: MDeLeon wrote: Ran another test and GetColumnNumberFromLetter is actually an order...

Possible to Group Columns in Pivot Table

first post: achapin wrote: I've successfully used ClosedXML to generate a pivot table, but the...

latest post: achapin wrote: Eh, it finally occurred to me I could just add a field to the table...

Protecting sheet

first post: pradeep1310 wrote: Hello team, I am trying to protect a sheet with the password and ...

Copying ranges with formulas using absolute references

first post: Roma8716 wrote: Hi I have a template file that is populated from my database. So ...

latest post: MDeLeon wrote: I need an easy way to reproduce the problem. The following works: ...

Protect Workbook

first post: Shib_avf wrote: Hi , I am using 0.59.0.0 version. How can i protect the entire Wor...

latest post: BODow wrote: I 'm waiting also for the workbook protection feature! Thanks for y...

Pivot table "Value Field Settings"

first post: TyrionL wrote: Hey there. I've been trying to use ClosedXML to generate a group ...