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
0
votes
0 answers

c# - How to make excel auto calculate formula type cells

I have an excel file that has around 40 to 50 sheets of size 8mb and will be increasing may be 15 to 20mb and many are inter-linked with multiple formulas. So basically if one cell values changes then it will affect multiple sheets because of…
Nithin B
  • 601
  • 1
  • 9
  • 26
0
votes
1 answer

EPPlus issue with R1C1-reference to absolute column in formula

I recently switched from interop/closedxml to EPPlus, I noticed EPPlus handles R1C1 absolute references differently. Consider the following code int colIndex = 5; string formula = string.Format("MATCH(@""12345"",C{0},0)", colIndex); int…
Jasper
  • 444
  • 3
  • 19
0
votes
2 answers

"Index was outside the bounds of the array" exception C#

I'm trying to save the Excel workbook however, I'm receiving the exception "Index was outside the bounds of the array." This is the code: public static void Update() { FileInfo newFile = new FileInfo(@"C:\Users\"); using (ExcelPackage p =…
coffeetime
  • 121
  • 2
  • 6
  • 14
0
votes
1 answer

EPPlus to write Dictionary To Cells

I have a Dictionary in my syntax, that I want to write the results of this starting with cell A2 to Excel. At the most it will only be 50 rows. How is this done in epplus?
IcyPopTarts
  • 494
  • 1
  • 12
  • 25
0
votes
0 answers

Create excel pivot table chart using EPPlus error with special character '&' in column name

I am crating an excel file with pivot table and charts. When I use '&' in column name it throws error "One or more errors occurred". Error is only when creating pivot table. var pivot1 = pivotSheetT1.PivotTables.Add(pivotSheetT1.Cells["A3"], Range,…
codemirror
  • 3,164
  • 29
  • 42
0
votes
1 answer

EPPLus - Excel column names not working

Question: How Can we add ws.Cells["AA"].Value = "MyColumn"; as a column name to Excel worksheet Following works until column Z1. But I have more columns after Z column. So, if I add ws.Cells["AA"].Value = "MyColumn";, following does not…
nam
  • 21,967
  • 37
  • 158
  • 332
0
votes
0 answers

Epplus:- Referencing a cell from another worksheet, then how to get calculated values from .xlsm file

I am using EPPlus library to get all requirement as per our need. I am not getting how to get calculated value of the cell which has reference of another worksheet in the same .xlsm file (macro enabled).Can any one help?? After hitting…
Vineet Kumar Rai
  • 31
  • 1
  • 9
0
votes
3 answers

Hyperlink to a cell on another workbook - EPPlus

I want to add an hyperlink to a cell of another workbook. I am able to refer the whole file but I have issues when referring an specific cell. The generated hyperlink is well formed because when I click on modify hyperlink and then OK (without…
Pablo Maldonado
  • 1
  • 2
0
votes
0 answers

Refresh pivot table data on a server where ms office is not installed

I am automating excel reports on a server where ms office is not installed. I have used EPPlus library which is working fine for import/export in excel. But I am not able to refresh pivot table data with different connection strings in asp.net. I…
Ushma Mulwani
  • 69
  • 5
0
votes
1 answer

EPPLus Error when loading a Stream larger than 40MB

I am using EPPlus on C# MVC to load excel files into memory. I am taking the stream from a file upload: model.File.InputStream and pass this to the ExcelPackage.Load() Method. It works great for files < 40 MB. But for larger files, I get the…
Cătălin Rădoi
  • 1,804
  • 23
  • 43
0
votes
0 answers

Optimize Syntax

This syntax works - but it takes roughly 3 minutes to complete, which is WAY to high. Is there a way to re-write this syntax for optimization? I know that the first problem with the syntax with this syntax is using Microsoft Excel Interop however…
Michael Mormon
  • 539
  • 2
  • 8
  • 19
0
votes
0 answers

Filter Condition With EPPlus

I have found that you can use this syntax to filter a workbook with EPPlus range.AutoFilter = true; But I have not seen if/how I can pass in a filter parameter. For example, using the Excel Interop - I would use range.AutoFilter(1, range.Cells[2,…
StarsFlyFree FromCozyNights
  • 303
  • 1
  • 10
  • 24
0
votes
1 answer

Change Order yAxys with EPPlus

I'm doing an excel with epplus that requires generating two graphs in vertical bars like those shown in the following image: As you can see, on the Y-axis, the labels appear disordered, starting with P6 and ending with P1. I want to get the…
Pedro Pérez
  • 84
  • 7
0
votes
0 answers

EPPLUS 4.1 OutOfMemory Exception for "xlsx" files but not "xls" files

I'm using Epplus 4.1 to read the content of uploaded files and insert them into the database, pretty simple operation actually. However I got reported a bug that for some reason one file is getting out of memory exception when I create the package. …
Raphael Lima
  • 179
  • 1
  • 14
0
votes
1 answer

Excel Interop Open/Repair HResult exception

What I do: populate & format an Excel file using a mix of Interop and ClosedXML. First, the file is populated via Interop, then saved, closed, then I format the cells' RichText using ClosedXML. Unfortunately, this formatting causes Excel to view my…
LocEngineer
  • 2,847
  • 1
  • 16
  • 28
1 2 3
…
12 13