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
2
votes
2 answers
EPPlus : date column returning int rather than the actual displayed text value
I am using EPPlus to read excel data. I need to display the excel cells as-is in the grid to the users.
while reading date column EPPlus is giving the OADate int value for the date.
Is there a way I can read the value as string, which users…
harishr
- 17,807
- 9
- 78
- 125
1
vote
1 answer
EEPlus export only works once. When I trigger the button again it won't work when exporting data objects to an excel file
I am trying to create an export to excel from a data object and I am using EPPlus.
EEPlus export only works once. When I trigger the button again it won't work when exporting data objects to an excel file.
This is the code for my button and I am…
chir
- 21
- 2
1
vote
0 answers
EPPLUS - Issue with formulas not working on cells
I am using the excellent EPPLUS library to add a record to an excel spreadsheet.
workSheet.Cells[CurrentRow, ExcelColIndex].FormulaR1C1 = "=IF(G3="Yes",0,NUMBERVALUE(F3))";
workSheet.Calculate();
The code works and the spreadsheet is successfully…
SenthilVijayan
- 11
- 1
1
vote
2 answers
EPPlus returns #VALUE! instead of Value from the cell content randomly [epplus]
As per Current requirement I need to read value from the cell using EPPlus. This cell contains the formula and showing value correctly in XL Sheet. but when i am reading that value using EPPlus some cells are giving correct value but some cells are…
nittin aggarwal
- 31
- 8
1
vote
1 answer
Charts created by EPPlus 4.1 library in .xlsx format are not displaying in openoffice or libreoffice
Charts created by EPplus in C# is not displaying in LibreOffice and OpenOffice, but they are displayed properly in Microsoft office.
There is one workaround, if i open the excel file in microsoft office and then save it again that file charts are…
Rahul Singh
- 65
- 1
- 4
1
vote
1 answer
Which is the last commit for version 4.5.3.3 of EPPlus?
I am looking for the last LGPL version of EPPlus, namely 4.5.3.3.
Digging through Github I didn't find it.
Nuget does not point to the exact code/commit.
It is a license question, like if I want to fork the last LGPL version.
Update
Found it at…
LosManos
- 7,195
- 6
- 56
- 107
1
vote
1 answer
EPPlus To Copy Worksheet From Workbook1 to Workbook2
I have a template workbook with a sheet called ProdData, I need to copy this worksheet to my current workbook.
Using C# and EPPlus, how can I copy a worksheet from one workbook to another? When I look at intellisense it seems to only show that I…
James Mandatory
- 81
- 6
1
vote
1 answer
Change cell background color based on cell's text in excel using C# EPPlus
I am trying to change cell's background color based on its text content. Eg: for text = "In progress" it should be Yellow, for text ="Completed" it should be Green. Not getting any clue to proceed with automation using C#.
Referred the below links…
b_J
- 115
- 10
1
vote
1 answer
Why I can not delete row in Excel?
I use EPPlus to delete only one row with index 10 using this code:
using (var p = new ExcelPackage(fi))
{
var ws = p.Workbook.Worksheets[1];
ws.DeleteRow(10, 1);
}
When I save output file I see that row is exist in file:
p.SaveAs(new…
POV
- 11,293
- 34
- 107
- 201
1
vote
0 answers
EPPLUS Breaking Charts, formatting, etc. in existing excel file
Using Excel 2013, EPPlus 4.5.3.
I have an existing simple excel file with one datasheet called "Data" that has columns formatted and ready to accept data (columns are set appropriately as Date, Numeric, etc. for the data I will put there).
There are…
richard
- 12,263
- 23
- 95
- 151
1
vote
2 answers
c# EPPlus: how to fix - ShowFilter doesn't work
The issue with Table.ShowFilter, using EPPLUS library.
Created new ExcelTable in the sheet, but can't apply Table.ShowFilter = false.
The filters are still in the table.
TableStyle and StyleName work fine.
ExcelTable et = (ExcelTable)Table;
int…
Sergey
- 47
- 5
1
vote
0 answers
EPPlus set workbook to SHARED
I want to set my workbook to shared at the time of it's creation using the EPPlus library. Is this possible? I have found no resource showing me how to do this. I thought maybe this property would do the trick, but it doesn't seem to work:
var…
Roka
- 444
- 5
- 23
1
vote
0 answers
EPPlus LoadingFromCollection to use toString of Object for a Column
My question relates to EPPlus 4.5.2.1 and the .LoadFromCollection() method. I am using this in a .NET Core 2.1 MVC project to retrieve data from the DB into a model and push it into an Excel file for download.
Let's say we have an…
Avogadro
- 353
- 2
- 11
1
vote
1 answer
How can i get a DataType of a specific cell with EpPlus?
How can i get a DataType of a specific cell with EpPlus while reading an excel file and not the NumberFormat?
Tricinty
- 63
- 6
1
vote
3 answers
EPPlus: Values in column of pivot table
When you create a pivot table in Excel and add fields to Rows and Values, you get an additional field [Symbol Sigma] Values in the GUI, that you can drag and drop to Columns.
I am creating a pivot table using EPPlus. How can I add this [Symbol…
Jerome Reinländer
- 1,227
- 1
- 10
- 26