Adjusting Row Height and Column Width

When working with spreadsheets and adding data to rows or columns, you might need to change the height of rows or width of columns. Sometimes, applying formatting to rows or columns means that the current height or width needs to change to show the data. Normally, users adjust row heights and column widths in a WYSIWYG environment using Microsoft Excel. But, with Aspose.Cells developers can perform these operations at runtime. Indexes of rows and columns will start from 0.

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.