topic reading in excel file with hidden columns in SAS Programming https://communities.sas.com/t5/SAS-Programming/reading-in-excel-file-with-hidden-columns/m-p/391508#M94028 <P>Hi, does anyone know how to read in hidden columns from an Excel file without manually unhiding them? Right now, when I read in an Excel sheet (using DDE), the hidden column is not read, and the column that follows it (with string characters) is not populated. Once I manually unhide the column, it is read, and so is teh following column. I would like to avoid manually unhiding columns in several Excel sheets. Thanks!</P> Tue, 29 Aug 2017 14:58:43 GMT tanya1 2017-08-29T14:58:43Z reading in excel file with hidden columns https://communities.sas.com/t5/SAS-Programming/reading-in-excel-file-with-hidden-columns/m-p/391508#M94028 <P>Hi, does anyone know how to read in hidden columns from an Excel file without manually unhiding them? Right now, when I read in an Excel sheet (using DDE), the hidden column is not read, and the column that follows it (with string characters) is not populated. Once I manually unhide the column, it is read, and so is teh following column. I would like to avoid manually unhiding columns in several Excel sheets. Thanks!</P> Tue, 29 Aug 2017 14:58:43 GMT https://communities.sas.com/t5/SAS-Programming/reading-in-excel-file-with-hidden-columns/m-p/391508#M94028 tanya1 2017-08-29T14:58:43Z Re: reading in excel file with hidden columns https://communities.sas.com/t5/SAS-Programming/reading-in-excel-file-with-hidden-columns/m-p/391511#M94030 PROC IMPORT will read them by default.<BR />DDE is a manual process so the workaround in DDE would be difficult. DDE really shouldn't be used anymore, it's getting more and more out of date. Tue, 29 Aug 2017 15:02:19 GMT https://communities.sas.com/t5/SAS-Programming/reading-in-excel-file-with-hidden-columns/m-p/391511#M94030 Reeza 2017-08-29T15:02:19Z Re: reading in excel file with hidden columns https://communities.sas.com/t5/SAS-Programming/reading-in-excel-file-with-hidden-columns/m-p/391513#M94032 <P>Proc import reads in the hidden fields with no issues.</P> Tue, 29 Aug 2017 15:07:22 GMT https://communities.sas.com/t5/SAS-Programming/reading-in-excel-file-with-hidden-columns/m-p/391513#M94032 piyushas 2017-08-29T15:07:22Z