Question
1
Replies
240
Views
Posted: October 31, 2017
Last activity: November 9, 2017
Closed
Solved
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.
Moderation Team has archived post,
Close popover
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
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