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

Setting the color of a cell using ExcelPackage

I am using vb.net and I have an asp.net application where I use ExcelPackage. I wanted to know how to set the background color of a particular cell or a row of cells.
Frank
  • 2,015
  • 10
  • 36
  • 57
0
votes
0 answers

ASP.NET Core Web API - Export to excel is limited to only the current page

I have this code in ASP.NET Core Web API. The user can use search query and then export to excel or just export to excel straight. It has maximum of ten (10) records per page. However, I observed that only the current page (not more than 10 records)…
Ayobamilaye
  • 1,099
  • 1
  • 17
  • 46
0
votes
1 answer

How can I show Excel data with excel flutter package?

I want to see information such as: [A1:A20] Data in column A after receiving the Excel information through the 'file_picker 5.2.5' and 'excel 2.0.1' package in flutter web. I used this code And I could print "sheetName" in last: void _giveExcel()…
MhmdRza
  • 1
  • 1
0
votes
1 answer

write to excel - loop through rows&columns missing data - C#

The following code write to excel the right count of rows, but the data inside the file contains only the last data of the list, why? (in my case 84 rows with repeate data that inside arr[list.Capacity -1]) Thanks!! List titles = new…
bob2 habanay
  • 59
  • 5
0
votes
0 answers

How do I get checkbox checked or unchecked state using EPPlus ExcelPackage in c#

There are 2 checkboxes, check box 6 - YES and check box 7 - NO. How do I get their checked or unchecked state using EPPlus package.. I have tried this, but in vain.. var package = new ExcelPackage(@”C:\file.xlsm”); var worksheets =…
Yadu Mandayam
  • 1
0
votes
1 answer

Excel Upload Error using EPPlus ExcelPackage

I am getting error when trying to read excel file from Request.Files (InputStream), but error came up just from a windows server machine. any idea about something missing? EPPlus version is 4.5.2.1 Error Line: foreach (string file in…
Edgar Valenzuela
  • 1
0
votes
0 answers

Is there any other solution in Excelpackage in C# (Using OfficeOpenXml in EPPlus.dll)

i used EPPlus.dll as my library in creating Excel sheets. But using these codes, i got an error: Exception thrown: 'System.NullReferenceException' in ExcelReports.cs:line 37 28. String filename = "D:\\" + MonthYear + "_journal.xls"; …
Tangub City Fire Station
  • 5
  • 3
0
votes
1 answer

Use an excel template and update it programatically

I found this tool but I wonder if it still the right way nowdays with net 4.0 or is there any straight forward oob alternatives. I just need to add columns and update excel stuff programatically. There are many ways but I need to keep the original…
tutetimas
  • 31
  • 3
0
votes
1 answer

c#- Json as stream to excel

I have .json files stored in AWS S3 bucket. I use the function OpenStreamAsyncto get a specified file and I want to read it and arrange the items according to the way I expect them to be in the .json file but into excel (I use EEPlus). What is the…
user4675862
  • 35
  • 1
  • 6
0
votes
1 answer

Parse excel data and create multidimensional array

I have an excel file which could would have contents as shown below. It has dynamic rows and columns. I can read from the excel fine. I want to create a custom jarray and return to my UI from this. Example1 id lotno stateno 1 22 …
kaka1234
  • 770
  • 3
  • 9
  • 30
0
votes
0 answers

ExcelPackage reads empty rows in C#

I want ro read my excel file. It reads file in a nice way. It gets the row count using this code var package = new ExcelPackage(filename) var worksheet = package.Workbook.Worksheets[1]; int rowCount = worksheet.Dimension.Rows; It works fine.But my…
Janani
  • 175
  • 1
  • 2
  • 9
0
votes
1 answer

How to stop the javascript loader when the data retrieved from the database

I'm using a javascript with setTimeout function to display a GIF on a onclientclick of a button. I;m trying to stop/hide the GIF once the data is retrieved from the database. So far no luck. I have tried the following. Any help is greatly…
kas_miyulu
  • 335
  • 1
  • 5
  • 27
0
votes
1 answer

Having trouble with the file saved using ExcelPackage

So i have to create a XLSX File in this structure: PAYMENT CUSTOMER DT_CRIACAO KEY_ORIGEM VL_LIQUIDO 6129385 5026977 29/06/2017 00:00:00 AR_PREV-6129385/14634986 186,48 6129385 5026977 29/06/2017 00:00:00 …
Lucio Zenir
  • 365
  • 2
  • 8
  • 18
0
votes
1 answer

Check for password protected file with EPPlus ExcelPackage

What is the correct way to check is an excel file is password protected (I do not know the password)? When I try to open it I get a non-specific exception ("A disk error occurred during a write operation.") that could be related to any other type of…
Z .
  • 12,657
  • 1
  • 31
  • 56
0
votes
1 answer

ExcelPackage excel file load collection

I have been using openxml from excelpackage to manipulate excel spreadsheet and I am stumbled on a function called LoadFromCollection. Here is a sample code to understand. Dim ws As OfficeOpenXml.ExcelWorksheet ws =…
user2118542
1 2
3
4