Zeilenumbrüche und Textumbruch

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

Text in Cell umbrechen

Um Text in einer Zelle umzubrechen, verwenden Sie dieAspose.Cells.Style.IsTextWrappedEigentum.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
// Create Workbook Object
Workbook wb = new Workbook();

// Open first Worksheet in the workbook
Worksheet ws = wb.Worksheets[0];

// Get Worksheet Cells Collection
Aspose.Cells.Cells cell = ws.Cells;

// 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 Firts Cell
cell[0, 0].PutValue("I am using the latest version of Aspose.Cells to test this functionality");

// Make Cell's Text wrap
Style style = cell[0, 0].GetStyle();
style.IsTextWrapped = true;
cell[0, 0].SetStyle(style);

// Save Excel File
wb.Save(dataDir+ "WrappingText.out.xlsx");

So verwenden Sie explizite Zeilenumbrüche

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

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
// Create Workbook Object
Workbook wb = new Workbook();

// Open first Worksheet in the workbook
Worksheet ws = wb.Worksheets[0];

// Get Worksheet Cells Collection
Aspose.Cells.Cells cell = ws.Cells;

// 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[0, 0].PutValue("I am using\nthe latest version of \nAspose.Cells to \ntest this functionality");

// Make Cell's Text wrap
Style style = cell[0, 0].GetStyle();
style.IsTextWrapped = true;
cell[0, 0].SetStyle(style);

// Save Excel File
wb.Save(dataDir+ "WrappingText.out.xlsx");