Hi All,
I needed some clarifications/suggestions on using the export to excel.
1) When I click on export to excel, a <div> tag also gets exported. I came to know that this is becuse of selecting the "Enable Partail Page Refresh" to Yes. Now, I have pagination in my reports and I also need to export to CSV/Excel. Is there no way where in I can use PPR as well as export the report without the DIV tag?
2) I have a number column to which I have given APEX inbuilt hyperlinks. When I do an export the columns where I have given these links do not get Exported. Any way to overcome this? I cant give links in SQL query as then all number formatting would be lost.
3) In my report display I have colspan = "2" for some alternate rows. In my excel output I obtain these correctly but without colspan. Is it possible to merge the cells in excel output wherever there is colspan="2"? Or am I asking too much?
Any suggestions would be welcome. Please let me know what can be done to solve this.