To generate the EXCEL output; this is a FINAL rule, so you cannot just over-ride it.
The 'Rule-Obj-HTML' in fact generates a HTML output that EXCEL is able to parse : I don't know for sure , but I don't believe this format will
allow you to specify more advanced features such as locking the first row/column in any case.
You *could* do this using the XML 2003 Format (for instance) ; but again you would need to re-write "pzListViewExcelData" in order to do this, and this is a final rule.
You could use the Apache POI library to generate your EXCEL separately (or indeed use the XML 2003 Format) ; but you then need to write additional 'plumbing' code to run the report and export to excel;
rather than being able to use the default OOTB mechanisms to do this.
Just for reference the following EXCEL 2003 XML will create a spreadsheet with a frozen first row.
Am seeing Property called pyFixedHeader when we select "Do not scroll Header" as true under pyUserInteractions Page. Is there any way we can set this value to the excel sheet in "pzListViewExcelData" to freeze the excel first row. Not sure how to use this property & set the value to the excel in this HTML rule. Please advice.
In the HTML rule - pzListViewExcelData, they are mapping the values from the report definition page to the excel format list, ClipboardPage cbpHeaderColumns = cbpMainPage.getProperty(".pyReportDefinition").getPageValue();
In the same pyReportDefinition - Am seeing Property called pyFixedHeader when we select "Do not scroll Header" as true under pyUserInteractions Page