Schriftart Einstellungen

Das Erscheinungsbild eines Textes kann durch Ändern der Schriftarteinstellungen gesteuert werden. Die Schriftarteinstellungen können den Namen, den Stil, die Größe, die Farbe und andere Effekte der Schriftarten umfassen. Ganz wie Microsoft Excel unterstützt auch Aspose.Cells das Konfigurieren der Schriftarteinstellungen von Zellen.

Konfigurieren von Schriftarteinstellungen

Aspose.Cells bietet eine Klasse, Workbook, die eine Microsoft Excel-Datei darstellt. Die Klasse Workbook enthält eine Worksheets-Sammlung, die den Zugriff auf jede Arbeitsblatt in einer Excel-Datei ermöglicht. Ein Arbeitsblatt wird durch die Klasse Worksheet repräsentiert. Die Worksheet-Klasse stellt eine Cells-Sammlung bereit. Jedes Element in der Cells-Sammlung repräsentiert ein Objekt der Klasse Cell.

Aspose.Cells bietet die Cell-Klasse' GetStyle und SetStyle-Methoden, die verwendet werden, um den Formatierungsstil einer Zelle abzurufen und festzulegen. Die Klasse Style bietet Eigenschaften zur Konfiguration der Schriftarteinstellungen.

Schriftartname festlegen

Entwickler können eine beliebige Schrift auf den Text innerhalb einer Zelle anwenden, indem sie die Eigenschaft Style.Font des Objekts Name verwenden.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

// Create directory if it is not already present.
bool IsExists = System.IO.Directory.Exists(dataDir);
if (!IsExists)
    System.IO.Directory.CreateDirectory(dataDir);

// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Adding a new worksheet to the Excel object
int i = workbook.Worksheets.Add();

// Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[i];

// Accessing the "A1" cell from the worksheet
Aspose.Cells.Cell cell = worksheet.Cells["A1"];

// Adding some value to the "A1" cell
cell.PutValue("Hello Aspose!");

// Obtaining the style of the cell
Style style = cell.GetStyle();

// Setting the font name to "Times New Roman"
style.Font.Name = "Times New Roman";

// Applying the style to the cell
cell.SetStyle(style);

// Saving the Excel file
workbook.Save(dataDir + "book1.out.xls", SaveFormat.Excel97To2003);

Schriftschnitt auf Fett setzen

Entwickler können den Text fett machen, indem sie die Eigenschaft IsBold des Objekts Style.Font auf true setzen.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET

// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Adding a new worksheet to the Excel object
int i = workbook.Worksheets.Add();

// Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[i];

// Accessing the "A1" cell from the worksheet
Aspose.Cells.Cell cell = worksheet.Cells["A1"];

// Adding some value to the "A1" cell
cell.PutValue("Hello Aspose!");

// Obtaining the style of the cell
Style style = cell.GetStyle();

// Setting the font weight to bold
style.Font.IsBold = true;

// Applying the style to the cell
cell.SetStyle(style);

// Saving the Excel file
workbook.Save("out.xlsx");

Schriftgröße festlegen

Setzen Sie die Schriftgröße mit der Size-Eigenschaft des Objekts Style.Font.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET

// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Adding a new worksheet to the Excel object
int i = workbook.Worksheets.Add();

// Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[i];

// Accessing the "A1" cell from the worksheet
Aspose.Cells.Cell cell = worksheet.Cells["A1"];

// Adding some value to the "A1" cell
cell.PutValue("Hello Aspose!");

// Obtaining the style of the cell
Style style = cell.GetStyle();

// Setting the font size to 14
style.Font.Size = 14;

// Applying the style to the cell
cell.SetStyle(style);

// Saving the Excel file
workbook.Save("out.xlsx");

Schriftfarbe festlegen

Verwenden Sie die Eigenschaft Color des Objekts Style.Font, um die Schriftfarbe festzulegen. Wählen Sie eine Farbe aus der Color-Enumeration (Teil des .NET-Frameworks) aus und weisen Sie sie der Color-Eigenschaft zu.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Adding a new worksheet to the Excel object
int i = workbook.Worksheets.Add();

// Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[i];

// Accessing the "A1" cell from the worksheet
Aspose.Cells.Cell cell = worksheet.Cells["A1"];

// Adding some value to the "A1" cell
cell.PutValue("Hello Aspose!");

// Obtaining the style of the cell
Style style = cell.GetStyle();

// Setting the font color to blue
style.Font.Color = Color.Blue;

// Applying the style to the cell
cell.SetStyle(style);

// Saving the Excel file
workbook.Save("out.xlsx");
            

Schriftart-Unterstrich-Typ festlegen

Verwenden Sie die Eigenschaft Underline des Objekts Style.Font, um Text zu unterstreichen. Aspose.Cells bietet verschiedene vordefinierte Schriftarten-Unterstreichungstypen in der FontUnderlineType Enumeration.

Schriftart-Unterstreichungstypen	Beschreibung
Accounting	Einzelne Buchhaltungsunterstreichung
Double	Doppelte Unterstreichung
DoubleAccounting	Doppelte Buchhaltungsunterstreichung
None	Keine Unterstreichung
Single	Einfache Unterstreichung

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

// Create directory if it is not already present.
bool IsExists = System.IO.Directory.Exists(dataDir);
if (!IsExists)
    System.IO.Directory.CreateDirectory(dataDir);

// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Adding a new worksheet to the Excel object
int i = workbook.Worksheets.Add();

// Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[i];

// Accessing the "A1" cell from the worksheet
Aspose.Cells.Cell cell = worksheet.Cells["A1"];

// Adding some value to the "A1" cell
cell.PutValue("Hello Aspose!");

// Obtaining the style of the cell
Style style = cell.GetStyle();

// Setting the font to be underlined
style.Font.Underline = FontUnderlineType.Single;

// Applying the style to the cell
cell.SetStyle(style);

// Saving the Excel file
workbook.Save(dataDir + "out.xlsx");

Einstellung des Durchgestrichen-Effekts

Wenden Sie den Durchgestrichen-Effekt an, indem Sie die Eigenschaft IsStrikeout des Objekts Style.Font auf true setzen.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET

// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Adding a new worksheet to the Excel object
int i = workbook.Worksheets.Add();

// Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[i];

// Accessing the "A1" cell from the worksheet
Aspose.Cells.Cell cell = worksheet.Cells["A1"];

// Adding some value to the "A1" cell
cell.PutValue("Hello Aspose!");

// Obtaining the style of the cell
Style style = cell.GetStyle();

// Setting the strike out effect on the font
style.Font.IsStrikeout = true;

// Applying the style to the cell
cell.SetStyle(style);

// Saving the Excel file
workbook.Save(dataDir + "out.xlsx");

Einstellen des Tiefgestellt-Effekts

Wenden Sie den Tiefgestellt-Effekt an, indem Sie die Eigenschaft IsSubScript des Objekts Style.Font auf true setzen.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET

// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Adding a new worksheet to the Excel object
int i = workbook.Worksheets.Add();

// Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[i];

// Accessing the "A1" cell from the worksheet
Aspose.Cells.Cell cell = worksheet.Cells["A1"];

// Adding some value to the "A1" cell
cell.PutValue("Hello Aspose!");

// Obtaining the style of the cell
Style style = cell.GetStyle();

// Setting subscript effect
style.Font.IsSubscript = true;

// Applying the style to the cell
cell.SetStyle(style);

// Saving the Excel file
workbook.Save(dataDir + "out.xlsx");

Einstellen des Hochgestellt-Effekts auf Schriftart

Entwickler können den Hochgestellt-Effekt auf die Schriftart anwenden, indem sie die IsSuperscript-Eigenschaft des Style.Font-Objekts auf true setzen.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET

// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Adding a new worksheet to the Excel object
int i = workbook.Worksheets.Add();

// Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[i];

// Accessing the "A1" cell from the worksheet
Aspose.Cells.Cell cell = worksheet.Cells["A1"];

// Adding some value to the "A1" cell
cell.PutValue("Hello Aspose!");

// Obtaining the style of the cell
Style style = cell.GetStyle();

// Setting superscript effect
style.Font.IsSuperscript = true;

// Applying the style to the cell
cell.SetStyle(style);

// Saving the Excel file
workbook.Save(dataDir + "out.xlsx");

Erweiterte Themen

• Hoch- und Tiefgestellt-Effekte auf Schriftarten anwenden
• Eine Liste der in einer Arbeitsmappe oder einem Arbeitsblatt verwendeten Schriftarten abrufen