Top "Closedxml" questions

In ClosedXML, is there anyway to get the column letter from column header name?

I have an excel worksheet that has column headers and I don't want to hard code the column letter or …

c# closedxml

How to append a new row to an Excel file using C# and ClosedXML?

I should append a new row to an existing Excel file. The task consists of two parts: Add to non-existing …

c# excel closedxml

ClosedXML - Add a new row without overwrite data (first line)

I'm trying to add an empty row before filling my excel document. using (DataTable dt = new DataTable()) { sda.Fill(dt); …

c# closedxml

Export big amount of data from XLSX - OutOfMemoryException

I am approaching to export a big amount of data (115.000 rows x 30 columnd) in Excel OpenXML Format (xlsx). I am …

.net openxml xlsx closedxml

Why close xml does not support .xls formated excel file?

During accessing ".xls" formated excel file using "closed xml" dll following exception is occurred Exception : Excel may contain corrupted data...

c# closedxml

How to disable autofilter in closedXml c#?

I am facing a weird problem in closedXML library. I am exporting a datatable to .xlsx (excel file) using closedXML …

c# excel closedxml

Can I save an EXCEL worksheet as CSV via ClosedXML?

Is it possible to save a worksheet of a workbook as CSV via ClosedXML? For example: var workbook = new XLWorkbook(…

c# .net excel closedxml

How to Remove header from datatable at the time of export to Excel?

From a datatable I want to remove headers. How can I remove headers or first row which includes the headers. …

c# closedxml

How can I embed some VBA code into a spreadsheet created using ClosedXML?

I am using ClosedXML to generate spreadsheets from C# (asp.net-mvc) and it works great. I have one additional requirement …

c# asp.net-mvc excel openxml closedxml