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

Exception occurs reading spreadsheet after saving ExcelPackage (EPPlus)

I am manipulating data in a .xlsx spreadsheet using EPPlus (4.0.4) and saving the file, immediately afterwards I am loading parts of the data into datatables. After I call the .Save() method the spreadsheet is saved but then I get a 'External table…
plm
  • 13
  • 3
0
votes
1 answer

ExcelPackage throws "File contains corrupted data" error

I am trying to upload a excel file onto a moss 2007 site. In the event handler I try to read the file using ExcelPackage. My code is as below... MemoryStream fileContent = new MemoryStream(); …
user1285836
  • 23
  • 7
0
votes
1 answer

Using ExcelPackage to Read from Excel Template and Write to Excel

I am using the following bit of code: var assembly = Assembly.GetExecutingAssembly(); Stream streamToTemplete=assembly.GetManifestResourceStream("DailyAuction.xltx"); Stream streamToOutput =…
Deepanjan Nag
  • 901
  • 3
  • 14
  • 26
0
votes
1 answer

Get default grid back to sheet ExcelPackage

I created an Excel sheet, using ExcelPackage. I gave some cells a different color, for clearing up the sheet. Problem: The default grid gets removed as in picture below: First Column has the default grid overlay, the other ones don't have this…
Max
  • 12,622
  • 16
  • 73
  • 101
0
votes
2 answers

OpenOfficeXML and HTML written to spreadsheet's cells

I have been trying to write html content into Excel spreadsheet's cells using ExcelPackage OpenOfficeXML and c#. I am getting errors stating that input string has an invalid token. Has anyone came across anything similar? Saving html directly in…
Luke G
  • 1,741
  • 6
  • 23
  • 34
0
votes
1 answer

Change width and height of column using ExcelPackage

I'm writing some code for my NopCommerce webshop, that needs to export an excel sheet. I'm trying to edit the width of the columns, so the text will fit in. I already tried the following code(for 26 columns): //adjust excel column width for (int i =…
Max
  • 12,622
  • 16
  • 73
  • 101
0
votes
2 answers

How to add dropdown in excel sheet programmatically?

I am using the ExcelPackage dll to creating the excel from the .net application. I want to add drop down list in one of column of Excel sheet. How to add it? Also I want to do some formatting changes to the cell values.
Girish
  • 71
  • 1
  • 3
  • 7
0
votes
0 answers

.NET EEPLUS ExcelPackage DataValidation ListValidation fails with large lists

I'm using EEPLUS to export a preformated-excel using for that DataValidation Lists, but I'm getting Error in a large List, here is the code: ExcelPackage pck = new ExcelPackage(); var ws = pck.Workbook.Worksheets.Add("Testing"); …
Santiago
  • 2,190
  • 10
  • 30
  • 59
-1
votes
1 answer

How to fix incorrect date and time values from Excel?

I am using EPPlus excelpackage with c# to get values from a spreadsheet. The spreadsheet has two separate columns Date and Time. The issue is the date value is 2/4/2020 but it returns as 2/4/2020 12:00:00 AM. The time value is 12:21 AM but it…
Roy Rogers
  • 1
  • 3
-1
votes
1 answer

Importing XLSX file using ExcelPackage throws error .NET CORE

I have jquery where I export my table as xlsx file, using data:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=UTF-8. When I want to import that file (updated) I am doing it by this function public static Dictionary
Serlok
  • 432
  • 1
  • 10
  • 24
-1
votes
1 answer

How to password protect an excel generated from a byte[]?

I have the data that has to be loaded to an excel file in a byte array and I need to apply password protection on that. I have tried converting byte[] to datatable/list and tried applying password protection using Excelpackage but I am not able to…
Aparna
  • 17
  • 3
-2
votes
1 answer

How can I get the address of xlsx cell containing provided value?

I have a prepared dictionary in c# and xlsx file with filled columns. I need to find the column's and row's indexes if the cell contains the value provided from a dictionary. I am using ExcelPackage and ExcelWorksheet. Dictionary: public static…
Deryl
  • 66
  • 5
-2
votes
1 answer

Server can download excelpackage file but client can't

I was trying to create excelpackage download function. When i try it on my server or on my local development server, the download button works and it sends Excel file to the browser. But after i deployed and try to download from client, it returns…
donthurtme
  • 1,347
  • 1
  • 10
  • 16
1 2 3
4