Applica effetti di esponente e pedice sui font

Aspose.Cells fornisce la funzionalità di applicare gli effetti di esponente (testo sopra la linea di base) e pedice (testo sotto la linea di base) al testo.

Lavorare con esponente e pedice

Applica l’effetto pedice impostando il metodo setIsSuperscript dell’oggetto Font su true. Per applicare il pedice, imposta il metodo setIsSubscript dell’oggetto Font su true.

Gli esempi di codice seguenti mostrano come applicare esponente e pedice al testo.

Codice Node.js per applicare l’effetto apice sul testo

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

Codice Node.js per applicare l’effetto pedice sul testo

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