フォントに上付きおよび下付きの効果を適用する

上付きおよび下付きの操作

上付き効果を適用するには、FontオブジェクトのsetSuperscriptプロパティを使用します。下付きを適用するには、FontオブジェクトのsetSubscriptメソッドを使用します。

以下のコード例は、テキストに上付き効果と下付き効果を適用する方法を示しています。

上付きを適用

// 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.getDataDir(ApplyingSuperscript.class);
// Instantiating a Workbook object
Workbook workbook = new Workbook();
// Accessing the added worksheet in the Excel file
Worksheet worksheet = workbook.getWorksheets().get(0);
Cells cells = worksheet.getCells();
// Adding some value to the "A1" cell
Cell cell = cells.get("A1");
cell.setValue("Hello");
// Setting the font name to "Times New Roman"
Style style = cell.getStyle();
Font font = style.getFont();
font.setSuperscript(true);
cell.setStyle(style);
// Saving the modified Excel file in default format
workbook.save(dataDir + "Superscript.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.getDataDir(ApplyingSubscript.class);
// Instantiating a Workbook object
Workbook workbook = new Workbook();
// Accessing the added worksheet in the Excel file
Worksheet worksheet = workbook.getWorksheets().get(0);
Cells cells = worksheet.getCells();
// Adding some value to the "A1" cell
Cell cell = cells.get("A1");
cell.setValue("Hello");
// Setting the font name to "Times New Roman"
Style style = cell.getStyle();
Font font = style.getFont();
font.setSubscript(true);
cell.setStyle(style);
// Saving the modified Excel file in default format
workbook.save(dataDir + "Subscript.xls");