jmp-l
[Top] [All Lists]

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

To: jmp-l@lists.biostat.wustl.edu
Subject: Re: How to generate a Matrix from an Excel file by JSL
From: Mark Bailey <mark4flies@aol.com>
Date: Sun, 8 Feb 2009 06:14:17 -0500
In-reply-to: <25e89e790902071631w2df2c3faya6df98c2a92cb02@mail.gmail.com>
References: <25e89e790902071631w2df2c3faya6df98c2a92cb02@mail.gmail.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)

=
<Prev in Thread] Current Thread [Next in Thread>