Schriftart Einstellungen

Das Aussehen eines Textes kann durch Ändern der Schriftarteinstellungen gesteuert werden. Die Schriftarteinstellungen können Name, Stil, Größe, Farbe und andere Effekte der Schrift umfassen. Genau wie Microsoft Excel unterstützt Aspose.Cells für Python via .NET auch die Konfiguration der Schriftarteinstellungen der Zellen.

Konfigurieren von Schriftarteinstellungen

Aspose.Cells für Python via .NET bietet eine Klasse, Workbook, die eine Microsoft Excel-Datei repräsentiert. Die Workbook-Klasse enthält eine worksheets-Sammlung, die den Zugriff auf jedes Arbeitsblatt einer Excel-Datei ermöglicht. Ein Arbeitsblatt wird durch die Worksheet-Klasse dargestellt. Die Worksheet-Klasse bietet eine cells-Sammlung. Jedes Element in der cells-Sammlung repräsentiert ein Objekt der Cell-Klasse.

Aspose.Cells bietet die Cell-Klasse' get_style und set_style-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 jede Schriftart auf Text innerhalb einer Zelle anwenden, indem sie die Style.font-Eigenschaft des name-Objekts verwenden.

from aspose.cells import SaveFormat, Workbook
from os import os, path

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
#  Create directory if it is not already present.
IsExists = path.isdir(dataDir)
if notIsExists:
    os.makedirs(dataDir)
#  Instantiating a Workbook object
workbook = Workbook()
#  Adding a new worksheet to the Excel object
i = workbook.worksheets.add()
#  Obtaining the reference of the newly added worksheet by passing its sheet index
worksheet = workbook.worksheets[i]
#  Accessing the "A1" cell from the worksheet
cell = worksheet.cells.get("A1")
#  Adding some value to the "A1" cell
cell.put_value("Hello Aspose!")
#  Obtaining the style of the cell
style = cell.get_style()
#  Setting the font name to "Times New Roman"
style.font.name = "Times New Roman"
#  Applying the style to the cell
cell.set_style(style)
#  Saving the Excel file
workbook.save(dataDir + "book1.out.xls", SaveFormat.EXCEL_97_TO_2003)

Schriftschnitt auf Fett setzen

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

from aspose.cells import Workbook

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  Instantiating a Workbook object
workbook = Workbook()
#  Adding a new worksheet to the Excel object
i = workbook.worksheets.add()
#  Obtaining the reference of the newly added worksheet by passing its sheet index
worksheet = workbook.worksheets[i]
#  Accessing the "A1" cell from the worksheet
cell = worksheet.cells.get("A1")
#  Adding some value to the "A1" cell
cell.put_value("Hello Aspose!")
#  Obtaining the style of the cell
style = cell.get_style()
#  Setting the font weight to bold
style.font.is_bold = True
#  Applying the style to the cell
cell.set_style(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.

from aspose.cells import Workbook

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  Instantiating a Workbook object
workbook = Workbook()
#  Adding a new worksheet to the Excel object
i = workbook.worksheets.add()
#  Obtaining the reference of the newly added worksheet by passing its sheet index
worksheet = workbook.worksheets[i]
#  Accessing the "A1" cell from the worksheet
cell = worksheet.cells.get("A1")
#  Adding some value to the "A1" cell
cell.put_value("Hello Aspose!")
#  Obtaining the style of the cell
style = cell.get_style()
#  Setting the font size to 14
style.font.size = 14
#  Applying the style to the cell
cell.set_style(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.

from aspose.cells import Workbook
from aspose.pydrawing import Color

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  Instantiating a Workbook object
workbook = Workbook()
#  Adding a new worksheet to the Excel object
i = workbook.worksheets.add()
#  Obtaining the reference of the newly added worksheet by passing its sheet index
worksheet = workbook.worksheets[i]
#  Accessing the "A1" cell from the worksheet
cell = worksheet.cells.get("A1")
#  Adding some value to the "A1" cell
cell.put_value("Hello Aspose!")
#  Obtaining the style of the cell
style = cell.get_style()
#  Setting the font color to blue
style.font.color = Color.blue
#  Applying the style to the cell
cell.set_style(style)
#  Saving the Excel file
workbook.save("out.xlsx")

Schriftart-Unterstrich-Typ festlegen

Verwenden Sie die underline-Eigenschaft des Style.font-Objekts, um Text zu unterstreichen. Aspose.Cells für Python via .NET bietet verschiedene vordefinierte Unterstreichungstypen in der FontUnderlineType-Enumeration.

Schriftart-Unterstreichungstypen	Beschreibung
BUCHHALTUNG	Einzelne Buchhaltung-Unterstreichung
DOPPELT	Doppelte Unterstreichung
DOPPELT_BUCHHALTUNG	Doppelte buchhalterische Unterstreichung
KEINE	Keine Unterstreichung
EINZEL	Eine einzelne Unterstreichung

from aspose.cells import FontUnderlineType, Workbook
from os import os, path

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
#  Create directory if it is not already present.
IsExists = path.isdir(dataDir)
if notIsExists:
    os.makedirs(dataDir)
#  Instantiating a Workbook object
workbook = Workbook()
#  Adding a new worksheet to the Excel object
i = workbook.worksheets.add()
#  Obtaining the reference of the newly added worksheet by passing its sheet index
worksheet = workbook.worksheets[i]
#  Accessing the "A1" cell from the worksheet
cell = worksheet.cells.get("A1")
#  Adding some value to the "A1" cell
cell.put_value("Hello Aspose!")
#  Obtaining the style of the cell
style = cell.get_style()
#  Setting the font to be underlined
style.font.underline = FontUnderlineType.SINGLE
#  Applying the style to the cell
cell.set_style(style)
#  Saving the Excel file
workbook.save(dataDir + "out.xlsx")

Einstellung des Durchgestrichen-Effekts

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

from aspose.cells import Workbook

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  Instantiating a Workbook object
workbook = Workbook()
#  Adding a new worksheet to the Excel object
i = workbook.worksheets.add()
#  Obtaining the reference of the newly added worksheet by passing its sheet index
worksheet = workbook.worksheets[i]
#  Accessing the "A1" cell from the worksheet
cell = worksheet.cells.get("A1")
#  Adding some value to the "A1" cell
cell.put_value("Hello Aspose!")
#  Obtaining the style of the cell
style = cell.get_style()
#  Setting the strike out effect on the font
style.font.is_strikeout = True
#  Applying the style to the cell
cell.set_style(style)
#  Saving the Excel file
workbook.save(dataDir + "out.xlsx")

Einstellen des Tiefgestellt-Effekts

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

from aspose.cells import Workbook

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  Instantiating a Workbook object
workbook = Workbook()
#  Adding a new worksheet to the Excel object
i = workbook.worksheets.add()
#  Obtaining the reference of the newly added worksheet by passing its sheet index
worksheet = workbook.worksheets[i]
#  Accessing the "A1" cell from the worksheet
cell = worksheet.cells.get("A1")
#  Adding some value to the "A1" cell
cell.put_value("Hello Aspose!")
#  Obtaining the style of the cell
style = cell.get_style()
#  Setting subscript effect
style.font.is_subscript = True
#  Applying the style to the cell
cell.set_style(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 is_superscript-Eigenschaft des Style.font-Objekts auf true setzen.

from aspose.cells import Workbook

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  Instantiating a Workbook object
workbook = Workbook()
#  Adding a new worksheet to the Excel object
i = workbook.worksheets.add()
#  Obtaining the reference of the newly added worksheet by passing its sheet index
worksheet = workbook.worksheets[i]
#  Accessing the "A1" cell from the worksheet
cell = worksheet.cells.get("A1")
#  Adding some value to the "A1" cell
cell.put_value("Hello Aspose!")
#  Obtaining the style of the cell
style = cell.get_style()
#  Setting superscript effect
style.font.is_superscript = True
#  Applying the style to the cell
cell.set_style(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