closedxml Questions
4
Solved
I am using ClosedXML to generate spreadsheets from C# (asp.net-mvc) and it works great. I have one additional requirement so I wanted to get some feedback on how I could achieve this.
I want to sa...
Kinata asked 1/4, 2014 at 13:6
5
Solved
I am using ClosedXML to export an Excel file and I can't seem to export the Excel file. Every time I click on the Button to Export the Excel File(XLSX) I get an error. See Below...
using (XLWorkb...
7
This is my code to add a picture to a worksheet. I get the picture as a byte from the database. .Net Core framework version is 2.2.104. This is an API project. In my locale, the code works well. I ...
Develop asked 14/4, 2021 at 12:24
3
Solved
I'm using closedxml to export excel..
Now i can protect (Lock cell) cell using the following function,
workSheet.Cell(rowIndex,column).Style.Protection.SetLocked(true);
I want to set group of c...
Traumatism asked 29/11, 2013 at 12:46
2
Solved
I have a table data in Excel
I want to apply style broder as image
How to code script in C# using ClosedXML?
6
Solved
I am facing a weird problem in closedXML library.
I am exporting a datatable to .xlsx (excel file) using closedXML library.
By default, autofilter is enabled in the library.
I want to disable or ...
5
Solved
3
I get an error using the Microsoft ClosedXml and DocumentFormat.OpenXml NuGet utility packages. After I updated these NuGet packages, (from version 2.7.2 to version 2.8.1), I now get this exception...
Patrol asked 4/4, 2018 at 13:42
4
Solved
I have similar question about ClosedXML, like this one but a little bit diferent.
The SetDataType method does not work.
For example, I have value
string dps = "3.12.02"
which is not a date nor numb...
5
Solved
we're using ClosedXML to convert datatable objects into Excel spreadsheets for presentation to the user. The DataTable object is build simply by assigning all db values (from NHibernate) to strings...
6
Solved
I am trying to use ClosedXML to produce excel documents within an application however when ever I try to run it I receive a could not load file or assembly server error.
Could not load file or as...
2
Solved
I see a lot of examples in documentation where data type for a cell is set:
ws.Cell(1, 1).SetDataType(XLCellValues.Text);
But when I try to set a data type for a column:
ws.Column(1).SetDataTyp...
2
Solved
I need to install ClosedXML dependency to build a C# project with .net framework 4.7.2 but when trying to install I always get the same error: "Cannot resolve dependency 'SixLabors.Fonts'. Sou...
Clearance asked 13/12, 2022 at 15:26
1
Solved
While attempting to construct an Excel file using ClosedXML, I have come across some unexpected behavior regarding memory streams. In the debugger, I can see that MemoryStream ms is being populated...
Euniceeunuch asked 2/8, 2022 at 16:53
3
I have date's in an excel sheet that I am reading from.
What I like to do is to force the date to be in mm/dd/yyyy
Is there a way to do this in Closed XML.
I took at a look https://closedxml.code...
Derinna asked 29/7, 2015 at 19:27
5
Solved
I'm using ClosedXML with C# to modify an Excel workbook. I need to find the last row number used but .RowCount() counts how many rows are in the worksheet. So it is returning 1 million rows when th...
Dialectology asked 31/1, 2017 at 21:14
1
Solved
i'm using closedXml to export data to Excel. But my columns need to be adjusted to the content therefore i've tried to specify the colums width by hand:
var ws = workbook.Worksheets.Add("Colum...
3
Solved
1
I want to load an excel file into XLWorkbook
using var workbook = new XLWorkbook("iFormFile needs to go here");
var ws = workbook.Worksheet(1);
Jeopardy asked 18/3, 2022 at 6:46
5
Solved
I create cell with text. After that I set WrapText property and column width.
var cell = worksheet.Cell("A1");
cell.Style.Alignment.WrapText = true;
cell.SetValue("This is very long text");
worksh...
4
Solved
ClosedXml does not allow to insert minimum datetime into cell. My datatable includes minimum datetime values that ClosedXml does not like.
using (var workbook = new XLWorkbook())
{
var dataTable ...
6
The problem is that the cell content is not wrapped, when that cell contains a formula referring to a cell with some long string.
On CodePlex I found a thread on this issue and a simple code to se...
3
How to create charts in excel,While exporting data from database to excel sheet..!
I'm exporting data to excel from database.I need to create chart in the excel sheet based on data from database. ...
Hyetograph asked 5/7, 2016 at 10:58
0
Like the title says. Lots of examples online for uploading files to backend but I'm after verification client side/offline followed by an upload of data only (no files). In theory, anything that ru...
Grapple asked 6/6, 2021 at 19:37
2
Solved
I have an excel worksheet that has column headers and I don't want to hard code the column letter or index so I am trying to figure out how I could make it dynamic. I am looking for something like ...
1 Next >
© 2022 - 2024 — McMap. All rights reserved.