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

Aspose.Cellsは、テキストに上付き（基線の上）および下付き（基線の下）の効果を適用する機能を提供します。

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

FontオブジェクトのsetIsSuperscriptメソッドをtrueに設定して上付き効果を適用します。下付きの場合は、FontオブジェクトのsetIsSubscriptメソッドをtrueに設定してください。

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

Node.jsコード：上付き文字効果の適用

const path = require("path");
const AsposeCells = require("aspose.cells.node");

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");

// Create directory if it is not already present.
const fs = require("fs");
if (!fs.existsSync(dataDir)) {
    fs.mkdirSync(dataDir);
}

// Instantiating a Workbook object
const workbook = new AsposeCells.Workbook();

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

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

// Accessing the "A1" cell from the worksheet
const cell = worksheet.getCells().get("A1");

// Adding some value to the "A1" cell
cell.putValue("Hello");

// Setting the font Superscript
const style = cell.getStyle();
style.getFont().setIsSuperscript(true);
cell.setStyle(style);

// Saving the Excel file
workbook.save(path.join(dataDir, "Superscript.out.xls"), AsposeCells.SaveFormat.Auto);

Node.jsコード：下付き文字効果の適用

const path = require("path");
const AsposeCells = require("aspose.cells.node");

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");

// Create directory if it is not already present.
const fs = require('fs');
if (!fs.existsSync(dataDir)) {
    fs.mkdirSync(dataDir);
}

// Instantiating a Workbook object
const workbook = new AsposeCells.Workbook();

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

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

// Accessing the "A1" cell from the worksheet
const cell = worksheet.getCells().get("A1");

// Adding some value to the "A1" cell
cell.putValue("Hello");

// Setting the font Subscript
const style = cell.getStyle();
style.getFont().setIsSubscript(true);
cell.setStyle(style);

// Saving the Excel file
workbook.save(path.join(dataDir, "Subscript.out.xls"), AsposeCells.SaveFormat.Auto);