open excel multiple worksheets column name row 2

tsolomon

I am able to open multiple files and specify no header with "Table Contains Column Headers (0)". However, this does not seem to work when trying to open an excel file with multiple worksheets. I tried placing the comment in several locations to no avail. Any ideas?

raw_dt1 = Open(

"C:\Users\ts\Desktop\bacteria testing\Bacteria.xlsx",

Worksheets( {"Test Supply", Table Contains Column Headers( 0 )}));

Thanks

TS

txnelson

Here is some code generated by the JMP Excel Wizard, which opens an Excel workbook with multiple spreadsheets and no headers:

Open(

"C:\Users\txjim\Documents\sample.xlsx",

Worksheets( "Sheet2" ),

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( 1 ),

Data Starts on Row( 1 ),

Data Starts on Column( 1 ),

Data Ends on Row( 0 ),

Data Ends on Column( 0 ),

Replicated Spanned Rows( 1 ),

Suppress Hidden Rows( 1 ),

Suppress Hidden Columns( 1 ),

Suppress Empty Columns( 1 ),

Treat as Hierarchy( 0 )

));