closedxml Questions
2
Solved
According to the documentation you can add conditional formatting to a cell using the syntax:
.AddConditionalFormat().WhenEquals("=B1")
So I tried this:
cell.AddConditionalFormat().WhenEquals("...
Illaffected asked 15/9, 2015 at 10:21
4
I am working on a ASP.NET 4.5 Webform and I have a Gridview (that has custom TemplateField and gets data from a sqlDataSource)
I have this event to export the gridview contents to an excel sheet, ...
Glutton asked 11/2, 2016 at 23:5
1
Solved
I'm trying to add an empty row before filling my excel document.
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
using (XLWorkbook wb = new XLWorkbook())
{
var ws = wb.Worksheets.Add(d...
1
From a datatable I want to remove headers. How can I remove headers or first row which includes the headers.
if (dt.Rows.Count > 0)
{
using (XLWorkbook wb = new XLWorkbook())
{
wb.Worksheets...
3
Solved
I am approaching to export a big amount of data (115.000 rows x 30 columnd) in Excel OpenXML Format (xlsx).
I am using some libraries like DocumentFormat.OpenXML, ClosedXML, NPOI.
With each of thi...
1
Solved
I'm working on a C#/ASP.NET web thing and want to do an Excel export. First I found OpenXML, made some first steps, but it's really hard to use. Now, I'm using ClosedXML and it's quite a relief - s...
Selfsufficient asked 17/7, 2015 at 11:7
1
To reproduce the issue, I created a console project and below is the code in my Program.cs file:
using System;
using System.IO;
using System.Threading;
using ClosedXML.Excel;
namespace TestSaving...
1
Solved
In my Workbook, I have 4 worksheets with different tab names.
Say if they are named as follows: First, Second, Third, Fourth.
I could not find online how to iterate through each of the worksheet w...
1
I'm trying to choose between ClosedXML, EPPlus, and possibly SpreadsheetLight. What reasons might I consider for picking one over the others?
Flagstaff asked 8/5, 2012 at 15:19
1
Solved
I need to append new data to existing excel file created with ClosedXML.
How can I append to an excel file using ClosedXML?
How can I get the row number of the last record and append to that or is...
3
Solved
Using closedXML C# library, How can I figure out what data is causing this error when trying to save
I have a C# app that exports to Excel using ClosedXML. It works fine but just ran into an issue where when i hit the :
var ms = new MemoryStream();
workbook.SaveAs(ms);
I get an exception:
' ...
1
Solved
I am attempting to use C# and ClosedXML to enter data into an excel sheet. I have found most of the things I am looking for, however I am having some issues getting ClosedXML to take care of the nu...
© 2022 - 2024 — McMap. All rights reserved.