EPPlus is a .net library that reads and writes Excel 2007/2010 files using the Open Office Xml format (xlsx).
EPPlus is a .net library that reads and writes Excel 2007/2010 files using the Open Office Xml format (xlsx).
Questions tagged [epplus-4]
189 questions
0
votes
0 answers
How to loop a >> of Json.net to convert an excel file using EPPUS
How to loop a >> of Json.net to convert an excel file using EPPUS
var resposneJson1 = JsonConvert.DeserializeObject>>(parametroJson);
I have to retrieve the names of the fields to…
ararb78
- 1,137
- 5
- 19
- 44
0
votes
0 answers
Write Long Set Of Headers To Excel Using EPPlus
I'm using EPPlus to write data to Excel, which works great. I'm writing a header row from column A to column AI and am using the code below to write the data
(subset of the code)
using (ExcelPackage pck = new ExcelPackage())
{
ExcelWorksheet ws…
James Mandatory
- 81
- 6
0
votes
1 answer
EPPlus - Countifs with wild cards are not calculating when running Workbook.Calculate in EPP5
I have an excel template that I write data to using EPP5.
When I run the ExcelPackage.Workbook.Calculate() method no error is thrown. When I go to open the workbook, it still needs to calculate the fields that contain countifs formulas with wild…
Nyxus
- 1
- 1
0
votes
1 answer
How to remove the Related People (Author and Modified By) property of Excel file using EPPlus in C#
I am using the EPPlus to create an excel file. Now I want to remove the Related People (Author and Modified By) property of the Excel file.
How can I do this?
Viveka
- 340
- 2
- 14
0
votes
1 answer
How do I Change the font of the text in a Button Control
I am using EPLUS to create a button and I would like to change the font and font size of the text in the button. How do I do it?
Kerry Smith
- 1
- 1
0
votes
1 answer
Relationships between multiple tables in EPPplus?
I wish to create a PivotTable that relies on a Data Model that takes from three Tables already defined in my workbook. Unfortunately I cannot find how to do this.
What I've done so far:
The code I have written to create a sample Excel file with…
Ross Presser
- 6,027
- 1
- 34
- 66
0
votes
0 answers
Epplus convert range object to c# model
I want to convert an ExcelRange object into a model object
Currently, I have the code to get the range in a row
var row = sheet.Dimension.Start.Row + 1;
var lastCol = sheet.Dimension.End.Column;
var endRow = sheet.Dimension.End.Row;
for (; row <=…
Rashid
- 1,700
- 1
- 23
- 56
0
votes
0 answers
Generate pivottable for multiple tabgles
good day
i have following information in my sheets:
information about events (id, date, name, etc)
list of users (id, name)
list of participants (id, name)
list of user linked to event (id, eventid, userid)
list of participant linked to event (id,…
Anatoly Kryzhanovsky
- 81
- 1
- 5
0
votes
1 answer
Stuck generating + sending .xlsx file from ASP.NET Web API backend to Vue.js frontend
I am trying to generate an excel file in my ASP.NET Web API backend, and send it to my Vue.js front end for download.
The API request is being made by calling getQueryResults:
const apiClient = axios.create({
baseURL: process.env.NODE_ENV ==…
asdfq321
- 21
- 6
0
votes
0 answers
EPPlus producing an empty Excel file after SaveAs
I'm using the latest 4.5.3.3 nuget version. .NET 4.6.1.
No issues if I create an excel file from scratch, but if I need to update an existing one, even if passing it to the ExcelPackage ctor and calling a ExcelPackage.Save after updating the data,…
desknotes
- 1
- 1
0
votes
1 answer
EPPlus LoadFromCollection always put values in one column
I want to set each element of collection in one row, but they are always added in one column, not row.
var headers = new List {...};
var row = 4;
worksheet.Cells[row, 2, row, headers.Count()].LoadFromCollection(headers);
From code - I…
demo
- 6,038
- 19
- 75
- 149
0
votes
1 answer
Unable to retrieve actual formula result in EPPLUS
I'm creating new .xlsx file using the template.xltx file. The template file(Template.xltx) contains Table and formulas. The Formula is added in .xltx file, in order to validate if the Table has data or not.
When I tried to retrieve the final result…
0
votes
0 answers
Setting Row Height not working for EPPlus
I am trying to set up the height in an existing excel sheet with EPPlus. It does not seem to be working at all. Any idea on what else I could try ?
I have tried setting it before and after initial styling and have tried setting it after filling…
Jerome Reyes
- 17
- 1
- 5
0
votes
1 answer
Epplus LoadFromData set with byteArray to ExcelPicture
I have a working excel export for my dataSet however I would like to add images to the export, currently they are saved as byteArrays and show up in the export as System.byteArray how can I get this to display an image.
The data set is very large…
BOT_Billy
- 41
- 4
0
votes
1 answer
EPPlus - Unable to get values of NPV and IRR functions from excel
I have a model in excel and trying to feed inputs through ASP.NET to the excel and returning the back the model results over the grid in the front end. I'm using EPPlus package in ASP.NET as it doesn't need MS Office to be installed.
I have trouble…
Chendur
- 1,099
- 1
- 11
- 23