换行和文字换行

为确保可以读取单元格中的文本，可以应用明确的换行符和文本换行。文本换行将单元格中的一行变成多行，明确的换行符正好放在你想要的地方。

在 Cell 中换行

要在单元格中换行文本，请使用Aspose.Cells.Style.setTextWrapped财产。

以下示例代码显示了如何在单元格中使用文本换行和显式换行符。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getSharedDataDir(WrapTextinCell.class) + "TechnicalArticles/";

// Create Workbook Object
Workbook wb = new Workbook();

// Open first Worksheet in the workbook
Worksheet ws = wb.getWorksheets().get(0);

// Get Worksheet Cells Collection
Cells 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
cell.get(0, 0).setValue("I am using the latest version of Aspose.Cells to test this functionality");

// Get Cell's Style
Style style = cell.get(0, 0).getStyle();

// Set Text Wrap property to true
style.setTextWrapped(true);

// Set Cell's Style
cell.get(0, 0).setStyle(style);

// Save Excel File
wb.save(dataDir + "WrapTextinCell_out.xls");

使用显式换行符

您可以在 Java 中使用“\n”在单元格中插入显式换行符。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getDataDir(UseExplicitLineBreaks.class);
// Create Workbook Object
Workbook wb = new Workbook();

// Open first Worksheet in the workbook
Worksheet ws = wb.getWorksheets().get(0);

// Get Worksheet Cells Collection
Cells 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 Firts Cell with Explicit Line Breaks
cell.get(0, 0).setValue("I am using \nthe latest version of \nAspose.Cells \nto test this functionality");

// Get Cell's Style
Style style = cell.get(0, 0).getStyle();

// Set Text Wrap property to true
style.setTextWrapped(true);

// Set Cell's Style
cell.get(0, 0).setStyle(style);

// Save Excel File
wb.save(dataDir + "WrappingText.xls");