topic Re: Extract the number of Tabs and their Names from spreadsheets in SAS Programming https://communities.sas.com/t5/SAS-Programming/Extract-the-number-of-Tabs-and-their-Names-from-spreadsheets/m-p/134474#M260906 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Set a libname to the Excel file:</P><P>libname myexcel excel "xxx.xlsx";</P><P></P><P>Then you can access sashelp.vtable to see what tabs are within. </P><P></P><P>Make sure you libname myexcel clear; afterwards.</P></BODY></HTML> Mon, 09 Jun 2014 14:23:18 GMT RW9 2014-06-09T14:23:18Z Extract the number of Tabs and their Names from spreadsheets https://communities.sas.com/t5/SAS-Programming/Extract-the-number-of-Tabs-and-their-Names-from-spreadsheets/m-p/134473#M260905 <HTML><HEAD></HEAD><BODY><P>Hello experts,<BR />I am working on a project where I need to find</P><P>1. Spreadsheet names ( I have done that)</P><P>2. Names of the tabs in each spreadsheet</P><P>3.Count of number of tabs in each spread sheet</P><P>from&nbsp; a folder containing numerous spreadsheets(Xls files).</P><P></P><P>I am struggling on second step, if you have any resources or advice, please share with me.</P><P>Thanks,</P><P>Raghu.</P></BODY></HTML> Mon, 09 Jun 2014 14:18:18 GMT https://communities.sas.com/t5/SAS-Programming/Extract-the-number-of-Tabs-and-their-Names-from-spreadsheets/m-p/134473#M260905 rnmishra 2014-06-09T14:18:18Z Re: Extract the number of Tabs and their Names from spreadsheets https://communities.sas.com/t5/SAS-Programming/Extract-the-number-of-Tabs-and-their-Names-from-spreadsheets/m-p/134474#M260906 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Set a libname to the Excel file:</P><P>libname myexcel excel "xxx.xlsx";</P><P></P><P>Then you can access sashelp.vtable to see what tabs are within. </P><P></P><P>Make sure you libname myexcel clear; afterwards.</P></BODY></HTML> Mon, 09 Jun 2014 14:23:18 GMT https://communities.sas.com/t5/SAS-Programming/Extract-the-number-of-Tabs-and-their-Names-from-spreadsheets/m-p/134474#M260906 RW9 2014-06-09T14:23:18Z