Interruzioni di riga e a capo automatico del testo
Contents
[
Hide
]
Per garantire che il testo in una cella possa essere letto, possono essere applicati ritorni a capo espliciti e a capo automatico del testo. Il ritorno a capo del testo trasforma una riga in più in una cella, mentre i ritorni a capo espliciti inseriscono spazi esattamente dove si desidera.
Per incapsulare il testo in una cella
Per avvolgere il testo in una cella, usa il metodo Aspose.Cells.Style.setIsTextWrapped(boolean).
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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")); |