Documents for Excel, Java Edition Documentation
Manage File Operations / Export to a PDF File / Adjust Column Width and Row Height
In This Topic
    Adjust Column Width and Row Height
    In This Topic

    GcExcel provides BestFitColumns and BestFitRows properties in the IPageSetup interface to properly display long or large-size font texts in cells while printing PDF documents. These properties support SSJSON I/O and are consistent with SpreadJS. The BestFitColumns property when set to True, resizes the column width to fit the text with the longest width for printing. Similarly, the BestFitRows property when set to True, resizes the row height to fit the text with the tallest height for printing.

    Note: GcExcel preserves useMax property during JSON I/O. In case a file contains large amount of data, these properties may not work as expected.

    Using Code

    Refer to the following example code to adjust column width or row height.

    Java
    Copy Code
    // Set bestFitColumns/bestFitRows as true
    worksheet.getPageSetup().setBestFitColumns(true);
    worksheet.getPageSetup().setBestFitRows(true);