Print Titles and Area
GemBox.Spreadsheet for Java has been retired
The following example shows how you can set worksheet print titles and print 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%");
}
}
See also
Next steps
Published: December 13, 2018 | Modified: December 19, 2022 | Author: Marek Turis