DATA Step, Macro, Functions and more

reading in excel file with hidden columns

Reply
Occasional Learner
Posts: 1

reading in excel file with hidden columns

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!

Super User
Posts: 19,878

Re: reading in excel file with hidden columns

PROC IMPORT will read them by default.
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.
Occasional Contributor
Posts: 8

Re: reading in excel file with hidden columns

Proc import reads in the hidden fields with no issues.

Ask a Question
Discussion stats
  • 2 replies
  • 78 views
  • 2 likes
  • 3 in conversation