add contains in the Open worksheets

Jackie_ — Thu, 10 Oct 2024 13:28:50 GMT

Hi,

Is there a way to use the Contains() function to search for a specific string in the open worksheets? I want to avoid importing all the tabs and then using Contains() to find the data table list. My preference is to use the Contains() function to only import the sheet in JMP that contains the specific string.

Open(
	dir_path,
	Worksheets( "Test Spec & Conditions" ), // Contains( "Test") |  Contains( "Spec")
	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( "-" )
	)
);

Re: add contains in the Open worksheets

txnelson — Thu, 10 Oct 2024 13:51:20 GMT

You can use

Names Default To Here( 1 );
sheetList = Get Excel Worksheets( "$SAMPLE_IMPORT_DATA\Team Results.xlsx" );
Show( sheetList );

to determine what sheets exist, and then only read in the ones you want.

topic Re: add contains in the Open worksheets in Discussions

add contains in the Open worksheets

Re: add contains in the Open worksheets