topic Re: Exporting Multiple Excel sheets with multiple tabs in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Exporting-Multiple-Excel-sheets-with-multiple-tabs/m-p/137139#M11106 <HTML><HEAD></HEAD><BODY><P>I actually tried creating an excel file with nothing in the first row and data starting in the second row and SAS read it fine.&nbsp; It found the variable names and everything. Not sure how it knew to do that.</P></BODY></HTML> Mon, 10 Mar 2014 03:49:52 GMT Tom 2014-03-10T03:49:52Z Exporting Multiple Excel sheets with multiple tabs https://communities.sas.com/t5/SAS-Enterprise-Guide/Exporting-Multiple-Excel-sheets-with-multiple-tabs/m-p/137138#M11105 <HTML><HEAD></HEAD><BODY><P>Hello everybody,</P><P></P><P>I have different excel files with multiple tabs to be imported.All excel sheets has data starting row 2 ( 1 row blank and 2nd row header). I saw some online documents but they were not straightforward. I am wondering if any body can help me on that</P><P></P><P>Thanks </P></BODY></HTML> Sat, 08 Mar 2014 03:30:46 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Exporting-Multiple-Excel-sheets-with-multiple-tabs/m-p/137138#M11105 learner_sas 2014-03-08T03:30:46Z Re: Exporting Multiple Excel sheets with multiple tabs https://communities.sas.com/t5/SAS-Enterprise-Guide/Exporting-Multiple-Excel-sheets-with-multiple-tabs/m-p/137139#M11106 <HTML><HEAD></HEAD><BODY><P>I actually tried creating an excel file with nothing in the first row and data starting in the second row and SAS read it fine.&nbsp; It found the variable names and everything. Not sure how it knew to do that.</P></BODY></HTML> Mon, 10 Mar 2014 03:49:52 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Exporting-Multiple-Excel-sheets-with-multiple-tabs/m-p/137139#M11106 Tom 2014-03-10T03:49:52Z