Top "Closedxml" questions

ClosedXML is a .NET library for reading, manipulating and writing Excel 2007+ (.xlsx, .xlsm) files.

Reading from Excel File using ClosedXML

My Excel file is not in tabular data. I am trying to read from an excel file. I have sections …

c# closedxml
Download file with ClosedXML

All How can I download a file so the user sees that it is downloading (like with a stream?) I …

c# asp.net closedxml
How to make Excel wrap text in formula cell with ClosedXml

The problem is that the cell content is not wrapped, when that cell contains a formula referring to a cell …

c# excel closedxml
What are the differences between the EPPlus and ClosedXML libraries for working with OpenXML?

I'm trying to choose between ClosedXML, EPPlus, and possibly SpreadsheetLight. What reasons might I consider for picking one over the …

.net openxml office-2007 closedxml
Append to excel file with ClosedXML

I need to append new data to existing excel file created with ClosedXML. How can I append to an excel …

c# excel closedxml
Using ClosedXML how to adjust row height to content?

I create cell with text. After that I set WrapText property and column width. var cell = worksheet.Cell("A1"); cell.…

c# closedxml
How to set a data type for a column with ClosedXML?

I see a lot of examples in documentation where data type for a cell is set: ws.Cell(1, 1).SetDataType(XLCellValues.…

c# closedxml
Download an excel file in JQuery-AJAX request from ASP.NET MVC

In my ASP.NET MVC project, I generated a excel file using ClosedXML. It works well in non-ajax call. Here …

jquery ajax asp.net-mvc download closedxml
Read Excel worksheet into DataTable using ClosedXML

I would like to read the contents of an Excel worksheet into a C# DataTable. The Excel worksheet could have …

excel datatable closedxml
ClosedXML - Could not load file or assembly

I am trying to use ClosedXML to produce excel documents within an application however when ever I try to run …

.net closedxml