Adjusting Row Height and Column Width
Working with Rows
Adjusting Row Height
Aspose.Cells provides a class, Workbook, that represents a Microsoft Excel file. The Workbook class contains a WorksheetCollection that allows access to each worksheet in the Excel file. A worksheet is represented by the Worksheet class. The Worksheet class provides a Cells collection that represents all cells in the worksheet.
The Cells collection provides several methods to manage rows or columns in a worksheet. Some of these are discussed below in more detail.
Setting the Row Height
It is possible to set the height of a single row by calling the Cells collection’s setRowHeight method. The setRowHeight method takes the following parameters:
- Row index, the index of the row that you’re changing the height of.
- Row height, the row height to apply on the row.
Setting the Height of All Rows
To set the same row height for all rows in a worksheet, use the Cells collection’s setStandardHeight method.
Working with Columns
Setting the Width of a Column
Set the width of a column by calling the Cells collection’s setColumnWidth method. The setColumnWidth method takes the following parameters:
- Column index, the index of the column that you’re changing the width of.
- Column width, the desired column width.
Setting the Width of All Columns
To set the same column width for all columns in a worksheet, use the Cells collection’s setStandardWidth method.