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

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

printable version:
ByteScout-Spreadsheet-SDK-C-sharp-Use-Rich-Formatting-to-Create-Report.pdf

How to use rich formatting to create report in C# with ByteScout Spreadsheet SDK

Tutorial on how to use rich formatting to create report in C#

Learn how to use rich formatting to create report in C# with this source code sample. ByteScout Spreadsheet SDK can use rich formatting to create report. It can be used from C#. ByteScout Spreadsheet SDK is the SDK that can write and read, modify and calculate Excel and CSV spreadsheets. Most popular formulas are supported. You may import or export data to and from CSV, XML, JSON as well as to and from databases, arrays.

The SDK samples like this one below explain how to quickly make your application do use rich formatting to create report in C# with the help of ByteScout Spreadsheet SDK. This C# sample code is all you need for your app. Just copy and paste the code, add references (if needs to) and you are all set! Enjoy writing a code with ready-to-use sample codes in C#.

Free trial version of ByteScout Spreadsheet SDK is available for download from our website. Get it to try other source code samples for C#.

On-demand (REST Web API) version:
Web API (on-demand version)

On-premise offline SDK for Windows:
60 Day Free Trial (on-premise)

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");

        }
    }
}