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.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Interface IFont |
| C# | |
|---|
public interface IFont |
Example
| C# |  Copy Code |
|---|
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 | Copy Code |
|---|
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);
}
} |
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also
