Question
TCS
IN
Last activity: 2 Jul 2020 1:00 EDT
Export multilevel Pagelist data to excel
Hi All
I want to extract and download multi level list data into an excel. Any one have came across such scenario, please share details.
(Say- I have a PageList A and another Pagelist B is embedded to A. Now I want to download the info into excel which will have both A and B data.)
MSOGenerateExcelFIle will not work in this scenario. And I have tried with ExportToExcel. But it downloads all data from the screen instead of only Pagelist data.
Updated: 2 Jul 2020 0:59 EDT
Maantic Inc
US
hope it is your page structure?
PageListA
-NameA
-PageListB
-NameB
are you tried below mapping in excel binary?
{PageListA.NameA input} - get PageListA value
{PageListA.PageListB.NameB input} - get PageListB value
Mercedes-Benz Group AG
GB
Hi,
This requirement can be achieved by create a excel file which will have two page list properties embedded in that.
Next creating a binary file rule of file type xls or xlsx(this should be based on the extension of your created excel file) and upload the created excel file into this binary file rule.
For generating excel file you can use MSOGenerateExcelFIle and pass the binary file rule pxinsname into TemplateRFB parameter.