Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.
AutoFit Rows for Merged Cells
Contents
[
Hide
]
Microsoft Excel provides a feature that allows you to auto‑size the height of a cell according to its content. The feature is called auto‑fit rows. Microsoft Excel does not support auto‑fit operation on merged cells natively. Sometimes this feature becomes vital for a user who needs to implement auto‑fit rows on merged cells as well.
How to use AutoFitMergedCellsType for autofitting rows
Aspose.Cells for Python via .NET supports this feature through the AutoFitterOptions.AutoFitMergedCellsType API. Using this API, it is possible to auto‑fit rows in a worksheet that include merged cells. Here is a list of all possible types of auto‑fitting merged cells:
- NONE
- FIRST_LINE
- LAST_LINE
- EACH_LINE
Autofit Rows for Merged Cells
Please see the following code; it creates a workbook object and adds multiple worksheets. It uses different methods for autofit operations in each worksheet. The screenshot shows the results after executing the sample code.
Python Sample Code