At the request of several folks, I’ve added two new features to the ExcelDocumentType and ExcelDocTypeUtils PL/SQL package:
1. The ability to specify whether or not a worksheet’s orientation is Portrait or Landscape.
2. The ability to specify whether or not column headers for a worksheet will repeat at the top of each printed page.
See the EmployeeReport demo files in the code bundle (or download the ExcelDocTypeUtils Developer Guide) for specifics.
(Download the code here:Code)