Hello,
Using JExcel to produce Excel reports. We have 2 options to preset the Printer Properties such as Page Orientation.
So if i select option as Landscape then the sheet should preset its Printer properties and Page Orientation to Landscape and so on.
I am using this :
WorsheetObject.setPageSetup(CSharpJExcel.Jxl.Format.PageOrientation.LANDSCAPE)
It works fine for many of the reports but couple of those it does not work. Whatever option i set and create Excel its Default Printer property Page Orienation always sets to Portrait and manually user has to change it.
Any suggestions please.
Thanks.
Abhilash