Subscribe Bookmark RSS Feed

Opening Excel files with JSL

Is there a way to specify which worksheet of an Excel file to open using JSL without going through a dialog?

Also, is there a way to specify a row in an Excel document to use as column headers other than Row 1?

Thanks,

Bob
3 REPLIES
sfkeydel

Community Trekker

Joined:

Jun 23, 2011

Any input from SAS/JMP on this? I have the same question regarding specifying a worksheet for import.

Thanks,
Stefan
If you have an ODBC DSN for Excel files then you can use the Open Database command from JSL. Worksheets will then act as separate tables so "Select * from W1" will give you the contents only of worksheet W1.
sfkeydel

Community Trekker

Joined:

Jun 23, 2011

Got it. Thanks, Stig!