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.

How to access worksheets in EPPlus?

I'm using the 3.1 release of EPPlus library to try to access a worksheet in an Excel file. When I try …

c# epplus
Adding images into Excel using EPPlus

I am trying to add the same image multiple times into an excel file using EPPlus. I am using the …

c# epplus
Epplus not reading excel file

Below is my code to read excel file. Code. FileInfo newFile = new FileInfo("C:\\Excel\\SampleStockTakeExceptionReport.xls"); ExcelPackage pck = new …

c# visual-studio-2010 epplus
invoke formula in excel via epplus

I have an excel sheet in ASP.NET MVC4 C# project and I am able to read from excel sheet …

c# excel asp.net-mvc-4 epplus
Error when trying to read an .xls file using EPPlus

The following code is working fine for .xlsx, but it's not working for .xls. I got this error message Can …

c# excel epplus
How to Horizontalalign Center merged cells in EPPlus

I am having an issue getting a range of merged cells to horizontal align centered. The alignment stays as left. …

c# epplus
Downloading Excel file after creating using EPPlus

I am using the EPPlus library to generate an excel file which I successfully save in a folder on the …

c# asp.net-mvc download epplus
How to parse excel rows back to types using EPPlus

EPPlus has a convenient LoadFromCollection<T> method to get data of my own type into a worksheet. For …

c# epplus
C# create/modify/read .xlsx files

I am looking for a way to create, modify, read .xlsx files in C# without installing Excel or creating files …

c# excel npoi epplus excelpackage
Formatting a column with EPPLUS Excel Library

I wrote a C# program to create an excel spreadsheet. The sheet has multiple columns. I want to format ONE …

c# export-to-excel epplus number-formatting