SpreadsheetGear Namespace : IFont Interface |
Represents the font of a cell, range or object. Setting the properties of an instance of IFont modifies the font properties of the represented cell, range or object.
For a list of all members of this type, see IFont members.
[Visual Basic]
Public Interface IFont
[C#]
public interface IFont
[C++]
public __gc __interface IFont
[C++/CLI]
public interface class IFont
[C#]
class Program
{
static void Main()
{
// Create a workbook.
SpreadsheetGear.IWorkbook workbook = SpreadsheetGear.Factory.GetWorkbook();
// Get the worksheet and change the name.
SpreadsheetGear.IWorksheet worksheet = workbook.Worksheets["Sheet1"];
worksheet.Name = "2005 Sales";
// Get the worksheet cells reference.
SpreadsheetGear.IRange cells = worksheet.Cells;
// Add column headers.
cells["B1"].Formula = "Jan";
cells["C1"].Formula = "Feb";
cells["D1"].Formula = "Mar";
// Add row headers.
cells["A2"].Formula = "Jennifer";
cells["A3"].Formula = "William";
cells["A4"].Formula = "Kristen";
// Add random data.
cells["B2:D4"].Formula = "=RAND()*10000";
// Center the column headers.
cells["B1:D1"].HorizontalAlignment = SpreadsheetGear.HAlign.Center;
// Bold the row and column headers.
cells["B1:D1,A2:A4"].Font.Bold = true;
// Format the data as currency.
cells["B2:D4"].NumberFormat = "$#,##0";
// Write the workbook.
workbook.SaveAs("2005 Sales.xls", SpreadsheetGear.FileFormat.XLS97);
}
}
[Visual Basic]
Class Program
{
Static void Main()
{
// Create a workbook.
SpreadsheetGear.IWorkbook workbook = SpreadsheetGear.Factory.GetWorkbook();
// Get the worksheet And change the name.
SpreadsheetGear.IWorksheet worksheet = workbook.Worksheets["Sheet1"];
worksheet.Name = "2005 Sales";
// Get the worksheet cells reference.
SpreadsheetGear.IRange cells = worksheet.Cells;
// Add column headers.
cells["B1"].Formula = "Jan";
cells["C1"].Formula = "Feb";
cells["D1"].Formula = "Mar";
// Add row headers.
cells["A2"].Formula = "Jennifer";
cells["A3"].Formula = "William";
cells["A4"].Formula = "Kristen";
// Add random Data.
cells["B2:D4"].Formula = "=RAND()*10000";
// Center the column headers.
cells["B1:D1"].HorizontalAlignment = SpreadsheetGear.HAlign.Center;
// Bold the row And column headers.
cells["B1:D1,A2:A4"].Font.Bold = True;
// Format the Data As Currency.
cells["B2:D4"].NumberFormat = "$#,##0";
// Write the workbook.
workbook.SaveAs("2005 Sales.xls", SpreadsheetGear.FileFormat.XLS97);
}
}
Namespace: SpreadsheetGear
Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family
Assembly: SpreadsheetGear (in SpreadsheetGear.dll)
IFont Members | SpreadsheetGear Namespace
See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.
Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.
SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.