// Number formatting ws.Cells["B2"].Value = 0.12345; ws.Cells["B2"].Style.Numberformat.Format = "0.00%"; // 12.35%
var worksheet = package.Workbook.Worksheets[0]; // First sheet var value = worksheet.Cells["A1"].Value?.ToString(); var number = worksheet.Cells["B1"].GetValue<double>(); Console.WriteLine($"A1: value, B1: number"); using OfficeOpenXml.Style; var ws = package.Workbook.Worksheets.Add("Styled"); epplus 4.5.3.2
using (var package = new ExcelPackage()) // Number formatting ws
range.Style.Font.Bold = true; range.Style.Font.Color.SetColor(System.Drawing.Color.White); range.Style.Fill.PatternType = ExcelFillStyle.Solid; range.Style.Fill.BackgroundColor.SetColor(System.Drawing.Color.DarkBlue); range.Style.HorizontalAlignment = ExcelHorizontalAlignment.Center; // Number formatting ws.Cells["B2"].Value = 0.12345
new Name = "Alice", Score = 95 , new Name = "Bob", Score = 87 ; ws.Cells["A1"].LoadFromCollection(data, true); // true = headers
