Top "Epplus" questions

EPPlus: How to style merged cells?

Edit: These examples should all work. My problem was actually unrelated to epplus and this code as well as the …

c# epplus office-2013

Why is EPPlus telling me that I "Can't set color when patterntype is not set" when I have set PatternType?

I've got this code to try to style a header row: worksheet.Cells["A32:D32"].Style.Font.Name = "Georgia"; worksheet.…

c# excel epplus epplus-4

How can I give line break in excel epplus c#

I am using Epplus library to convert dataTable in Excel. I am using a textarea in my front end site. …

c# asp.net epplus

Conditional Formatting by Expression using EPPlus

I'm trying to format some range by using conditional Formatting feature of EPPlus. I read many document but there is …

c# excel excel-2007 conditional-formatting epplus

Unreadable content in Excel file generated with EPPlus

I'm having a little problem when I generate an Excel file from a template, using the EPPlus library. The file …

c# .net excel xlsx epplus

Reading Excel spreasheet using EPPlus

Could someone point me in the right direction on how to read a Excel spreasheet, loop through all the rows …

model-view-controller epplus

Bold and Italics not working in excel with EPPLUS

I am using the below code for updating excel data format, here I want the heading to be in bold …

c# excel interop epplus

Adding a specific autofilter on a column

I'm trying to set a filter on a column. This is the way I did it in Interop: private void …

c# excel epplus autofilter

EPPlus autofilter only working on last cell

I would like each cell in the header to contain an autofilter. Below is the code I'm trying to use …

c# .net excel epplus

Freezing columns in EPPlus (an Excel split function)

I've been working a lot with EPPlus to generate Excel files for the number of exports that my project requires …

c# excel export epplus