Documents for Excel, Java Edition Documentation
Features / Print Settings / Configure Print Area
In This Topic
    Configure Print Area
    In This Topic

    At times, you may want to print only a specific area in a worksheet instead of printing the whole worksheet.

    GcExcel Java supports customized printing by allowing users to select a range of cells in order to configure the desired print area in a worksheet. This can be done by using the setPrintArea method, setPrintTitleRows method and setPrintTitleColumns method of the IPageSetup interface.

     

    Java
    Copy Code
    // Set print area & print titles in the worksheet
    worksheet.getPageSetup().setPrintArea("$D$5:$G$10");
    worksheet.getPageSetup().setPrintTitleRows("$5:$10");
    worksheet.getPageSetup().setPrintTitleColumns("$D:$G");