Zeilenumbrüche und Textumbruch

Um sicherzustellen, dass der Text in einer Zelle gelesen werden kann, können explizite Zeilenumbrüche und Textumbrüche angewendet werden. Textumbrüche verwandeln eine Zeile in mehrere in einer Zelle, wobei explizite Zeilenumbrüche genau dort eingefügt werden, wo Sie sie haben möchten.

Text in einer Zelle umbrechen

Um Text in einer Zelle umzubrechen, verwenden Sie die Eigenschaft Style.is_text_wrapped.

from aspose.cells import Workbook

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
#  Create Workbook Object
wb = Workbook()
#  Open first Worksheet in the workbook
ws = wb.worksheets[0]
#  Get Worksheet Cells Collection
cell = ws.cells
#  Increase the width of First Column Width
cell.set_column_width(0, 35)
#  Increase the height of first row
cell.set_row_height(0, 36)
#  Add Text to the Firts Cell
cell.get(0, 0).put_value("I am using the latest version of Aspose.Cells to test this functionality")
#  Make Cell's Text wrap
style = cell.get(0, 0).get_style()
style.is_text_wrapped = True
cell.get(0, 0).set_style(style)
#  Save Excel File
wb.save(dataDir + "WrappingText.out.xlsx")

Explizite Zeilenumbrüche verwenden

Sie können in C# „\n“ und in VB.NET „vbLf“ verwenden, um explizite Zeilenumbrüche in einer Zelle einzufügen.

from aspose.cells import Workbook

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
#  Create Workbook Object
wb = Workbook()
#  Open first Worksheet in the workbook
ws = wb.worksheets[0]
#  Get Worksheet Cells Collection
cell = ws.cells
#  Increase the width of First Column Width
cell.set_column_width(0, 35)
#  Increase the height of first row
cell.set_row_height(0, 65)
#  Add Text to the Firts Cell with Explicit Line Breaks
cell.get(0, 0).put_value("I am using\nthe latest version of \nAspose.Cells to \ntest this functionality")
#  Make Cell's Text wrap
style = cell.get(0, 0).get_style()
style.is_text_wrapped = True
cell.get(0, 0).set_style(style)
#  Save Excel File
wb.save(dataDir + "WrappingText.out.xlsx")