ByteScout Spreadsheet SDK – C# – Fonts Available For Cells

  • Home
  • /
  • Articles
  • /
  • ByteScout Spreadsheet SDK – C# – Fonts Available For Cells

ByteScout Spreadsheet SDK – C# – Fonts Available For Cells

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"); } } } [/csharp]


  Click here to get your Free Trial version of the SDK

prev
next