Using EPPlus, I want to read an excel table, then store all the contents from each column into its corresponding List. I want it to recognize the table's heading and categorize the contents based o...

I am working with EPPlus and try to place a image into B1 cell. I found a nice post which show how to detect aspect ratio and set size for image accordingly. I saw his code but still few things are...

I'm using EPPlus to read excel files. I have a single cell that is part of merged cells. How do I get the merged range that this cell is part of? For example: Assume Range ("A1:C1") has b...

What is the command needed in EPPlus , to move a worksheet location in a workbook? I couldn't find any Move command for EPPlus only Interop.

I am exporting SSRS reports into to individual excel files and I am merging them into one file using EPPlus. Merge happens successfully but I get following error when I try to open the file in Exce...

I want to export a data table to an Excel file with EPPlus. That data table has a property with int type, so I want the same format in the Excel file. Does anyone know way to export a DataTable l...

using .net 4.5 I'm trying to read .xls/.xlsx file using EPPlus (v4.0.4), but get an error. SO has questions on the same error but none relate or solve my problem. protected void Page_Load(object...

I am editing an existing spreadsheet in C# using EPPlus. I am altering the raw data on the second worksheet which is being used as the data source for a Pivot table on the first worksheet. My edits...

I searched a lot, but i ended up here asking this question. There is no satisfying answer to my question: I want to create an excel pivot (WorkSheet1 as PivotTable, WorkSheet2 as Data Source) I don...

Using VS2019 I have generated an Azure Function project. The Azure function is triggered by an HTTP request to convert CSV content to an XLSX file using EPPlus. The code is really really simple: [F...

I am trying to generate an Excel file using the following code: public static Stream GenerateFileFromClass<T>(IEnumerable<T> collection, int startrow, int startcolumn, byte[]templateRes...

I have an Excel template that has a table (range: A4:AM5) which I need to expand by inserting rows via EPPlus. My code inserts the cell values in the file with no problem, but I need to extend the ...

I am able to generate Column Stacked chart using EPPlus. There is is requirement to change the color of datapoint. I found the solution of at enter link description here but it only changes the co...

I'm using the EPPLUS library to read data from Excel to create another file. Unfortunately it does not support the .XLSM extension file. Is there a nice way to convert .XLSM files to .XLSX file for...

I want to freeze first 5 columns and three rows in excel. I have written the following code for that Worksheets.View.FreezePanes(5, 5); but it freezes columns in first 4 rows also. I want to fre...

This problem has me completely puzzled. I have a Excel document which loads in just fine. It has rows, columns and data and I want to iterate through the rows. But EPPLus is odd. I take the sec...

I can set the background color of a cell or range of cells like so: rowRngprogramParamsRange.Style.Fill.PatternType = ExcelFillStyle.Solid; rowRngprogramParamsRange.Style.Fill.BackgroundColor.SetC...

I am using EPPlus library in my .net core web api. In the said method I want to validate he uploaded excel. I want to find out if my entire row is empty. I have the following code: using (ExcelPac...

Is there a way to make a column or group of cells locked or read only using EPPlus? I've tried the code below both separate and together however neither seems to have the desired effect. Either the...

Hello I have this code where i create an xlsx file and i need to pre set the width of the xlsx sheet cells. The actual problem is that when i open the excell i need to double click on the gap betw...

I use EPPlus to export excel 2007 file. The file can export normally but i have some problem with setting column format. My string column with numeric style (Purchase Order No. ex. 49000001) be exp...

The problem: I am using EEPlus. I am stuck at applying a hex color code, e.g. #B7DEE8, for a cell in my Excel sheet. I got the following (working) code: ws.Cells["A1:B1"].Style.Fill.PatternType...

I want to clone worksheet int my excel template file programatically. When Using NPOI library I can use HSSFWorkbook workbook = new HSSFWorkbook(fs, true); workbook.CloneSheet(1); I wonder is ...

In our Asp.Net Core API application we load a templated Excelfile using EPPlus. Add in the data from the database and use .GetAsByteArray() to return a generate Excel file. I now need give the user...

In my MVC 5 site, I have an Export to Excel function that is stable, but the users have requested that I make the column headers "user friendly." In my model, I use the [Display(Name="Friendly Col...