How to increase size of a Cell

Aspose.Cells Product Family
1

Hi,

How to increase size of a Cell .

Sunil

2

Hi Sunil,

Thank you for considering Aspose.

Well, I am not very clear about your requirement. If you want to increase the size of one particular cell, in that case, you cannot increase the size of one specific cell in MS Excel. To increase the size, you have to increase the row height and/or column width (as per requirement). You can use sheet.Cells.SetRowHeight(RowIndex,Size) and sheet.Cells.SetColumnWidth(ColumnIndex,Size) methods of Aspose.Cells API to resize the rows and columns.

But If you want to increase the size of the Cell to fit the data into the cell, then you can use worksheet.AutoFitRows() and worksheet.AutoFitColumns() method. This will automatically adjust the size of your Rows and Columns as per the data in them.

for more details please see the following links,
Adjusting row height and column width
Autofit rows and columns

Thank you & Best Regards,