How to read non-blank values from a sheet in Excel file upon button click
I'm new in Pega and find it hard to create a simple automation that will read the non-blank values in Excel. Saw this post, but guess my design is different:
My UI is there is a Browse button for the user to locate the excel file. After that, automation will start upon clicking Proceed button which should then read all the non-blank values (rows and columns) from the Excel File specified. The excel file contains multiple sheets so it would be better to define the sheet name somewhere in the script. For testing purposes, can display the row/column value in a message box.
I'm stuck and would appreciate if someone can provide help. Sample code would be highly appreciated.
Thanks in advance