处理字体设置

可以通过更改字体设置来控制文本的外观。这些字体设置可能包括字体的名称、样式、大小、颜色等效果，如下图所示：

Microsoft Excel 中的字体设置

与Microsoft Excel一样，Aspose.Cells也支持配置单元格的字体设置。

配置字体设置

Aspose.Cells提供了一个类，工作簿表示 Microsoft Excel 文件。这工作簿类包含一个工作表集合允许访问 Excel 文件中的每个工作表。工作表由工作表班级。这工作表类提供了Cells收藏。中的每一项Cells集合代表一个对象Cell班级。

Aspose.Cells 提供了Cell班级'[设置样式](https://reference.aspose.com/cells/java/com.aspose.cells/cell#setStyle(com.aspose.cells.Style) 方法，用于设置单元格的格式。此外，对象的风格类提供用于配置字体设置的属性。

本文介绍如何：

• 将特定字体应用于文本。
• 将文本设置为粗体.
• 设置字体大小.
• 设置字体颜色.
• 下划线文字.
• 划线文字.
• 将文本设置为下标.
• 将文本设置为上标.

设置字体名称

使用特定字体将特定字体应用于单元格中的文本字体对象的设定名称财产。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getSharedDataDir(SettingFontName.class) + "data/";
// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Accessing the added worksheet in the Excel file
int sheetIndex = workbook.getWorksheets().add();
Worksheet worksheet = workbook.getWorksheets().get(sheetIndex);
Cells cells = worksheet.getCells();

// Adding some value to the "A1" cell
Cell cell = cells.get("A1");
cell.setValue("Hello Aspose!");

// Setting the font name to "Times New Roman"
Style style = cell.getStyle();
Font font = style.getFont();
font.setName("Times New Roman");

cell.setStyle(style);

// Saving the modified Excel file in default format
workbook.save(dataDir + "SettingFontName_out.xls");

将字体样式设置为粗体

通过设置将文本设置为粗体字体对象的设置粗体财产给真的.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the output directory.
String outputDir = Utils.Get_OutputDirectory();

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

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

// Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.getWorksheets().get(i);

// Accessing the "A1" cell from the worksheet
Cell cell = worksheet.getCells().get("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.getFont().setBold(true);
// Applying the style to the cell
cell.setStyle(style);

// Saving the Excel file
workbook.save(outputDir + "book1.out.xlsx", SaveFormat.XLSX);

设置字体大小

使用设置字体大小字体对象的设定大小财产。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getSharedDataDir(SetFontSize.class) + "data/";
// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Accessing the added worksheet in the Excel file
int sheetIndex = workbook.getWorksheets().add();
Worksheet worksheet = workbook.getWorksheets().get(sheetIndex);
Cells cells = worksheet.getCells();

// Adding some value to the "A1" cell
Cell cell = cells.get("A1");
cell.setValue("Hello Aspose!");

// Setting the font weight to bold
Style style = cell.getStyle();
Font font = style.getFont();
font.setSize(14);
cell.setStyle(style);

cell.setStyle(style);

// Saving the modified Excel file in default format
workbook.save(dataDir + "SetFontSize_out.xls");

设置字体下划线类型

文本下划线字体对象的设置下划线财产。 Aspose.Cells 提供各种预定义的字体下划线类型字体下划线类型枚举。

字体下划线类型	描述
没有任何	无下划线
单身的	单下划线
双倍的	双下划线
会计	单个会计下划线
DOUBLE_ACCOUNTING	双会计下划线
短跑	虚线下划线
短跑_点_DOT_HEAVY	粗点划线
短跑_点_重的	粗点划线
虚线_重	粗虚线下划线
破折号_长	长虚线下划线
短跑_长_重的	粗长虚线下划线
点划线	点划线
点_点_短跑	点划线下划线
点缀	虚线下划线
点重	粗点下划线
重的	粗下划线
海浪	波浪下划线
WAVY_DOUBLE	双波下划线
波浪重	大浪下划线
字	仅给非空格字符加下划线
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java // The path to the documents directory. String dataDir = Utils.getSharedDataDir(SettingFontUnderlineType.class) + "data/"; // Instantiating a Workbook object Workbook workbook = new Workbook(); // Accessing the added worksheet in the Excel file int sheetIndex = workbook.getWorksheets().add(); Worksheet worksheet = workbook.getWorksheets().get(sheetIndex); Cells cells = worksheet.getCells(); // Adding some value to the "A1" cell Cell cell = cells.get("A1"); cell.setValue("Hello Aspose!"); // Setting the font to be underlined Style style = cell.getStyle(); Font font = style.getFont(); font.setUnderline(FontUnderlineType.SINGLE); cell.setStyle(style); cell.setStyle(style); // Saving the modified Excel file in default format workbook.save(dataDir + "SFUnderlineType_out.xls");

设置字体颜色

设置字体颜色字体对象的设置颜色财产。从中选择任何颜色颜色枚举并将所选颜色分配给字体对象的设置颜色.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getSharedDataDir(SetFontColor.class) + "data/";
// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Accessing the added worksheet in the Excel file
int sheetIndex = workbook.getWorksheets().add();
Worksheet worksheet = workbook.getWorksheets().get(sheetIndex);
Cells cells = worksheet.getCells();

// Adding some value to the "A1" cell
Cell cell = cells.get("A1");
cell.setValue("Hello Aspose!");

// Setting the font color to blue
Style style = cell.getStyle();
Font font = style.getFont();
font.setColor(Color.getBlue());
cell.setStyle(style);

cell.setStyle(style);

// Saving the modified Excel file in default format
workbook.save(dataDir + "SetFontColor_out.xls");

在文本上设置删除线效果

带删除线的文本字体对象的设置删除线财产。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getSharedDataDir(SettingStrikeOutEffect.class) + "data/";
// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Accessing the added worksheet in the Excel file
int sheetIndex = workbook.getWorksheets().add();
Worksheet worksheet = workbook.getWorksheets().get(sheetIndex);
Cells cells = worksheet.getCells();

// Adding some value to the "A1" cell
Cell cell = cells.get("A1");
cell.setValue("Hello Aspose!");

// Setting the strike out effect on the font
Style style = cell.getStyle();
Font font = style.getFont();
font.setStrikeout(true);
cell.setStyle(style);

设置下标

使用字体对象的设置下标财产。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getSharedDataDir(SetSubscript.class) + "data/";
// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Accessing the added worksheet in the Excel file
int sheetIndex = workbook.getWorksheets().add();
Worksheet worksheet = workbook.getWorksheets().get(sheetIndex);
Cells cells = worksheet.getCells();

// Adding some value to the "A1" cell
Cell cell = cells.get("A1");
cell.setValue("Hello Aspose!");

// Setting subscript effect
Style style = cell.getStyle();
Font font = style.getFont();
font.setSubscript(true);
cell.setStyle(style);

设置上标

将上标应用于文本字体对象的设置上标财产。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getSharedDataDir(SetSubscript.class) + "data/";
// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Accessing the added worksheet in the Excel file
int sheetIndex = workbook.getWorksheets().add();
Worksheet worksheet = workbook.getWorksheets().get(sheetIndex);
Cells cells = worksheet.getCells();

// Adding some value to the "A1" cell
Cell cell = cells.get("A1");
cell.setValue("Hello Aspose!");
		
// Setting superscript effect
Style style = cell.getStyle();
Font font = style.getFont();
font.setSuperscript(true);
cell.setStyle(style);

推进主题

• 对字体应用上标和下标效果
• 获取电子表格或工作簿中使用的字体列表