Print Titles and Area

import com.gembox.spreadsheet.*;

class Program {

    public static void main(String[] args) throws java.io.IOException {
        // If using the Professional version, put your serial key below.
        SpreadsheetInfo.setLicense("FREE-LIMITED-KEY");

        ExcelFile workbook = new ExcelFile();

        // Always print 1st row.
        ExcelWorksheet worksheet1 = workbook.addWorksheet("Sheet1");
        worksheet1.getNamedRanges().setPrintTitles(worksheet1.getRow(0), 1);

        // Set print area (from A1 to I120):
        worksheet1.getNamedRanges().setPrintArea(worksheet1.getCells().getSubrange("A1", "I120"));

        // Always print columns from A to F.
        ExcelWorksheet worksheet2 = workbook.addWorksheet("Sheet2");
        worksheet2.getNamedRanges().setPrintTitles(worksheet2.getColumn(0), 6);

        // Always print columns from A to F and first row.
        ExcelWorksheet worksheet3 = workbook.addWorksheet("Sheet3");
        worksheet3.getNamedRanges().setPrintTitles(worksheet3.getRow(0), 1, worksheet3.getColumn(0), 6);

        // Fill Sheet1 with some data
        for (int i = 0; i < 9; i++)
            worksheet1.getCell(0, i).setValue("Column " + ExcelColumnCollection.columnIndexToName(i));

        for (int i = 1; i < 120; i++)
            for (int j = 0; j < 9; j++)
                worksheet1.getCell(i, j).setValue(i + j);

        workbook.save("Print Titles and Area.%OutputFileType%");
    }
}