BookmarkSubscribeRSS Feed
tsolomon11
Calcite | Level 5

HI, I am trying to open an excel with different worksheets and select the second row as the column names. I tried using the code below that Brian Corcoran posted but despite changing the Has Column Headers and Data Starts on Row, the first in the excel file is always selected as the coumn names? Any ideas on why this is not working.

 

 

Open("C:\Users\tsolomo\Desktop\bactera.xlsx",

Worksheets( "D1D UPW Supply" ),

Use for all sheets( 1 ),

Concatenate Worksheets( 0 ),

Create Concatenation Column( 0 ),

1,

Has Column Headers( 0 ),

Number of Rows in Headers( 1 ),

Headers Start on Row( 2 ),

Data Starts on Row( 3 ),

Data Starts on Column( 1 ),

Data Ends on Row( 30 ),

Data Ends on Column( 10 ),

Replicated Spanned Rows( 1 ),

Suppress Hidden Rows( 1 ),

Suppress Hidden Columns( 1 ),

Treat as Hierarchy( 0 )

);

2 REPLIES 2
PGStats
Opal | Level 21

This looks like JSL... Try posting to the JMP User Community.

PG
tsolomon11
Calcite | Level 5

thanks, will do

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Discussion stats
  • 2 replies
  • 939 views
  • 1 like
  • 2 in conversation