行尾和文本换行

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

要将单元格中的文本自动换行,请使用 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");