Top "Epplus" questions

Converting Excel cell to percentage using epplus

I would like to convert the value in to 2 decimal places. I am using EPPlus if the value is 66.6666667 and …

c# epplus

How To Set Cell Data Type

I am trying to set data type of cell, but it seems that's impossible to do with EPPlus. If I …

types cell epplus

Force EPPLUS to read as text

I'm developping an application to read xlsx files, do some validation and insert into database. Unfortunatelly when I try to …

c# epplus

Worksheet position out of range. Connection Closed. When using EPPLUS

I am trying to open an XLSX file as a template (I have even used a blank XLSX file), using …

excel worksheet-function epplus worksheet epplus-4

EPPlus Font Family Not Affected

I'm using asp.net MVC 4 and epplus as a nuget package for exporting my data into an excel file. I …

c# asp.net-mvc-4 epplus

How can I create multistyled cell with EPPlus library for Excel

I use EPPlus for Excel file generation. I mean I need to convert HTML text (bold, italic, font color, name, …

c# excel openxml epplus

Autofit Row Height of Merged Cell in EPPlus

I'm using EPPlus and C# and trying to autosize/autofit the height of a row to accommodate the height needed …

c# excel epplus

Convert XLSM to XLSX

I'm using the EPPLUS library to read data from Excel to create another file. Unfortunately it does not support the .…

c# openxml xlsx epplus xlsm

EPPlus save two million rows with 200+ columns datatable to multiple excel files

I have function that saves all records from SQL table to excel worksheet using EPPlus. If I export small amount …

c# .net-4.5 epplus epplus-4

EPPlus Changing Border Color of cells

I'm trying to change the cell border color on a selected range. Couldn't find any other styles for cell borders …

c# excel epplus