Setting Column Width or Row Height

This topic discusses setting the column width and row height using the Aspose.Cells.GridDesktop API. Sometimes, worksheet cells contain values that are wider than the original cell. It makes it difficult for users to read the cell content. Some users don’t like to use the right arrow key to view the complete value in a cell. To solve such problems, developers can change the column width. Changing the row height solves similar issues.

Setting Column Width

To set the width of a column using Aspose.Cells.GridDesktop:

1. Access a worksheet.
2. Access the column you want to change the width of.
3. Set the column width.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Adding sample value to sheet cell
GridCell cell = sheet.Cells["a1"];
cell.SetCellValue("Welcome to Aspose!");

// Accessing the first column of the worksheet
Aspose.Cells.GridDesktop.Data.GridColumn column = sheet.Columns[0];

// Setting the width of the column
column.Width = 150;

Setting Row Height

To set the height of a row using Aspose.Cells.GridDesktop, please follow the steps below:

1. Access any desired worksheet.
2. Access the row you want to change the height of.
3. Set the row height.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Adding sample value to sheet cells
GridCell cell = sheet.Cells["b2"];
cell.SetCellValue("1");
cell = sheet.Cells["c2"];
cell.SetCellValue("2");
cell = sheet.Cells["d2"];
cell.SetCellValue("3");
cell = sheet.Cells["e2"];
cell.SetCellValue("4");

// Accessing the first row of the worksheet
Aspose.Cells.GridDesktop.Data.GridRow row = sheet.Rows[1];

// Setting the height of the row
row.Height = 100;