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
1 answer
EPPlus AutoFit() different column width on different machines
I am using EPPlus Version 4.1.0
I know this issue seems extremely weird but I have already wasted 2 days on this and any input is very very welcome!
I run the following code:
using (var package = new ExcelPackage())
{
ExcelWorksheet ws =…
w33z33
- 378
- 2
- 17
2
votes
2 answers
How can I change the format of the ColumnField column headings in EPPlus?
I create a column field in EPPlus like so:
// Column field[s]
var monthYrColField = pivotTable.Fields["MonthYr"];
pivotTable.ColumnFields.Add(monthYrColField);
...that displays like so (the "201509" and "201510" columns):
I want those values to…
B. Clay Shannon-B. Crow Raven
- 8,547
- 144
- 472
- 862
2
votes
2 answers
How can I shift the "subitems" in an Excel PivotTable to another column?
I generate an Excel sheet which contains data formatted like so:
IOW, the "Total Packages", "Total Purchases", "Average Price", and "% of Total" values are located in a column of their own (Data) for each overarching (or sidearching)…
B. Clay Shannon-B. Crow Raven
- 8,547
- 144
- 472
- 862
2
votes
1 answer
How can I create a PivotTable using EPPlus to filter on the rows in one column and also a set of columns?
To create a PivotTable, source data needs to be provided from which to generate the PivotTable.
I have generated a "dummy" sheet for this purpose which contains raw data such as:
I need to generate a Pivot Table from that data so that it is…
B. Clay Shannon-B. Crow Raven
- 8,547
- 144
- 472
- 862
2
votes
1 answer
Get all the VBA macros of a workbook by EPPlus
In the sample Sample15.cs downloaded from EPPlus, I see that EPPlus can write/inject VBA macros. However, I don't see how to read all the VBA macros from a .xlsm workbook.
Can EPPlus interpret VbaProject.bin and support this functionality?
PS: it…
SoftTimur
- 5,630
- 38
- 140
- 292
2
votes
2 answers
How can I prevent the left "gutter" (row number) column from printing (EPPlus)?
The "Print Preview" of a spreadsheet created with my EPPlus code shows the gutter/row number column (column 0, so to speak):
How can I programmatically prevent the gutter/row number ("crack?") column from printing?
My printing setup code is…
B. Clay Shannon-B. Crow Raven
- 8,547
- 144
- 472
- 862
2
votes
1 answer
How can I set up "PrintTitleRows" in EPPlus?
In Excel Interop, I can set up title rows to repeat on subsequent pages like so:
_xlSheet.PageSetup.PrintTitleRows = String.Format("${0}:${0}", COLUMN_HEADING_ROW);
How is it accomplished in EPPlus? I tried prodding Intellisense to giving me a clue…
B. Clay Shannon-B. Crow Raven
- 8,547
- 144
- 472
- 862
2
votes
2 answers
Add chart element Data table with legend
We are able to generate a chart in the excel sheet using EPPlus. There is requirement to add chart element >> Data table with legend. Is there any way to add this using EPPlus? You can review the chart that I am looking for here
CPW
- 503
- 5
- 7
2
votes
4 answers
EPPlus save two million rows with 200+ columns datatable to multiple excel files
I have function that saves all records from SQL table to excel worksheet using EPPlus.
If I export small amount of data everything works fine, but with 200+ columns and 500 000+ rows I get OutOfMemory exception.
I'd like to modify my code in a way…
Misiu
- 4,738
- 21
- 94
- 198
2
votes
1 answer
epplus for generating excel using greater than and less than
I am using epplus for Excel. how can use greater than and less than
condition for showing debit and credit value with dr and cr.
if value is -123456 I want to show it like this: ₹1,23,456 DR
if value is 123456 I want to show it like this:₹1,23,456…
amit jain
- 305
- 4
- 8
2
votes
1 answer
How to read a range of cells (e.g.A1:G30) from Excel file to GridView
I have been looking for a solution all over the last days and I found that this library EPPlus allows retrieving in the same time formatting besides the actual data, plus charts, if needed, from Excel files which is what I am aiming at the…
George
- 653
- 6
- 18
2
votes
1 answer
How to make Excel columns read-only but re-sizable in EPPlus C# ?
In my MVC project, users can select some products in the UI and download the related product information in Excel (.xlsx) format.
Our business requirements is, apart from few columns/cells the file should be read-only. I'm using EPPlus 4.0.4 to…
Arghya C
- 9,805
- 2
- 47
- 66
2
votes
2 answers
Add List Validation to Column except the first two rows
I am trying to add a dropdown (list validation) upon creating the excel, I already found the way to add it to whole column but my scenario is different because I only add the validation to whole column except the first row and second row.
This is…
Vincent Dagpin
- 3,581
- 13
- 55
- 85
2
votes
1 answer
EPPlus To Read 1st Column Of Excel Into Array
Use OpenFileDialogwith EPPlus. I get a compile error of:
The name 'sheet' does not exist in the current context
Now, the obvious issue is how do I associate the selected Excel file with my EPPPlus & 2 what do I do to remove the error above?
using…
Big Pimpin
- 427
- 9
- 23
2
votes
1 answer
Conditional Formatting With Icons Epplus
I need to achieve something like this with Epplus.
Can someone guide me with the code I need to use.
MikeFerrer
- 77
- 1
- 10