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
Namespace: SpreadsheetGear
Platforms: Windows 2000, Windows XP, Windows Vista, Windows Server 2003 and Windows Server 2008. SpreadsheetGear 2009 requires the Microsoft .NET Framework 2.0 and supports .NET 3.0 and .NET 3.5.
Assembly: SpreadsheetGear (in SpreadsheetGear.dll)
See Also