Interruzioni di riga e a capo automatico del testo

Per incapsulare il testo in una cella

Per avvolgere il testo in una cella, usa il metodo Aspose.Cells.Style.setIsTextWrapped(boolean).

const path = require("path");
const AsposeCells = require("aspose.cells.node");
// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
// Create Workbook Object
const wb = new AsposeCells.Workbook();
// Open first Worksheet in the workbook
const ws = wb.getWorksheets().get(0);
// Get Worksheet Cells Collection
const cell = ws.getCells();
// Increase the width of First Column Width
cell.setColumnWidth(0, 35);
// Increase the height of first row
cell.setRowHeight(0, 36);
// Add Text to the First Cell
cell.checkCell(0, 0).putValue("I am using the latest version of Aspose.Cells to test this functionality");
// Make Cell's Text wrap
const style = cell.checkCell(0, 0).getStyle();
style.setIsTextWrapped(true);
cell.checkCell(0, 0).setStyle(style);
// Save Excel File
wb.save(path.join(dataDir, "WrappingText.out.xlsx"));

Per utilizzare ritorni a capo espliciti

Puoi usare ‘\n’ in JavaScript per inserire interruzioni di riga esplicite in una cella.

const path = require("path");
const AsposeCells = require("aspose.cells.node");
// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
// Create Workbook Object
const wb = new AsposeCells.Workbook();
// Open first Worksheet in the workbook
const ws = wb.getWorksheets().get(0);
// Get Worksheet Cells Collection
const cell = ws.getCells();
// Increase the width of First Column Width
cell.setColumnWidth(0, 35);
// Increase the height of first row
cell.setRowHeight(0, 65);
// Add Text to the First Cell with Explicit Line Breaks
cell.checkCell(0, 0).putValue("I am using\nthe latest version of \nAspose.Cells to \ntest this functionality");
// Make Cell's Text wrap
const style = cell.checkCell(0, 0).getStyle();
style.setIsTextWrapped(true);
cell.checkCell(0, 0).setStyle(style);
// Save Excel File
wb.save(path.join(dataDir, "WrappingText.out.xlsx"));