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
- :
- How to export JMP Data Tables as different Tabs of an Excel Sheet ?

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

Highlighted

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

Jul 10, 2015 9:28 AM
(9485 views)

Hi,

I have a couple of JMP Data Tables open and would like to export these as different tabs of one excel sheet.

How can I do this in JMP script?

Thanks,

Aman

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

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

Hello Aman,

JMP does not currently support saving different data tables as worksheets within a single workbook. The exception is on Windows when a table exceeds the limit for the number of rows in an Excel sheet, it will try to open multiple sheets to accommodate all of the data. Sorry.

Brian Corcoran

JMP Development

14 REPLIES 14

Highlighted

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

Hello Aman,

JMP does not currently support saving different data tables as worksheets within a single workbook. The exception is on Windows when a table exceeds the limit for the number of rows in an Excel sheet, it will try to open multiple sheets to accommodate all of the data. Sorry.

Brian Corcoran

JMP Development

Highlighted
##

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

Re: How to export JMP Data Tables as different Tabs of an Excel Sheet ?

I may well be wrong but I thought this was possible using ODBC.

Highlighted
##

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

Re: How to export JMP Data Tables as different Tabs of an Excel Sheet ?

I tried something like this.

*dt1= Data Table("Input");*

*dt1<<save database("DSN=Excel Files Aman 2;DBQ=C:\Users\b55019\Desktop\Yield.xls;DriverId=790;FIL=excel12.0;MaxBufferSize=2048;PageTimeout=5;","Raw Data");*

Seems to give me an ODBC mismatch error

Highlighted
##

Are your JMP and Excel(or ODBC?) both 32 bit or both 64 bit? Mine aren't so I can't explore this. For ODBC access to work you can't have one 64 bit and the other 32 bit.

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

Re: How to export JMP Data Tables as different Tabs of an Excel Sheet ?

Highlighted
##

I have both 32-bit and 64-bit JMP, but if you do not have 32-bit JMP then it is not going to work for you. Microsoft installers will not allow you to install 64-bit Excel ODBC drivers if you have 32-bit Office already installed.

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

Re: How to export JMP Data Tables as different Tabs of an Excel Sheet ?

Highlighted
##

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

Re: How to export JMP Data Tables as different Tabs of an Excel Sheet ?

If you have the 32-bit Excel/32-bit JMP combination, something like the following will work:

dt = open**(**"$SAMPLE_DATA/Big Class.jmp"**)**;

dt2 = open**(**"$SAMPLE_DATA/Tiretread.jmp"**)**;

dt << Save database**(**"DSN=Excel Files;DBQ=C:/Bigc.xlsb;", "BigC"**)**;

dt2 << Save database**(**"DSN=Excel Files;DBQ=C:/Bigc.xlsb;", "Tires"**)**;

Brian

Highlighted
##

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

Re: How to export JMP Data Tables as different Tabs of an Excel Sheet ?

I have a 64 bit JMP and 64 bit Excel combination . The command doesn't seem to work .

Gives me the same ODBC mismatch error .

Highlighted
##

I don't have 64-bit Excel available, so I can't try out that combination. You might want to try creating a new DSN with the 64-bit ODBC Driver Manager (the one in System->Administrative Tools->Data Sources (ODBC) . This is assuming you are using Windows. If you are on the Mac, I'm not sure what the issue might be.

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

Re: How to export JMP Data Tables as different Tabs of an Excel Sheet ?

Highlighted
##

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

Re: How to export JMP Data Tables as different Tabs of an Excel Sheet ?

I tried to do this on a windows machine . I am still getting the same error.

I wonder if there is a way in VB to do it .

Article Labels

There are no labels assigned to this post.