AutoFit Rows for Merged Cells with Golang via C++
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 doesn’t set auto‑fit operation on merged cells natively. Sometimes the feature becomes vital for a user who really needs to implement auto‑fit rows on merged cells too.
How to use AutoFitMergedCellsType for autofitting rows
Aspose.Cells supports this feature through the AutoFitterOptions.AutoFitMergedCellsType API. Using this API, it is possible to auto‑fit rows in a worksheet, including merged cells. Here is a list of all possible types of auto‑fitting merged cells:
- None
- FirstLine
- LastLine
- EachLine
Autofit Rows for Merged Cells
Please see the following code; it creates a workbook object and adds multiple worksheets. Use different methods for autofit operations in each worksheet. The screenshot shows the results after the execution of the sample code.
C++ Sample Code