2 Replies Latest reply: Aug 15, 2014 11:55 AM by ANGIE DM RSS

    How to load EXCEL worksheets and retrieve tab names

      I have an EXCEL spreadsheet which contains 3 tabs with different names as attached. Those tab names could be changed though in the future. When I load this file, I like to load all of them no matter what the tab names are. But I do need to retrieve the tab names as part of the load script.

       

      The final QV data file I like to see is like following with Tab Name as part of it.

       

       

      Please advise. Thank you in advance.