Export Excel horizontally
In our application, we use MSOGenerateExcelFile/pxGenerateExcelFile to export Excel from DataPage List.
any data record will take one row. (top - down direction)
now we have new requirement :there are several data blocks in the excel sheet, want some of the data blocks is hoped to show data from left to right(each property takes 1 row, and each data record takes 1 column.
i tried to use a template excel with 1 row for each property. but the exported excel file shows below in one column.
values of propertyA, values of propertyB ...
Is there any method that can export data horizontally(Left - right direction)?
Pegasystems Inc.
IN
Updated: 13 May 2024 4:57 EDT
Pegasystems Inc.
JP
thank you for checking my question.
please refer my attachment.
on the Top-Down sheet, I can get data record under the header, like your sample.
what I want to know is if we can make to to get excel file with data as expected pattern in the Left-Right sheet.
(I confirmed above by using pxGenerateExcelFile)
best regards
Pegasystems Inc.
JP
add top-down image
Pegasystems Inc.
IN
@chend1 - Can you try spreading the property horizontally in the template and verify how its generating.
Pegasystems Inc.
JP
@Priyanka BogaThank you for your advice.
I tried but still the data dose not spread from left to right.
@chend1 - If the template includes multiple rows then need to use MSOGenerateExcelFile and pxGenerateExcelFile only supports column header and column value ( 2 rows) . MSOGenerateExcelFile is deprecated activity. As per your usecase need to go with MSOGenerateExcelFile as it has multiple rows. Make sure to give the data which need to be spread horizontally with column name and column property property reference.