Features / Print Settings / Configure Print Area
Configure Print Area

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

DsExcel 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");