HorizontalAlignment = HorizontalAlignmentStyle.Center, FillPattern = FillPatternStyle.Solid, FillPatternForegroundColor = SpreadsheetColor.FromName(ColorName.DarkBlue), FontColor = SpreadsheetColor.FromName(ColorName.White) ; worksheet.Cells.GetSubrange("A1:D1").Style = headerStyle;
// Style a header var headerStyle = new CellStyle gembox.spreadsheet.dll
// Add data worksheet.Cells[0, 0].Value = "Product"; worksheet.Cells[0, 1].Value = "Qty"; worksheet.Cells[0, 2].Value = "Price"; worksheet.Cells[0, 3].Value = "Total"; HorizontalAlignment = HorizontalAlignmentStyle