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
1 answer

FileInfo() type or namespace not found

I'm using the sample code below to create a spreadsheet using EPPlus.dll, but FileInfo is not recognized. EPPlus.dll has been added as a reference via the Package Manager Console and the other objects and references such as ExcelPackage and…
Ty S
  • 1
  • 2
0
votes
1 answer

How to Insert A Column With In a Range if Rows Using EPplus?

Any one tell me how can I insert a column with in a range of rows? I know the below code will insert a column but I need it for a range of rows. I didn't find and documentation for this in internet. mainSheets.InsertColumn(1, 1);
nav
  • 95
  • 1
  • 11
0
votes
1 answer

How to Check and merge two rows if next value is same or not in excel with epPlus

I am working on dynamic Excel creation with the help of EPPlus library and I have an excel which data looks like: Name EmpCode Department attendance Prashant 111 CSE 70% for Sep Prashant 111 CSE 90% for Oct XYZ…
Prashant Pimpale
  • 10,349
  • 9
  • 44
  • 84
0
votes
0 answers

Adding entire row using epplus in vb

I need to add a row in excel sheet before the last row in epplus. So far I got: ws.InsertRow(ds.Tables(0).Rows.count-1,1) However this code adds a cell on Fist column. How do I add for entire columns? Is there any way to add a row for entire…
Thaman Gurung
  • 3
  • 1
  • 5
0
votes
1 answer

Strip time from DateTimeOffset in model > viewmodel mapping

I'm trying to remove the time portion of a DateTimeOffset field in an Excel export and I just cannot get it to work. Here's the field I'm using to display: [DataType(DataType.DateTime)] [DisplayFormat(DataFormatString = "{0:MM/dd/yyyy}",…
TrevorGoodchild
  • 978
  • 2
  • 23
  • 49
0
votes
1 answer

Epplus Cell with DateTime type not recognized

I have a problem with the DateTime format. A cell has the following NumberFormat "[$-F800]dddd\,\ mmmm\ dd\,\ yyyy" but it is not recognized as DateTime. if (cells.Value is DateTime){ var dateTime = DateTime.Parse(cells.Value.ToString()); } How can…
Tricinty
  • 63
  • 6
0
votes
1 answer

EPPlus Excel Related Dates Last Modified

Does anyone know if there is a way to set the "Last Modified" date of a workbook? You can see this property by opening an .xlsx and going File -> Info in Excel, it's under Related Dates and it is not set by default with EPPlus. If you simply save…
e36M3
  • 5,952
  • 6
  • 36
  • 47
0
votes
2 answers

WorkSheet.DeleteColumn does not delete column, just clears data

I load my sheet with data from a List using LoadFromCollection. I then delete some extra columns and then add a Table to the sheet. Finally I save the file. I expect 2 columns in my table, but there are 4, of which 2 are empty. I suspect that it…
Atron Seige
  • 2,783
  • 4
  • 32
  • 39
0
votes
1 answer

How to add same column name in excel sheet in EPPLUS library while creating excel

I am using EPPLUS library for creating excel file with a data table. I have such column in my stored procedure: emp_name, sales, INR, marketing, INR But in excel file it generates column name like with column name like emp_name, sales, INR,…
Prashant Pimpale
  • 10,349
  • 9
  • 44
  • 84
0
votes
1 answer

Epplus excel conditional formatting databar max value

I'm creating an excel file with epplus, and I'm trying to add a databar with the following code: var bar = pck.Workbook.Worksheets[1].ConditionalFormatting.AddDatabar(new ExcelAddress("I4:I56"), System.Drawing.Color.Blue); …
Kyle
  • 32,731
  • 39
  • 134
  • 184
0
votes
3 answers

Sum n largest numbers EPPlus

I'm trying to sum the n largest numbers of a range. My formula is: SUM(LARGE(A10:A15, {1,2})) But I'm getting a #VALUE as result. If I debug the formula execution to a log file I got that: Worksheet: Sheet 1 Address:…
Munir
  • 739
  • 2
  • 14
  • 38
0
votes
1 answer

Unmerge and clear cells in epplus 4.1

I had no luck deleting rows in excel so now I try to clear their content and still get the error: "Can't delete/overwrite merged cells. A range is partly merged with the another merged range. A57788:J57788". Columns 1-10 are really merged, but how…
Vadim
  • 107
  • 2
  • 8
0
votes
1 answer

Error dialog displayed opening an excel file generated with EPPlus

Generated excel from EPPLUS issue When excel is opened it displays an error saying we found a problem with some content in Excel. Do you want us to recover as much as we can? If you trust the source of this workbook, click Yes.
SReddy
  • 41
  • 4
0
votes
0 answers

EPPlus - Filters automatically added for empty cells in additional worksheets

I am using EPPlus to export dataset into Excel. There is no issues when i have 1 worksheet in a workbook. When i add additional worksheets, the worksheets empty cells added with filters automatically like below. Any solution to avoid such unwanted…
stackofsam
  • 61
  • 1
  • 8
0
votes
1 answer

is it possible to create an image that will load via URL with EPPlus?

I need to embed images into an Excel spreadsheet using EEPlus. There 1000's of rows, so embedding these as Pictures is not an option since this file gets generated via a website and the file would be huge and slow to create. It would be nice if…
Slee
  • 27,498
  • 52
  • 145
  • 243
1 2 3
…
12 13