Stack Overflow
Stack Overflow

Questions tagged [excelpackage]

ExcelPackage is open-source software that provides server-side generation of Microsoft Excel 2007 spreadsheets.

From the ExcelPackage homepage:

ExcelPackage provides server-side generation of Excel 2007 spreadsheets.
It is a set of classes and wrappers around the .NET 3.0 System.IO.Packaging API and the new Office Open XML file format. It extracts away the complexity of dealing with the individual XML components making it real easy to create sophisticated spreadsheets on the server.

58 questions
2
votes
2 answers

OpenOfficeXML: Copy worksheet from one work book to another

We are using OpenOfficeXML and so far working well. We now have a scenario where we need to copy multiple worksheets from different workbooks and put them into a single workbook (as multiple worksheets). 1.The option is not present in the Office…
Kangkan
  • 15,267
  • 10
  • 70
  • 113
2
votes
1 answer

C# ExcelPackage set cell type as number

I am using c# .net. I am creating a new excel file from scratch. Some of the cells contain text and some of the cells contain number. How can I set using C# ExcelPackage a cell's type as number?
Michael Blok
  • 221
  • 1
  • 4
  • 15
2
votes
3 answers

Adding href to Excel Export C#

I need help with this issue, I'm exporting my datatable into an excel file which works fine. the problem is I'm trying to make one of the columns a hyperlink to a document but as it starts to build out the excel file I get this error. Thank you in…
Thirdletter_CutsClean
  • 91
  • 2
  • 10
2
votes
1 answer

EPPlus - saving InvalidOperationException

I'm trying to save a file using EPPlus, but I keep getting an InvalidOperationException on the Save() line. System.IO.File.Copy(strSource, strNewNotePath, true); ExcelPackage xlPackage = new ExcelPackage(new…
Jez Clark
  • 383
  • 5
  • 19
2
votes
2 answers

Can't create XLSX with apostrophe using ExcelPackage using C#

I am using Excelpackage.codeplex.com to create xlsx. When writing a string with apostrophe (') I get a System.Xml.XPath.XPathException exception. How can I write an xlsx cell with ' using that package? private void ExportApostrphoe() { …
Michael Blok
  • 221
  • 1
  • 4
  • 15
1
vote
0 answers

How I can save in a Excel file using c# only the links of the pages that are with Status 404

The application I am working on must take every link saved in an excel and run it, and in case the page status is 404, I have to save each link in a new excel (by that I mean in a excel to be all, not each link in a separate excel). So far I've…
VladZ
  • 11
  • 3
1
vote
1 answer

How to show line break in excel c#

I am using ExcelPackage to generate excel in C# application. String has new line character in it but excel doesn't show it by default. When I click on cell twice then only it shows new line otherwise whole text display in single line. Below is the…
Anil
  • 1,669
  • 5
  • 19
  • 44
1
vote
1 answer

Generate .csv UTF8 with ExcelPackage()

I am trying to generate a csv with UTF8 encoding with c#, using ExcelPackage (). Excel is identifying the file as .xlsx and not UTF8. My code: using (ExcelPackage package = new ExcelPackage()) { ExcelWorksheet ws =…
gabi13
  • 101
  • 8
1
vote
0 answers

not able to save data into excel file

using (ExcelPackage package = new ExcelPackage(new FileInfo("jsonToExcel.xlsx"))) { ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("abc"); using (StreamReader reader = new StreamReader(jsonFileName)) { …
Mohan Kurali
  • 362
  • 1
  • 4
  • 15
1
vote
1 answer

EPPlus Array dimensions exceeded supported range. System.OutOfMemoryException

Ok so I am trying to load a CSVStream into an ExcelPackage (I am using EPPlus). It always fails at line 221482, no matter what option I choose. I am running on x64 and I have in my app.config... The error given is the one from the title :( …
Cătălin Rădoi
  • 1,804
  • 23
  • 43
1
vote
1 answer

Assembly Not Being Recognized

I built a VB Windows Forms application a while back using VS05 (or VS08? Not exactly sure) that I've recently converted to use VS10. I reference a .dll called ExcelPackage (another article, usage) so that I can create/manipulate Excel docs…
Jason
  • 51,583
  • 38
  • 133
  • 185
1
vote
0 answers

Display wait loader popup while generating excel file and hide after download is complete

I want to add a modalpopup or a wait loader while the file is being generated and as soon as it downloads, I want to hide the popup. This is just to lock the screen so that there is no interference while the file is being generated and the response…
Ankan Kumar Giri
  • 243
  • 1
  • 3
  • 12
1
vote
1 answer

.NET C# exporting to excel via JS post using ExcelPackage

I'm not sure what I'm missing here. I've got a button that when clicked, I'm using javascript to call a controller. This controller should create an excel file and return it to the user giving them the ability to download/save the file. I've tried a…
Brandon
  • 3,074
  • 3
  • 27
  • 44
1
vote
2 answers

Force Landscape ExcelPackage c#

I wanted to generate Excel sheets from C#, so I used the ExcelPackage libraries to do so. Everything works fine and I am able to generate and download the sheet. The last thing I want to achieve is setting the sheet from Portrait to Landscape…
Max
  • 12,622
  • 16
  • 73
  • 101
1
vote
1 answer

Overloading Extension Methods

Is it possible to overload Extension Methods? I did something like this public static ExcelWorksheet CreateSheet(this ExcelPackage thisPackage, List list) { ExcelWorksheet worksheet =…
Ody
  • 2,012
  • 4
  • 25
  • 35
1
2
3 4