Showing results for 
Search instead for 
Did you mean: 

RGT: Excel Get Worksheet

I am using the excel get in the report generation toolkit to set my current worksheet.  With the vi, you can either use the workshee index or the worksheet name to set the current worksheet.  Sometimes, using worksheet name doesn't work.  Why is that?  I am certain that I type in the correct worksheet name. Has anyone expereienced that problem before?


Kudos and Accepted as Solution are welcome!
0 Kudos
Message 1 of 2

I've only seen this with incorrect name, most of the time a invisible character like a space at the end. I now use the trim whitespace function to make sure there is no such character. You can also check "limit to single line" when you right-click on the input name string control, you can then avois to have a hidden line.



0 Kudos
Message 2 of 2