BookmarkSubscribeRSS 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

Re: Opening Excel files with JSL

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

Thanks,
Stefan

Re: Opening Excel files with JSL

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

Re: Opening Excel files with JSL

Got it. Thanks, Stig!