Paramètres de police

L’apparence d’un texte peut être contrôlée en modifiant les paramètres de police. Les paramètres de police peuvent inclure le nom, le style, la taille, la couleur et d’autres effets des polices. Tout comme Microsoft Excel, Aspose.Cells prend également en charge la configuration des paramètres de police des cellules.

Configuration des paramètres de police

Aspose.Cells fournit une classe,Cahier qui représente un fichier Excel Microsoft. LeCahier classe contient unFeuilles de travail collection qui permet d’accéder à chaque feuille de calcul dans un fichier Excel. Une feuille de calcul est représentée par leFeuille de travail classe. LeFeuille de travail la classe offre uneCells le recueil. Chaque élément de laCells collection représente un objet de laCellclasse.

Aspose.Cells fournit leCell classe'ObtenirStyle etDéfinirStyle méthodes utilisées pour obtenir et définir le style de formatage d’une cellule. LeStyleLa classe fournit des propriétés pour configurer les paramètres de police.

Définition du nom de la police

Les développeurs peuvent appliquer n’importe quelle police au texte à l’intérieur d’une cellule en utilisant leStyle.Font objetsNomla propriété.

// 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);

Définition du style de police en gras

Les développeurs peuvent mettre le texte en gras en définissant leStyle.Font objetsEstBold propriété àvrai.

// 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");

Définition de la taille de la police

Définissez la taille de la police avec leStyle.FontobjetsTaillela propriété.

// 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");

Définition de la couleur de la police

Utilisez leStyle.Font objetsCouleurpropriété pour définir la couleur de la police. Sélectionnez n’importe quelle couleur dans l’énumération des couleurs (qui fait partie du cadre .NET) et attribuez-la auCouleurla propriété.

// 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");
            

Définition du type de soulignement de la police

Utilisez leStyle.FontobjetsSoulignerpropriété pour souligner le texte. Aspose.Cells offre divers types de soulignement de police prédéfinis dans leFontUnderlineType énumération.

Types de soulignement de police	Description
Comptabilité	Un soulignement comptable unique
Double	Double soulignement
DoubleComptabilité	Double soulignement comptable
Aucun	Pas de soulignement
Seul	Un seul soulignement

// 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");

Réglage de l’effet barré

Appliquez le barré en réglant leStyle.Font objetsEstBarrépropriété àvrai.

// 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");

Définition de l’effet d’indice

Appliquer l’indice en définissant leStyle.FontobjetsEstSubScript propriété àvrai.

// 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");

Définition de l’effet Exposant sur la police

Les développeurs peuvent appliquer l’effet d’exposant sur la police en définissant leEstExposant propriété de laStyle.Font s’opposer àvrai.

// 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");

Sujets avancés

• Appliquer des effets d’exposant et d’indice sur les polices
• Obtenir une liste des polices utilisées dans une feuille de calcul ou un classeur