Excel Worksheet contains 60K records. Needs to be read and store into DataTable. Currently reading row by row. Is there any other better way using ClosedXml. DataTable dt = new DataTable(); var wb ...

I'm using ClosedXML to generate a report. The data supplied to Excel is from a database which is stored to a DataTable object. The table is displayed fine in the Excel sheet - however, it has a def...

I'm hoping someone can help me with ClosedXML as I'm new to Excel exporting and from what I've seen of ClosedXML the documentation is fairly limited in certain areas. At the moment I'm putting dat...

I have multiple datatables with data and I would like to add those in single sheet with space. I am using ClosedXML to develop export excel utility.

All How can I download a file so the user sees that it is downloading (like with a stream?) I am currently using ClosedXML, but if I use the SaveAs method, I have to give a hard-coded URL, and if...

I just got started with ClosedXML. When I create a new workbook with the code below, it automatically applies "Blue, Table Style Light 9" to each worksheet. I don't want any style on the worksheets...

This is how to merge cell using ClosedXML based on the documentation. worksheet.Range("B2:D3").Row(1).Merge(); My problem is my column count is dynamic, I can't set column letter value to merge ...

With ClosedXML I am trying to add data to an existing Excel Sheet In an Existing Table. The easy thing to do is to add a table to an excel sheet below is a quick example of how to do that. What I d...

I'm trying to color an entire row based on a cell selection(value).I want to change the color of the row just for the used range in my worksheet but not for unused cells. Here's the code I have ri...

I would like to read the contents of an Excel worksheet into a C# DataTable. The Excel worksheet could have a variable numbers of columns and rows. The first row in the Excel worksheet will always ...

I am able to add in an image to an excel spreadsheet by using OpenXML. However for the rest of the program I use ClosedXML to add data. I can add data at a specific cell using the column and row in...

I generate an Excel file with ClosedXML and I want to know how can I do a Carriage Return Within a Cell?

I'm having an issue when I try to change the format of an entire column. My issue is that I don't get the XLCellValues operand. I am able to choose XLDataType.Text but that does not work. This is ...

I am trying to achieve the following in an Excel VSTO add-in: Copying/applying cell formatting from the original version of an Excel file. Reason: while processing Excel files, we occasionally ne...

I have implemented Excel template download in my project. I used ClosedXML. I have two excel sheets Sheet1: In this sheet, I have a column called Type in which I can create Dropdown List and it is ...

When I add a worksheet via a DataTable, I would expect the date formats to follow the locale/culture of the application but it appears to take that from the computer. string culture = "en-GB"; var...

Is it possible to save a worksheet of a workbook as CSV via ClosedXML? For example: var workbook = new XLWorkbook(fileName); IXLWorksheet worksheet; workbook.Worksheets.TryGetWorksheet(sheetName,...

I want to be able to find if a particular string exists in a range using ClosedXML, however, I cannot find any find command in the documentation. Currently I loop through 1000s of rows to find if t...

I have created WebAPI which returns an excel file using closedxml nuget. Basically it converts my DataTable to excel. I'm referring couple of links below, How to return a file (FileContentResult)...

Using latest Closed XML (0.76) on Net 4.5.1 Created a Worksheet with a table by: DataTable Table = ... var DataWorkSheet = Workbook.Worksheets.Any(x => x.Name == "Data") ? Workbook .Works...

I am trying to export some data to an excel sheet S1 whose data would be shown as Pivoted views in the next two sheets S2 and S3. I am able to create a single pivot and it works perfect. But when I...

How to use different colors of texts in the same Excel cell using ClosedXML? worksheet.Cell(1,1).Value.Character[StartIndex, NoOfChar].Font.Color....?? ClosedXML doesn't have something like above...

There are several textboxes in an excel file as ActiveX objects and I want to reach them from codebehind. I am using ClosedXML for other fields, but I am open for other suggestions.

I am using PowerShell 3 and ClosedXML to write file information into an excel worksheet. In one of the cells I need to set the background color to a light blue (cornflower blue or 219, 229, 249 in ...

I am using closedXML to generate a XML file(in arabic) and i need this file to be in right to left layout how can it do this in closedXML. XLWorkbook wb = new XLWorkbook(); var ws = wb.Worksheets....