Top "Closedxml" questions

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

ClosedXML find last row number

I'm using ClosedXML with C# to modify an Excel workbook. I need to find the last row number used but .…

c# excel visual-studio closedxml
ClosedXML add image

I am able to add in an image to an excel spreadsheet by using OpenXML. However for the rest of …

image cell add openxml closedxml
Date Formatting in ClosedXML

I have date's in an excel sheet that I am reading from. What I like to do is to force …

closedxml
How to format currency in ClosedXML as numeric

we're using ClosedXML to convert datatable objects into Excel spreadsheets for presentation to the user. The DataTable object is build …

c# excel closedxml
ClosedXML: Working with percents, 1 decimal place and rounding?

I am attempting to use C# and ClosedXML to enter data into an excel sheet. I have found most of …

c# rounding decimal closedxml
ClosedXML Format cell to contain formula

I'm hoping someone can help me with ClosedXML as I'm new to Excel exporting and from what I've seen of …

c# asp.net webforms closedxml
Keep excel cell format as text with "date like" data

This seems silly, but I haven't been able to get my values in the format of #/#### to write as the …

c# asp.net excel closedxml
Autofit column in ClosedXML.Excel

I understand that the question stupid and from FAQ, but i cant set auto width in excel columns (using ClosedXML.…

c# .net excel xls closedxml
export Gridview to Excel using ClosedXML without warning: the file you are trying to open is in a different format

I am working on a ASP.NET 4.5 Webform and I have a Gridview (that has custom TemplateField and gets data …

c# asp.net gridview export-to-excel closedxml
ClosedXML iterate Worksheets programmatically.

In my Workbook, I have 4 worksheets with different tab names. Say if they are named as follows: First, Second, Third, …

c# closedxml