https://communities.sas.com/t5/SAS-Procedures/importing-excel-from-website/m-p/61811#M17537 Hi,<BR /> <BR /> I am trying to import an excel file from a webite, but am having trouble because the excel file has merged cells in the first few rows and contains multiple worksheets. I am using an infile statement since it is an url. Is there anyway I can get SAS to read specific cell range or line up the merged cells correctly?<BR /> <BR /> Thanks. Wed, 05 Aug 2009 19:36:47 GMT deleted_user 2009-08-05T19:36:47Z https://communities.sas.com/t5/SAS-Procedures/importing-excel-from-website/m-p/61811#M17537 Hi,<BR /> <BR /> I am trying to import an excel file from a webite, but am having trouble because the excel file has merged cells in the first few rows and contains multiple worksheets. I am using an infile statement since it is an url. Is there anyway I can get SAS to read specific cell range or line up the merged cells correctly?<BR /> <BR /> Thanks. Wed, 05 Aug 2009 19:36:47 GMT https://communities.sas.com/t5/SAS-Procedures/importing-excel-from-website/m-p/61811#M17537 deleted_user 2009-08-05T19:36:47Z https://communities.sas.com/t5/SAS-Procedures/importing-excel-from-website/m-p/61812#M17538 You probably have to this in 2 steps:<BR /> 1- download file from URL<BR /> 2- read local excel file using one of the available methods.<BR /> That's because there is no excel-aware mechanism that can use the URL engine afaik. Thu, 06 Aug 2009 23:23:17 GMT https://communities.sas.com/t5/SAS-Procedures/importing-excel-from-website/m-p/61812#M17538 ChrisNZ 2009-08-06T23:23:17Z