3 Replies Latest reply: Nov 27, 2014 1:02 PM by Shantnu Patel RSS

    Loading the first tab from an XLSX

    Stefan Truniger

      Hi all,

       

      I get an XLSX File with a known structure per tab, but I don't know how the tabs are called.

      I have to make sure I always load the first tab.

       

      This works nicely with XLS files using 'table is @1' but this is not possible with XSLX.

       

      I tried reading the tabs via ODBC (according to How to load first tab of xls without using the tabname) but don't see a way of identifying the first tab.

       

      Any idea, hint or help would be appreciated.

       

      Thanks

      Stefan