JSL help: How can I open an excel spreadsheets and delete duplicates?

Hobbi — Fri, 09 Jun 2023 18:03:53 GMT

I have my script (from the excel import wizard) as well as the example attached. All those columns are there but I just removed the data.

I am mainly looking to open an excel spreadsheet and only keep columns B and C while also deleting duplicate rows. I keep getting errors when debugging that the

This is my script so far. I don't have a duplicate delete portion because I keep trying to deal with this error.

All the spreadsheets I intend to open have the same format as the attached one. Thank you!

Clear Symbols();

names default to here(1);

path = Pick File ();

dt = Open(
	path,
	Worksheets( "Sheet1" ),
	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( 2 ),
		Data Ends on Row( 0 ),
		Data Ends on Column( 3 ),
		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: JSL help: How can I open an excel spreadsheets and delete duplicates?

Thierry_S — Wed, 27 Oct 2021 20:27:21 GMT

Hi,

Your Excel file does not contain the worksheet named "Sheet1" (it is called "Data" instead). Hence, JMP cannot open the file. If all your Excel files look the same, just change the value of the Worksheets variable in your script to "Data".

Best,

Re: JSL help: How can I open an excel spreadsheets and delete duplicates?

Hobbi — Wed, 27 Oct 2021 20:47:41 GMT

Oh man - something so simple. Thank you very much!

topic Re: JSL help: How can I open an excel spreadsheets and delete duplicates? in Discussions

JSL help: How can I open an excel spreadsheets and delete duplicates?

Re: JSL help: How can I open an excel spreadsheets and delete duplicates?

Re: JSL help: How can I open an excel spreadsheets and delete duplicates?