ByteScout Spreadsheet SDK – C# – Use Rich Formatting to Create Report

  • Home
  • /
  • Articles
  • /
  • ByteScout Spreadsheet SDK – C# – Use Rich Formatting to Create Report

ByteScout Spreadsheet SDK – C# – Use Rich Formatting to Create Report

Program.cs

using System;
using System.Collections.Generic;
using System.Drawing;
using System.Text;
using Bytescout.Spreadsheet;
using Bytescout.Spreadsheet.Constants;
using System.IO;
using System.Diagnostics;

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; // delete output file if exists already if (File.Exists("Output.xls")){ File.Delete("Output.xls"); } // Save document document.SaveAs("Output.xls"); // Close Spreadsheet document.Close(); // open generated XLS document in default program Process.Start("Output.xls"); } } } [/csharp]


  Click here to get your Free Trial version of the SDK

prev
next