How to get all availabe excel column names in to a PageList ?
I need to get any number of columns available in an excel sheet, to get to a PageList.
.pxResults(1).CoulumnName = "ColumnA"
.pxResults(2).ColumnName = "ColumnB"
It would be great if someone knows to retriew this format using customized "MSOParseExcelFile" or a Single Jave Step to Embed in to this activity.
Accepted Solution
Pegasystems Inc.
US
Hi Anuradha,
If you are fine with the simple java step then you can try to use the Apache POI api in order to read the column names of the excel file by importing its required jars. You can look into the Apache POI documentation in order to write the code to your functionality or you can may be google it for the sample code. For example, i found this discussion where you will get all the column names into the Map with the column name and its column index.
You can then use this Map to construct your page list properties based on column index. Hope this might help you to achieve your requirement.
Regards
Mahesh