Top "Epplus" questions

Writing an Excel file in EPPlus

I have been stuck on this for days and despite all of the help out there, none of these solutions …

c# epplus

EPPlus - Read Excel Table

Using EPPlus, I want to read an excel table, then store all the contents from each column into its corresponding …

c# excel c#-4.0 epplus epplus-4

Export DataTable to Excel with EPPlus

I want to export a data table to an Excel file with EPPlus. That data table has a property with …

c# excel datatable export epplus

Auto column width in EPPlus

How to make columns to be auto width when texts in columns are long? I use this code Worksheet.Column(…

c# .net vb.net epplus

Excel to DataTable using EPPlus - excel locked for editing

I'm using the following code to convert an Excel to a datatable using EPPlus: public DataTable ExcelToDataTable(string path) { var …

c# excel epplus

How to set XLSX cell width with EPPlus?

Hello I have this code where i create an xlsx file and i need to pre set the width of …

c# .net epplus

Using EPPlus with a MemoryStream

I am using EPPlus to generate an XLSX file in C#. As soon as I instantiate the ExcelPackage with a …

c# excel epplus

Excel date format using EPPlus

I'm having trouble with format my cells to Date. FileInfo info = new FileInfo(path); using (ExcelPackage package = new ExcelPackage(info)) { …

c# epplus

EPPlus number format

I have an Excel sheet generated with Epplus, I am experiencing some pain points and I wish to be directed …

c# asp.net .net excel epplus

Set custom BackgroundColor of a Excel sheet cell using epplus c#

The problem: I am using EEPlus. I am stuck at applying a hex color code, e.g. #B7DEE8, for …

c# openxml epplus