ByteScout Barcode Suite – C# – Fonts available for cells with spreadsheet sdk

Home
/
Articles
/
ByteScout Barcode Suite – C# – Fonts available for cells with spreadsheet sdk

printable version:
ByteScout-Barcode-Suite-C-sharp-Fonts-available-for-cells-with-spreadsheet-sdk.pdf

fonts available for cells with spreadsheet sdk in C# with ByteScout Barcode Suite

How to apply ByteScout Barcode Suite for fonts available for cells with spreadsheet sdk in C#

The samples of source code documentation give a quick and simple method to apply a required functionality into your application. ByteScout Barcode Suite helps with fonts available for cells with spreadsheet sdk in C#. ByteScout Barcode Suite is the bundle that privides 3 SDK products to generate barcodes (Barcode SDK), read barcodes (Barcode Reaer SDK) and read and write spreadsheets (Spreadsheet SDK).

If you want to quickly learn then these fast application programming interfaces of ByteScout Barcode Suite for C# plus the guideline and the C# code below will help you quickly learn fonts available for cells with spreadsheet sdk. If you want to know how it works, then this C# sample code should be copied and pasted into your application’s code editor. Then just compile and run it. C# application implementation mostly involves various stages of the software development so even if the functionality works please check it with your data and the production environment.

ByteScout Barcode Suite free trial version is available for download from our website. Free trial also includes programming tutorials along with source code samples.

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.Text;
using System.Diagnostics;
using Bytescout.Spreadsheet;
using System.IO;

namespace HelloWorld
{
    class Program
    {
        static void Main(string[] args)
        {
            // Create new Spreadsheet
            Spreadsheet document = new Spreadsheet();

            // Add new worksheet
            Worksheet worksheet = document.Workbook.Worksheets.Add("HelloWorld");

            // Create array with font names
            string[] fontNames = new string[] {
                                              "Helvetica", 
                                              "Times New Roman", 
                                              "Verdana",
                                              "Times New Roman"
            };

            // Use all fonts in fontsNames array
            for (int i = 0; i < fontNames.Length; i++)
            {
                // Set font size based on loop counter
                float fontSize = 10 + i * 3;

                //Set cell font type and font size
                worksheet.Cell(i, 0).Font = new System.Drawing.Font(fontNames[i], fontSize);

                // Set cell value
                worksheet.Cell(i, 0).Value = fontNames[i];
            }

            // delete output file if exists already
            if (File.Exists("Fonts.xls")){
                File.Delete("Fonts.xls");
            }

            // Save document
            document.SaveAs("Fonts.xls");
            
            // Close document
            document.Close();

            // open generated XLS document in default program
            Process.Start("Fonts.xls");
        }
    }
}