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

EPPLUS how to know the format of the Worksheet cell

I am using EPPlus to read excel sheets and load the data into datatable to perform further operations and then save back the modified data to the excel file. The below code checks if the cell value is a float value then it converts the float value…
SurajP
  • 31
  • 1
  • 1
  • 2
3
votes
1 answer

Importing excel file with all the conditional formatting rules to epplus

I have an excel file which contains lots of data along with icon sets and data bars based on the values in the cell. It looks like this: I want to import this excel sheet along with the conditional formatting. Is there any library for this?? I went…
sanmis
  • 515
  • 1
  • 7
  • 22
3
votes
1 answer

FormulaR1C1 increasing row value EPPlus

I have set a formula as follows: var excelfile = new FileInfo("Excel.xlsx"); using (var package = new ExcelPackage(excelfile)) { ExcelWorkbook workBook = package.Workbook; if (workBook !=…
MikeFerrer
  • 77
  • 1
  • 10
3
votes
1 answer

EPPlus charts: how to plot vertical bar graph instead of the horizontal default

I am stuck on an issue with an EPPlus (4.0.1). My bar graph is plotting horizontally but I would like it to be vertical. I am trying to change the "chart.Direction" property, but I am given an error because it is read-only. I also do not see a…
jnel899
  • 563
  • 2
  • 8
  • 21
3
votes
1 answer

How to un-merge cells EPPlus?

I'm trying to un-merge and re-merge shorter or longer range depending on the the number of table columns I used this code below but it doesnt seem to work tableSheet.Cells["C1:J1"].Merge = false; Any help will be highly appreciated.
user2967602
  • 33
  • 1
  • 3
2
votes
1 answer

EPPLUS using loadfromcollection with merged cells

I have to fill an excel like this Where I have merged cells on each row. I'm trying to use loadfromcollection, but it ignores the merged cells and it fills each single row. Please did you know any quick way to do it? edit: I think that one way is…
Saledan
  • 85
  • 9
2
votes
1 answer

EPPlus v4 Worksheet.InsertRow >1024 bug

Found that when inserting > 1024 row with EPPlus v4 (v4.5.3.3), the formula in cells under new inserted rows is be corrupted, and one original row disappeared. Unfortunately the EPPlus v4 git is archieved as they moved from LGPL to Commercial…
Joe Lau
  • 439
  • 5
  • 10
2
votes
1 answer

Import a CSV or XLSX Into A DataTable Using EPPLus

I found a thread on SO and am attempting to import a csv or xls or xlsx into a C# DataTable - but I am getting the below stack trace error: System.Runtime.InteropServices.COMException HResult=0x8003001D Message=A disk error occurred during a…
Bob Goblin
  • 1,251
  • 3
  • 16
  • 33
2
votes
1 answer

Create a column dropdown in EPPlus

I have everything else worked out but I want to put a drop down on a cell (range of cells) so that users are forced to select from the list. I've tried this: var dd = worksheet.Cells[5, 3, row,…
James Hancock
  • 3,348
  • 5
  • 34
  • 59
2
votes
1 answer

Evaluating formula from csv using EPPlus

To load formulas in a range I've used this method ws1.Cells["B4:D4"].LoadFromText($"={con_Fu_LF},={con_Un_LF},={con_Fo_LF}"); and to evaluate I've called ws1.Cells["B4:D4"].Calculate(); Opening the workbook I see strings in that range, for example…
user6283344
2
votes
1 answer

EPPlus - shift rows up after DeleteRow

h3110 3v3ry0n3, especially EPPlus team! I have an Excel template like this: _______________________________ | Title 1 | Title 2 | |_______________|_______________| | %Placeholder% | %Placeholder% | |_______________|_______________| |…
oxfn
  • 6,590
  • 2
  • 26
  • 34
2
votes
1 answer

EPPlus Line chart cannot align axis to tick marks

I'm using C# and EPPlus to import csv files and make line charts. Everything works great except: In Excel, aligning the axis position "on tick marks" is easy but I cannot figure out how to do it in C#/EPPlus. It may have something to do with the…
Freddie Lochner
  • 27
  • 6
2
votes
0 answers

How to copy a worksheet from a workbook to new Workbook in Epplus?

try { FileInfo resultFile = new FileInfo(@"C:\\Users\\350154\\Desktop\\vb workouts\\testsample.xlsx"); if (resultFile.Exists) { resultFile.Delete(); } ExcelPackage masterPackage = new ExcelPackage(new…
Moni
  • 47
  • 2
  • 11
2
votes
1 answer

Changing color of a line serie in EPPlus

Is there an easier way to change the color of a line serie? I tried using this. But the serieNode is producing a NullReferenceException at serieNode.AppendChild(spPr);. Here's the code that generates the graph: private void…
HelloWorld
  • 67
  • 2
  • 15
2
votes
3 answers

EPPlus Hyperlink to cell in another sheet

i'm struggling with adding hyperlinks to another list to my generated excel file. I tried it like this: ws.Cells[1, 1].Formula="HYPERLINK(\"[#]'sheetName'!R4C1\";\"linktext\")" ws.Cells[1,…
Evlo
  • 103
  • 1
  • 8
1 2
3
…
12 13