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

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

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

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#.

Try ByteScout Spreadsheet SDK today: Get 60 Day Free Trial or sign up for Web API

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

Try ByteScout Spreadsheet SDK today: 60 Day Free Trial (on-premise version) or sign up for Web API (on demand version)



Get 60 Day Free Trial or Visit ByteScout Spreadsheet SDK page

Explore ByteScout Spreadsheet SDK documentation


Sign Up for free Web API key

Explore Web API Documentation