Re: How to generate a Matrix from an Excel file by JSL

[Mark Bailey <mark4flies@aol.com>]

I would use the Open Database() function and a SQL query to obtain the subset of the worksheet in a new JMP data table. Then use the Get As Matrix message with the current data table to obtain the matrix of all of the numeric columns.

On Feb 7, 2009, at 7:31 PM, Fred Zhang wrote:

I have a big Excel spreadsheet, and would like to take its subset

as a matrix.

How can I do it by JMP Script?

 

Thanks a lot.

 

Fred

Mark

They hate you if you're clever, and they despise a fool ("Working Class Hero" - John Lennon)

=