Choose Language Hide Translation Bar
Highlighted
miyagi
Level I

How to import a worksheet with jsl but it can have missing or trailing spaces in its name?

Hi,

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?

 

Cheers, Michael

 

Article Labels

    There are no labels assigned to this post.