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
4
votes
2 answers

Concurrent Reads and Write to an Excel file

Is it possible to have only one process do WRITE and many doing a READ operation on an excel file? I am using ExcelPackage(EPPlus) for this. To demo, I wrote two console app one to write iteratively and another to read. Running them concurrently…
Tony Thomas
  • 398
  • 7
  • 20
4
votes
3 answers

EPPlus: How to add space in a cell value in C#

I am currently working in an export to Excel of a hierarchical grid using EPPlus. So all child rows should be displayed with padding (space). As shown below: As shown in the above, you can see I have added four spaces before Software, QA, Analyst,…
ConfusedDeveloper
  • 6,389
  • 4
  • 21
  • 36
4
votes
1 answer

How can I create a DataField that calculates values in EPPlus?

I am porting Excel Interop PivotTable code to EPPlus. I'm at a sticking point in generating a calculated field value. In Excel Interop I can do it this way: pvt.AddDataField(pvt.PivotFields("TotalQty"), "Total Packages",…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
4
votes
1 answer

How to insert a row in one go with EPPlus

I've started using EPPlus and I was wondering if there is a way to insert a row all in one go instead of having to populate cell by cell. For example let's say my row number 6 is populated with various number, could I insert all cells in the row by…
Gep
  • 848
  • 13
  • 29
4
votes
1 answer

Auto column width EPPlus slow

I use this code to load data into a worksheet (C#, EPPlus 4.04) and set the column width automatically: workSheet.Cells["A1"].LoadFromCollection(itemsToExport, PrintHeaders:…
Michel van Engelen
  • 2,791
  • 2
  • 29
  • 45
4
votes
3 answers

EPPlus: Auto-save feature supported?

I'm planning to use the EPPlus (4.0.4 version) library to export my live data to an excel sheet using C# .NET in my WPF application. My question is however specific to the EPPLus library. I've gone through the EPPlus samples () wherein you can use…
Bharat Mallapur
  • 674
  • 9
  • 17
4
votes
3 answers

EPPlus with a template is not working as expected

I am currently using EPPlus project in order to manipulate some .xlsx files. The basic idea is that I have to create a new file from a given template. But when I create the new file from a template, all calculated columns in the tables are messed…
Eric Javier Hernandez Saura
  • 3,671
  • 3
  • 28
  • 38
3
votes
1 answer

Epplus - LoadFromCollection and column order

I'm using the method LoadFromCollection to fill an excel with a List. However, the excel columns need to have a certain order to provide a better context for the user, so I'm trying to find out how to accomplish this. One option I've is to set the…
Pedro Faustino
  • 227
  • 3
  • 14
3
votes
1 answer

Turn off rounded corner in EPPLUS ExcelChart

Reading Add RoundedCorners property to ExcelChart I guess EPPLUS adds rounded corner to ExcelChart by default. I like to get rid of the rounded corner and keep ExcelChart in clean squared corner, but can't seem to find a way to do so in EPPLUS…
KMC
  • 19,548
  • 58
  • 164
  • 253
3
votes
1 answer

Detecting last row and calculating total rows on page

I am currently working with a client that generates their invoices manually in Excel. I have used epplus to generate this file automatically for them. One of the requirements I have is that each page should have a border around it and start with…
JakeHova
  • 1,189
  • 2
  • 15
  • 36
3
votes
2 answers

EPPlus returns #VALUE! instead of the cell content when used with Formula OFFSET, INDIRECT & MATCH

I have an Excel file with a table tblPhoneCode and with two columns Country and Code, and I have a cell B1 with List Data Validation pointing to the Country column and a cell B2 basically it displays the Code for the selected Country. Cell B2…
Ash
  • 657
  • 9
  • 16
3
votes
1 answer

Index was outside the bounds of the array while exporting data to excel in C#

I have ASP.Net site. Following is my method to write stream to excel. public void JsonToExcel(string jsonData, HttpResponseBase response) { try { ExcelPackage excel = new ExcelPackage(); var worksheet =…
Kgn-web
  • 7,047
  • 24
  • 95
  • 161
3
votes
2 answers

OpenOfficeXml Repeat Labels in Pivot Table

I m using Epplus and trying to "repeat all item labels" in tabular type pivot table. I tried lots of things but it looks no way with EPPlus library. I decided to manulplate pivot table xml and i need to add fillDownLabels attribute on…
erkan demir
  • 1,386
  • 4
  • 20
  • 38
3
votes
1 answer

EPPlus isn't honoring ExcelHorizontalAlignment Center or Right

I've tried this in EPPlus versions 3.1.3.0 and the latest 4.0.4.0 and both are exhibiting the same behavior. I'm trying to Center align text in cells but it's just not working. Numbers in cells work fine, strings do not. Following is an example of…
John Hurrell
  • 350
  • 4
  • 11
3
votes
0 answers

Error reading xlsx (2007) file in EPPLUS

I have an error while trying to read excel files (xlsx) which were saved in Excel 2007 using EPPlus library. Some workaround: ASP.net mvc 5 app with EPPlus v. 4.0.4.0 User can download template file from my site, then fill required data in it, and…
teran
  • 3,214
  • 1
  • 21
  • 30
1
2
3
…
12 13