3 Replies Latest reply: Feb 2, 2018 4:49 AM by Shane Spencer 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.