topic Re: Retrieving Spreadsheet names in QlikView https://community.qlik.com/t5/QlikView/Retrieving-Spreadsheet-names/m-p/1002294#M966022 <HTML><HEAD></HEAD><BODY><P>Like Gysbert said, only throught ODBC. In older versions you could reference to a sheet with @1 for the first sheet, @2 for the second sheet etc but this isn't working anymore!</P></BODY></HTML> Fri, 09 Oct 2015 19:55:49 GMT gardenierbi 2015-10-09T19:55:49Z Retrieving Spreadsheet names https://community.qlik.com/t5/QlikView/Retrieving-Spreadsheet-names/m-p/1002291#M966019 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>How to get the excel spreadsheet names without ODBC .</P><P></P><P></P><P></P><P>Thanks &amp; Regards,</P><P>Ramu.</P></BODY></HTML> Tue, 06 Oct 2015 05:20:49 GMT https://community.qlik.com/t5/QlikView/Retrieving-Spreadsheet-names/m-p/1002291#M966019 2015-10-06T05:20:49Z Re: Retrieving Spreadsheet names https://community.qlik.com/t5/QlikView/Retrieving-Spreadsheet-names/m-p/1002292#M966020 <HTML><HEAD></HEAD><BODY><P>Read them yourself using your eyeballs. Otherwise you will need an ODBC connection.</P></BODY></HTML> Fri, 09 Oct 2015 17:42:26 GMT https://community.qlik.com/t5/QlikView/Retrieving-Spreadsheet-names/m-p/1002292#M966020 Gysbert_Wassenaar 2015-10-09T17:42:26Z Re: Retrieving Spreadsheet names https://community.qlik.com/t5/QlikView/Retrieving-Spreadsheet-names/m-p/1002293#M966021 <HTML><HEAD></HEAD><BODY><P>not sure what you mean</P><P></P><P>are you reading data from a spreadhseet?&nbsp; If so, when you go through the tables file wizard, it will display the names of the spredsheets in the Excel file.&nbsp; If there are more than 1 sheet that you need to read from, you will need to do a seperate load for each sheet, and change the name</P></BODY></HTML> Fri, 09 Oct 2015 18:17:05 GMT https://community.qlik.com/t5/QlikView/Retrieving-Spreadsheet-names/m-p/1002293#M966021 2015-10-09T18:17:05Z Re: Retrieving Spreadsheet names https://community.qlik.com/t5/QlikView/Retrieving-Spreadsheet-names/m-p/1002294#M966022 <HTML><HEAD></HEAD><BODY><P>Like Gysbert said, only throught ODBC. In older versions you could reference to a sheet with @1 for the first sheet, @2 for the second sheet etc but this isn't working anymore!</P></BODY></HTML> Fri, 09 Oct 2015 19:55:49 GMT https://community.qlik.com/t5/QlikView/Retrieving-Spreadsheet-names/m-p/1002294#M966022 gardenierbi 2015-10-09T19:55:49Z Re: Retrieving Spreadsheet names https://community.qlik.com/t5/QlikView/Retrieving-Spreadsheet-names/m-p/1002295#M966023 <HTML><HEAD></HEAD><BODY><P>An external vbs-script triggered per execute-statement might be an alternatively:</P><P></P><P><A href="https://community.qlik.com/message/382298">Re: Re: Use excel sheet name in field</A>.</P><P><A href="https://community.qlik.com/message/883705">Re: Run Excel from QMC</A></P><P></P><P>- Marcus</P></BODY></HTML> Sat, 10 Oct 2015 00:05:55 GMT https://community.qlik.com/t5/QlikView/Retrieving-Spreadsheet-names/m-p/1002295#M966023 marcus_sommer 2015-10-10T00:05:55Z