Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- How to save a group of files as excel spreadsheets?

Topic Options

- Start Article
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

How to save a group of files as excel spreadsheets?

Dec 3, 2009 12:39 PM
(1247 views)

Hi Guys,

How can I save a folder full of .jmp files as excel spreadsheets with a script?

I am trying something like:

How can I save a folder full of .jmp files as excel spreadsheets with a script?

I am trying something like:

5 REPLIES 5

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How to save a group of files as excel spreadsheets?

First thing is to make sure you can save a single table as an Excel file. Example:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How to save a group of files as excel spreadsheets?

Ok that worked.

It only works if the JMP file has < = 256 columns because of the Excel limitation.

Is there any way to split the extra columns into a different sheet?

I can do that in Excel VBA but I would like to do it in JMP.

It only works if the JMP file has < = 256 columns because of the Excel limitation.

Is there any way to split the extra columns into a different sheet?

I can do that in Excel VBA but I would like to do it in JMP.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How to save a group of files as excel spreadsheets?

Ok that worked.It only works if the JMP file has less than or equal to 256 columns because of the Excel limitation.Is there any way to split the extra columns into a different sheet?

I can do that in Excel VBA but I would like to do it in JMP.

I can do that in Excel VBA but I would like to do it in JMP.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How to save a group of files as excel spreadsheets?

I haven't done the details, but yes you should be able to do what you describe. It breaks down into 2 parts, (1) Creating subsets of no more than 256 columns and (2) Saving these subsets as individual sheets of the same Excel workbook.

1. Script the Table>Subset after counting the number of columns in the original table and assessing how many subsets you need to create

2. Use the capabilities built into the JSL ODBC access to databases (in this case the Excel file is a "database" whose tables are the sheets). Though you'll have to play a bit to get it, the basics are outlined in the Scripting docs on p384-5. In addition, if you open the JMP log and see what code is generated by opening and saving an Excel file using "Open Database Table" you'll get some more hints of how to handle it.

It will take some fussing to get it right but it can be done.

1. Script the Table>Subset after counting the number of columns in the original table and assessing how many subsets you need to create

2. Use the capabilities built into the JSL ODBC access to databases (in this case the Excel file is a "database" whose tables are the sheets). Though you'll have to play a bit to get it, the basics are outlined in the Scripting docs on p384-5. In addition, if you open the JMP log and see what code is generated by opening and saving an Excel file using "Open Database Table" you'll get some more hints of how to handle it.

It will take some fussing to get it right but it can be done.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How to save a group of files as excel spreadsheets?

Ok thanks, I will try that.