Free Trial
Web API version
Licensing
Request A Quote
HAVE QUESTIONS OR NEED HELP? SUBMIT THE SUPPORT REQUEST FORM or write email to SUPPORT@BYTESCOUT.COM
Fonts Available For Cells | C#
Program.cs:
C#
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"); } } }