Needhelp finding WorksheetGetUsedRange under the methods for my excel connector
Hi,
I cant find WorksheetGetUsedRange under the methods for my excel connector, my Pega version is - 8.0.1089.0. Is there someway I can get this my system, or any other way that I can get the range of the excel sheet.
Posted: 1 year ago
Posted: 1 year ago
WorksheetGetUsedRange is available starting from version 8.0.2010.
For earlier versions you can other options suggested here: https://community1.pega.com/community/pega-support/question/number-rows-excel-file
Use Micorosoft Excel Connector. Give the maximum limit of forloop say 10000 or maximum number. With the help of StringUtils concat and isnullorempty methods you can get the last used row.