- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Import of 3 sheets from the same Excel file
Hello all,
I would like to import 3 sheets from the same Excel file in JMP.
My Excel fil is encrypted with a password.
If I import the 3 sheets (AAA, BBB, and CCC) with the following code (written 3 times), I need to write 3 times the password:
Open(
"/P:/XXX/TEMPLATE.xlsx",
Worksheets( "AAA" ),
Use for all sheets( 1 ),
Concatenate Worksheets( 0 ),
Create Concatenation Column( 0 ),
Worksheet Settings(
1,
Has Column Headers( 1 ),
Number of Rows in Headers( 1 ),
Headers Start on Row( 1 ),
Data Starts on Row( 2 ),
Data Starts on Column( 1 ),
Data Ends on Row( 0 ),
Data Ends on Column( 0 ),
Replicated Spanned Rows( 1 ),
Replicated Spanned Headers( 0 ),
Suppress Hidden Rows( 1 ),
Suppress Hidden Columns( 1 ),
Suppress Empty Columns( 1 ),
Treat as Hierarchy( 0 ),
Multiple Series Stack( 0 ),
Import Cell Colors( 0 ),
Limit Column Detect( 0 ),
Column Separator String( "-" )
)
) ;
Is there a way to import the 3 Excel sheet (AAA, BBB, CCC) from the same Excel file without opening the Excel file each time ?
Thanks a lot for your answer,
Sébastien
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Import of 3 sheets from the same Excel file
Try specifying all 3 spreadsheets in the single input
Worksheets( { "AAA", "BBB", "CCC" }),
Jim
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Import of 3 sheets from the same Excel file
Try specifying all 3 spreadsheets in the single input
Worksheets( { "AAA", "BBB", "CCC" }),
Jim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Import of 3 sheets from the same Excel file
Created:
Mar 19, 2024 05:47 AM
| Last Modified: Mar 19, 2024 4:02 AM
(813 views)
| Posted in reply to message from txnelson 03-18-2024
Great, it works!
Thanks a lot for you reply,
Sébastien