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
1
vote
1 answer
EPPlus: ListDataValidation slows Package.Save
I use EPPlus to generate a spreadsheet with a lot of dropdowns.
The dropdowns are generated using the following code:
private void SetDropDown(string destColumn, int row, string selectedValue,
IEnumerable options)
{
int colNum =…
Igor Eremyashev
- 23
- 5
1
vote
0 answers
How to add EPPlus Nuget package into my exe
I added the Nuget EPPlus package to my program and now that everything works perfectly I export the .exe but it errors out with the following:
My program folder where the .exe normally resides does contain the files for epplus but appreantly it is…
Fayaz
- 79
- 1
- 10
1
vote
0 answers
EPPlus Pivot table change order in Column fields
I'm using EPPlus (4.1.1) to create a Pivot table on a sheet. All goes well except I have no control on the order of the specified column field ("Wait Delay") and the data fields ("Values") in the "Columns" section (see attached image). In Excel this…
DaddyCool
- 31
- 5
1
vote
2 answers
How to avoid unwanted side effects with EPPlus 4.1.1 and Excel 2016?
I use an Excel 2016 *.xlsx file as a template and fill some data using EPPlus 4.1.1. In order to do so I use named ranges that I retrieve from the excelPackage with
var namedRanges = excelPackage.Workbook.Names; //ExcelNamedRangeCollection
var…
Stefan
- 10,010
- 7
- 61
- 117
1
vote
2 answers
EPPLUS: Set marker fill color in LineMarkers
I tried setting all related properties ExcelLineChartSerie has to offer, but still cannot set or change the color of the Excel marker from default ugly blue.
ExcelChart ec = ws.Drawings.AddChart("LineChart01", eChartType.LineMarkers);
var rangeX =…
KMC
- 19,548
- 58
- 164
- 253
1
vote
1 answer
How to set PivotTable orientation to value in columns using EPPlus?
Does anybody know the EPPlus equivalent of interop code:
pivotTable.DataPivotField.Orientation = Excel.XlPivotFieldOrientation.xlColumnField;
Which moves the values from the rows to the columns.
(Manually you'd set this in Excel by dragging the…
Jasper
- 444
- 3
- 19
1
vote
2 answers
How to send uploaded excel file to C# Post API using Angular 4
var fd = new FormData();
fd.append('file', data.target.files[0]);
return this.http.post(url), fd).map().catch();
Using AngularJS it's working but for angular 4 when i used the same way it's not working.I am getting disk error while uploading excel…
lakshmi mullapudi
- 23
- 4
1
vote
0 answers
Dynamic reference of assembly in SSIS script task
Currently, I am using EPPlus dll in my SSIS script task to generate excel reports and everything is working fine. I have managed to do away with the part to add the dll into GAC by loading the custom assemblies into the SSIS script task itself.…
Abhishek
- 2,482
- 1
- 21
- 32
1
vote
2 answers
Epplus row height issue
I have an excel file with over 1000 rows. Each row contains some data and 2 images.
The images are attached as OfficeOpenXml.Drawing.eEditAs.OneCell
After populating the Excel I run this, to set the row height.
int prodTableStart = 3;
int…
JP Hellemons
- 5,977
- 11
- 63
- 128
1
vote
1 answer
EPPlus from Matlab: when creating chart, eShapeStyle missing
to write data from Matlab 2015b to Excel files I'm using the .NET EPPlus library (v4.1, http://epplus.codeplex.com/). Reading and writing data all works. Formatting as well. However, when creating charts, I bump into an error message that I cannot…
jvz
- 1,183
- 6
- 13
1
vote
1 answer
How to apply Excel settings only to a range using Epplus
For the values i=4 and i=6, following will apply background color as LightGrey to the entire 4th and 6th rows. Question: Are there any ways so we change the Background color (or any style for that matter) of a row within certain range, say, all the…
nam
- 21,967
- 37
- 158
- 332
1
vote
1 answer
EPPlus, applying formula to non-contiguous range
I'm working in C# with EPPlus v 4.1 and not having luck applying a formula to a non-contiguous block of cells.
I'm able to use the following code to apply a formula to a range of selected cells that are contiguous.
Worksheet.Select(new…
Emilio
- 378
- 2
- 8
1
vote
1 answer
VSTO Excel Read from Current Open Workbook
Is it possible to read from an open Excel (xlsx) using EPPlus? I want the user to be able to open an Excel document, click the Add-In button and read data from the active worksheet. I don't need to write to the worksheet, only read from it.
Using…
mack
- 2,715
- 8
- 40
- 68
1
vote
2 answers
EPPlus formula not working without calling Calculate
I've tried to use two functions in excel INDEX and MATCH and according to EPPlus codeplex, these should be supported. Everytime I open the file, there's a warning message saying that something is broken and asks if I want to repare the document, and…
Binke
- 897
- 8
- 25
1
vote
1 answer
How can I partially change the border of a merged cell?
So given this code:
var mergeCells = worksheet.Cells["A1:B5"];
mergeCells.Merge = true;
mergeCells.Style.Border.BorderAround(ExcelBorderStyle.Medium);
var notWorkingCell = worksheet.Cells["C1"];
notWorkingCell.Style.Border.Right.Style =…
Christian Gollhardt
- 16,510
- 17
- 74
- 111