行尾和文本换行
Contents
[
Hide
]
为了确保单元格中的文本可以被读取,可以应用明确的行尾和文本换行。文本换行将单元格中的一行变成了多行,而明确的行尾则将文本换行放在您想要的确切位置。
将单元格中的文本自动换行
要将单元格中的文本自动换行,请使用 Aspose.Cells.Style.setTextWrapped 属性。
以下示例代码显示了如何在单元格中使用文本换行和显式换行。
This file contains 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
// 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’来在单元格中插入显式换行。
This file contains 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
// 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"); |