How to import a worksheet with jsl but it can have missing or trailing spaces in its name?
Mar 8, 2020 1:13 PM(442 views)
I have a problem to import specific worksheets from multiple excel files but they have (or have not) spaces on different locations in their names. E.g. the name of the worksheet can be " sheet1", "sheet 1", or "sheet1 ". I have not found some kind of search string comparable to the usage of a * like: "*sheet*1*". Any suggestions?