Top "Epplus" questions

EPPlus is a .NET library that reads and writes Excel files using the Office Open XML format (xlsx) without the need of interop.

Epplus cell range numerically

In EPPlus extension, if I need to set style for a range of cells such as A1 to C1, I …

c# excel epplus
How to group rows/columns in EPPlus

Is there a way to achieve this in EPPlus? Only thing I could find on the internet is grouping specific …

c# excel openxml epplus
Error dialog displayed when opening an excel file generated with EPPlus

I am creating an Excel file using the EPPlus library. When I create file and open up the file, the …

c# asp.net excel epplus
Failed - network error when downloading excel file made by EPPlus.dll

I try to download an excel file made by EPPlus.dll from an asp.net c# web form application. but …

c# asp.net excel epplus
How to get the column index of the current cell?

I have this code here... For Each cell In worksheet.Cells(8, 2, lastRow, lastCol) Select Case "What Goes Here" End Select …

c# vb.net excel epplus
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 …

epplus epplus-4
EPPlus custom header column names

I have following code, which generate me an excel with header row. The column names of header are named as …

c# epplus
epplus: How do I get a row's height after setting column's wraptext style to true?

After I set a column's WrapText=true, I want to see what the new height of the row will be (…

epplus
Expand a table in EPPlus C#

Is there any way that I can expand an existing table in EPPlus in C#. The way my program works …

c# excel epplus
EPplus To Insert X Number of Blank Rows

I have an instance where if a cell value is between 15 and 25 then I need to insert 10 blank rows, if …

c# epplus epplus-4