行尾和文本换行

为了确保单元格中的文本可以被读取，可以应用明确的行尾和文本换行。文本换行将单元格中的一行变成了多行，而明确的行尾则将文本换行放在您想要的确切位置。

将单元格中的文本自动换行

要在单元格中换行，使用 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"));

使用显式换行符

你可以在 JavaScript 中使用 ‘\n’ 在单元格中插入显式换行符。

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