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
0 answers
Wrong formula after InsertRow (EEPlus)
I try to use excel template and populate it with some data, template contains headers (С1,С2) and sum row(C3) where is C3 = Sum(C3:C3), then I insert 5 rows and populate with data these rows.
var startCell = worksheet.Cells["C3"].Address;
var…
Artur Zh
- 25
- 3
1
vote
1 answer
How can I add an image to my sheet without being prompted to replace contents of the (empty) destination cells (EPPlus)?
When I open the Excel file I generate using EPPlus (C#), I get "Do you want to replace the contents of the destination cells in [... .xlsx]PivotTable?"
As you can see in the screen shot below, there is nothing in the cell where I want the image to…
B. Clay Shannon-B. Crow Raven
- 8,547
- 144
- 472
- 862
1
vote
0 answers
How to get blank cells as a Range in Epplus?
I want to get all blank cells from a range using epplus 4 in Vb.net C#
Using Excel.Interop, i was using this:
Dim otherCells As ExcelRange = ExcelRangeV3.SpecialCells(XlCellType.xlCellTypeBlanks)
otherCells.Select()
otherCells.FormulaR1C1 =…
Steve Johnson
- 3,054
- 7
- 46
- 71
1
vote
1 answer
C# Change Excel chart label orientation using EPPlus
There doesn't seem to be any method in EPPlus for changing the orientation of tick labels on a chart.
I can see it's possible to make changes by using the XML properties exposed by ChartXML but documentation for this seems to be thin on the ground.…
TV John
- 47
- 6
1
vote
2 answers
How to get the date in day month year from date value
I am using excel uploading operation having date data.
When I upload excel with date 17-Oct-2012 and I am getting 41199.
Prasad Joshi
- 471
- 4
- 12
1
vote
1 answer
Finding out if a column is hidden in an excel file using EPPLUS
I have a project which reads in a excel file using EPPlus. However, often the files can include hidden columns.
Is there a way of determining if a column is hidden using EPPlus?
I basically want to ignore any hidden columns.
user2183216
- 359
- 3
- 9
- 22
1
vote
1 answer
How can I incorporate a PivotTable right into the source data on the sheet (using EPPlus)?
I've been able to create a PivotTable separate from the raw/source data, but now I want to combine the two, with the PivotTable allowing filtering of the spreadsheet data by providing filters on the column heading row, like this:
I tried this…
B. Clay Shannon-B. Crow Raven
- 8,547
- 144
- 472
- 862
1
vote
2 answers
Epplus Export Error like this : 'System.Data.DataSet' the object type 'System.Data.DataTable' not taken in kind.
I wanna convert a gridview to .xls but it throws error and when I click ok its give me " Failed to export to excel. Original error: 'System.Data.DataSet'
the object type 'System.Data.DataTable' not taken in kind. " Here is my code;
My search button
…
Furkan Penbegül
- 109
- 2
- 4
- 13
1
vote
1 answer
EPPlus can't read locked cells value
I am using EPPlus to read data from .XLSX file.
issue is it is not able to read locked cells. So I have to open excel, Unlock cells, and then upload. Is there way to read lock cells. I tried as below:
For row As Integer =…
user2739418
- 1,623
- 5
- 29
- 51
1
vote
0 answers
Unreadable excel content Epplus
I am making a Post request and receiving the response from an end point, through which i receive the excel content.
I have used this end point before and tried binding a email worker, which works fine. (Conforming end point response is clear).
Now…
user3932191
- 33
- 2
1
vote
3 answers
How to get a shape/picture coordinates in pixels in an excel file (xlsx) using EPPlus
Has anyone succeeded in obtaining the x and y coordinate in pixels of a shape or a picture in a sheet in an excel 2010 file using epplus?
IdontCareAboutReputationPoints
- 1,584
- 21
- 26
1
vote
1 answer
EPPlus - How to add "Series Lines" in Pivot Chart (ColumnStacked)
I am using EPPlus library to generate pivot chart in excel.
I created the chart but don't know how I can add "Series Lines" to it.
The arrow in the below image indicates series lines.
Chart - Series Lines
Here is the sample code.
var wsBar =…
Deb
- 23
- 1
- 5
1
vote
1 answer
EPPlus Excel download from MVC causes an out of memory exception
I'm using the following code to send an EPPlus package to the client as an Excel file in asp.net MVC. However, I'm having an issue with large files throwing OutOfMemoryException exceptions.
public class ExcelPackageResult : ActionResult
{
…
RyanHerbert
- 88
- 1
- 6
1
vote
1 answer
How to leave cells empty in Date column instead of writing DateTime.Min in EPPlus
I need to write a formatted date to Excel using EPPlus, leaving empty cells where there are no dates to write. I have tried the following:
Writing a date, and then formatting it. This works unless I have no date, in which case the minimum value is…
majjam
- 1,286
- 2
- 15
- 32
1
vote
0 answers
How add a new row and columns with EPPlus C# and MVC?
I use EPPlus version 4.0.4 to create an Excel file within an ASP.net MVC5 website and I simply don't know how to add a new rows and columns after completing the very first row.
It's difficult to explain clearly so let's me show you my code. It's…
David Létourneau
- 1,250
- 2
- 19
- 39