Stack Overflow
Stack Overflow

Questions tagged [closedxml]

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

ClosedXML is a .NET library for reading, manipulating and writing Excel 2007+ (.xlsx, .xlsm) files. It aims to provide an intuitive and user-friendly interface to dealing with the underlying OpenXML API.

ClosedXML provides a object oriented way to manipulate Excel 2007+ (.xlsx, .xlsm, etc) files (similar to VBA) without dealing with the hassles of XML Documents. It can be used by any .NET language like C# and Visual Basic (VB).

Online resources:

615 questions
-1
votes
1 answer

How can I debug external code in Visual Studio 2019 when there is no PDB available?

I am trying to debug some issues occurring within an external library (ClosedXML). If I can work out exactly what's going wrong, I should be able to apply workarounds to the code that calls it. I have added ClosedXML and manage it via…
Sepia
  • 447
  • 6
  • 21
-1
votes
1 answer

Names of all page columns

How can I use ClosedXML to get a list of all the used columns in an excel table? This is how columns are issued for all cells. I didn't find a suitable method only for columns var cells = source_sheet.CellsUsed(); foreach (var c in cells) {} Pulled…
Alex Pertenava
  • 17
  • 4
-1
votes
2 answers

C# ClosedXML Table Theme list

Is there any documentation or article listing the Table themes along with displaying the styles for excel workbooks in ClosedXML library. I am unable to find anything on this in their github documentation.
user9057272
  • 367
  • 2
  • 5
  • 17
-1
votes
1 answer

Read a Workbook and add new worksheets then SaveAs(memorystream) using ClosedXML Thorw Exception "Specified method is not supported."

I read an excel workbook using ClosedXML and add new sheets to it. But when I try to workBook.SaveAs(memoryStream), it throws an exception "Specified method is not supported.". var responseContent = await…
Ashish Jain
  • 1
-1
votes
1 answer

.Net Core Export excell

Hi I'm trying to make export and return excell function with ClosedXml package. It works fine on demo project. I gotta make it for original project so this is the code.It's a IActionResult public class HomeController : Controller { …
pandakun
  • 55
  • 9
-1
votes
1 answer

How to read Excel Dropdown value using ClosedXML

I have a excel which has some fields as a dropdown, need to get entire list of the dropdown has. I tried to use the ClosedXML for this. I can able to find whether it is list or not. But unable to read the entire list? using(var workbook = new…
Ram
  • 1
-1
votes
1 answer

Closed XML data validation for allowing any numbers

I want to add data validation such that it allows only numbers.CLOSED XML
Sagar N H
  • 3
  • 1
-1
votes
1 answer

Error adding image when exporting excel using ClosedXML library

I am trying to use a ClosedXML.Excel XLWorkbook dll to export Excel, but when trying to use an image, I get the following error: Cannot convert Closedxml.excel.IXLAddress to Closedxml.excel.IXLCell: var image =…
Danilo
  • 148
  • 9
-1
votes
1 answer

How to open a protected Excel File with ClosedXML?

Is it possible to use ClosedXML to open an Excel file protected with a password? And if so, how? I tried using Interop but it's very slow. Using Interop.Excel Microsoft.Office.Interop.Excel.Application wb = xlApp.Workbooks.Open(Filename:…
user2988717
  • 127
  • 3
  • 8
-1
votes
1 answer

Excel Chart doesnt show/missing in existing template when using ClosedXML after exporting

Excel Chart doesnt show/missing in existing template when using ClosedXML after exporting. Everytime I Export to the existing excel file with chart, the chart will disappear. I don't know why. Please give me some solution.
Israel
  • 37
  • 4
-1
votes
1 answer

Unable to read formula related to other sheet using closedxml

I am reading excel steam and converting it to a workbook using closedxml. The workbook has 2 sheets. The first sheet has a cell that has a formula that references the second sheet. When i read to read this cell, i get an exception. Is this an…
krishnaprasad parthasarathy
  • 13
  • 6
-1
votes
1 answer

Formatting '[$-F400]h:mm:ss\\ AM/PM' Excel 2007 date time in c#

I'm trying to read Excel 2007+ files in c# but all the libraries I have tried so far (OpenXML, ClosedXML and NPOI) seem unable to parse a cell with the time format correctly. In Excel the data is formatted as Number > Time and uses '*hh:mm:ss' as…
Barker1889
  • 53
  • 6
-2
votes
2 answers

Most effective way to duplicate an Excel worksheet?

I am working on a project upgrading a WPF program that has to work with Excel sheets a lot. It's using Closedxml and Excel interop to manipulate Excel files and add data. After some trace I found a function that's painfully slow. It use the same…
MarioWu
  • 73
  • 1
  • 13
1 2 3
…
40
41