using System;

using System.Collections.Generic;

using System.Drawing;

using System.Text;

using Bytescout.Spreadsheet;

using Bytescout.Spreadsheet.Constants;



namespace Using_rich_formatting_to_create_a_XLS_report

{

class Program

{

static void Main(string[] args)

{

// Create new Spreadsheet

Spreadsheet document = new Spreadsheet();

// Add new worksheet

Worksheet worksheet = document.Workbook.Worksheets.Add("AdvancedReport");

// Set Values

worksheet.Cell(0, 0).Value = "Name";

worksheet.Cell(0, 1).Value = "Full Name";

Color headerColor = Color.FromArgb(75, 172, 198);

Color contentColor = Color.FromArgb(141, 180, 227);

// Set font bold for headers

worksheet.Cell(0, 0).Font = new Font("Arial", 12, FontStyle.Bold);

worksheet.Cell(0, 1).Font = new Font("Arial", 12, FontStyle.Bold);

// Set back color for headers rows

worksheet.Cell(0, 0).FillPattern = PatternStyle.Solid;

worksheet.Cell(0, 0).FillPatternForeColor = headerColor;

worksheet.Cell(0, 1).FillPattern = PatternStyle.Solid;

worksheet.Cell(0, 1).FillPatternForeColor = headerColor;

worksheet.Cell(6, 0).FillPattern = PatternStyle.Solid;

worksheet.Cell(6, 0).FillPatternForeColor = headerColor;

worksheet.Cell(6, 0).FontColor = Color.White;

worksheet.Cell(6, 1).FillPattern = PatternStyle.Solid;

worksheet.Cell(6, 1).FillPatternForeColor = headerColor;

// Set back color for content rows

for (int i = 1; i < 6; i++)

{

worksheet.Cell(i, 0).FillPattern = PatternStyle.Solid;

worksheet.Cell(i, 0).FillPatternForeColor = contentColor;

worksheet.Cell(i, 1).FillPattern = PatternStyle.Solid;

worksheet.Cell(i, 1).FillPatternForeColor = contentColor;

}

worksheet.Cell(1, 0).Value = "Homer";

worksheet.Cell(1, 1).Value = "Homer Jay Simpson";

worksheet.Cell(2, 0).Value = "Marjorie";

worksheet.Cell(2, 1).Value = "Marjorie Marge Simpson (Bouvier)";

worksheet.Cell(3, 0).Value = "Bartholomew";

worksheet.Cell(3, 1).Value = "Bartholomew Jojo Bart Simpson";

worksheet.Cell(4, 0).Value = "Lisa";

worksheet.Cell(4, 1).Value = "Lisa Marie Simpson";

worksheet.Cell(5, 0).Value = "Margaret";

worksheet.Cell(5, 1).Value = "Margaret Maggie ";

worksheet.Cell(6, 0).Value = "Count";

worksheet.Cell(6, 1).Value = "5";

worksheet.Columns[1].Width = 250;

worksheet.Columns[2].Width = 250;

// Save document

document.SaveAs("AdvancedReport.xls");

}

}

}

Download example source code: bytescoutxls_using_rich_formatting_to_create_xls_report.zip (5 KB)