I am looking for a way to create, modify, read .xlsx files in C# without installing Excel or creating files on the server before giving to the user to download. I found NPOI http://npoi.codeplex.c...

I use this package: ExcelPackage though I can't figure out how to set the background color for the cell. I tried to use this: ws.Cells["A1"].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillS...

i want to fill an excel file and so i use ExcelPackage: Office Open XML Format . but i have an error. my code: string fileName = "DBE_BAKIM_FORMU" + ".xlsx"; FileInfo fi = new FileInfo(HttpContext...

I am trying to build a data import tool that accepts an EXCEL file from the user and parses the data from the file to import data into my application. I am running across a strange issue with Dele...

I want to write excel file using excel package from System.Data.DataTable and need to format some cells in excel file like back ground color. How can I do that?

How can I set the currency format for an Excel cell that is created with ExcelPackage? worksheet.Cell(i, 7).Value = item.Price.ToString();