How to export report in excel sheet .
Hi
One of the reports we export to excel, as of now only one page i.e., means pagination.
i put 1 to 10 columns in one page that columns only exported. Go to next page again click export another page columns exported.
I used OOTB activity " MSOGenerateExcelFile " to export to excel from report.
Now requirement is if have 100-page with in a click all 100-page export to excel.
Please help me how it is possible to export.
Thanks In advance
NCS Pte. Ltd
SG
Hi @kirti: Can you please help to understand if the report is used as shortcut / in report browser? If so you will have default export to excel option in actions.
If this is used as a source to a grid in UI and you need to export all data, can you try to use "pzRDExportWrapper"? You can see samples in "pzExportDataOfTestCasesIntoExcel", "pzRunScheduledShortcut".
Thanks.
CI
IN
@ArulDevan For export data to excel i used MSOGenerateExcelFile,it's working fine
But it's only export once a page not all page at a time.
I used export button in action i used Open URL In Window action i called activity.
I need to export all pages at a time
Bits in Glass
IN
@kirti When you have enabled paging, then clipboard will have only that page data. This is to manage the load. So I don't think you can achieve this directly. You will have to fetch the same list of records from the data table to a dpagelist and then you can use pxConvertResultstoCsv which will eventually download the expected file with all the records. But if the number of records are very large, then after implementing this you will need to make this process asynchronous.