Stack Overflow
Stack Overflow

Questions tagged [epplus-4]

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).

http://epplus.codeplex.com/

189 questions
1
vote
1 answer

epplus Unselect a filter value

In my project I am using epplus to modify excel files. Now in one case I need to add filter on a range and un-select one of the filter options in filter list. Adding filter is straight forward(myRange.AutoFilter = true) but I don't see any way to…
TechnicalSmile
  • 1,387
  • 5
  • 16
  • 30
1
vote
1 answer

EPPLus Cell Formula #REF

Hope someone can crack this issues with EPPLUS and Formulas. I'm getting an invalid #REF! when I try to assign a formula to a cell, yet the last row seems to accept the formula without a problem and does the calculations right. Here is what the…
Antonio Z
  • 11
  • 3
1
vote
1 answer

How to add one excelworksheet into other workbook using EPPlus in C#?

private static ExcelPackage MergeExcelPackages(ExcelPackage aExcelPackage, ExcelPackage bExcelPackage) { var excelPackage = new ExcelPackage(); excelPackage.Workbook.Worksheets.Add("AInfo",…
Suresh Amudalapalli
  • 13
  • 1
  • 5
1
vote
1 answer

EPPlus LoadFromDataTable() is double escaping ampersands

Here's my code: ExcelPackage pck = new ExcelPackage(stream); ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Rules"); ws.Cells["A1"].LoadFromDataTable(_rules,…
Andrew
  • 1,030
  • 13
  • 24
1
vote
1 answer

Does Epplus support Excel 2013?

I have a excel file, which is created in Excel 2013 MS package. It contains Numeric values and charts. I had do open the file and added new rows and then while saving the file , got this error in C#.net This property or method is not supported for…
Magendran V
  • 1,411
  • 3
  • 19
  • 33
1
vote
1 answer

EPPlus: ExcelChartSerie.Header loads once but doesn't update when cell is changed

I am trying to create an EPPlus chart. I am having problems with series headers. Even when ExcelChartSerie.HeaderAddress is used, it seems to have no effect. Each serie is initialized with the following piece of code ExcelBarChartSerie serie =…
jnel899
  • 563
  • 2
  • 8
  • 21
0
votes
0 answers

Epplus Adjustments Shape

I'm using the epplus 4.5.3.3 and I want to put this shape in the Excel: enter image description here But the epplus only put it like this: enter image description here How can I edit it by code? In the macros is…
Federico Portillo
  • 3
  • 3
0
votes
0 answers

Is there any way to deal with "System.ArgumentException: 'Invalid Address format _DAT1'" exception while removing column from Excel sheet using EPPlus

I am using EPPlus package in my code for working with excel so I supposed to remove excel Address column from excel sheet and save the excel sheet without saving that column. So I tried this following way Code to remove column from excel We are…
Vikas Kawale Patil
  • 1
0
votes
0 answers

Excel Read Differences between .net Core & .net Framework (Epplus)

I want to take an Excel file form the user and want to read it. I can do it on .net Core project with the first code block below as you see. But I have to run it on a .net Framework project now. I have to fix 2 parts. First one is IFormFile comes…
Mert Çakar
  • 13
  • 4
0
votes
1 answer

EPPLUS Pivot Table headers in tabular layout doesn't work

I have set the tabular layout according to this solution, but the filters on headers pivot table remains in Compact layout with unique "Row Label" in the first header with all filters. Microsoft Compact/Tabular Layout This is the expected result I…
fvinches
  • 1
  • 1
0
votes
1 answer

Dynamically read the row column value of excel sheet using EPPlus ExcelPackage

Using EPPlus ExcelPackage to read the excel sheet var newRow = table.NewRow(); newRow["Reference"] = row[rowNumber, 1].Text; newRow["AssessmentTitle"] = row[rowNumber, 2].Text; …
San Jaisy
  • 15,327
  • 34
  • 171
  • 290
0
votes
0 answers

EPPLus - Copy worksheet that contains chart throws Type is a duplicate attribute error

I am trying to copy a worksheet from one workbook to another. For normal worksheets, my code excelPackage.Workbook.Worksheets.Add("Target", origWS); works fine. But when the same code is used for a worksheet that contains charts, I get an error …
Arvind S
  • 87
  • 1
  • 7
0
votes
1 answer

Showing #value! before enable editing on excel if I write formula using epplus

Using C# .net core I am updating existing excel template with Data and formulas using EPPlus lib 4.5.3.3. If you see the below screen shots all formula cells has '#value!' even after using calculate method in C# code (Just for reference attached xml…
Sai Kumar
  • 308
  • 2
  • 10
0
votes
1 answer

EPPlus InsertRow corrupts excel file

I am currently comparing different files with each other and put the output in an Excel Workbook with multiple worksheets (one per file comparison) using EPPlus 4.5.3.3. The worksheets are simple ranges - no tables. Sometimes it is required to move…
Steve
  • 49
  • 1
  • 9
0
votes
0 answers

I need to modify the value of a column using Epplus

I need to modify the value of a column First I look for the column by its name, getting the index. I would like to see how I can modify the value of that column based on its ID, or on the contrary, on its range public static class…
ararb78
  • 1,137
  • 5
  • 19
  • 44
1 2 3
…
12 13