topic Re: JMP table to Excel with multiple worksheets depending on column property in JMP table. in Discussions

JMP table to Excel with multiple worksheets depending on column property in JMP table.

egon_gross — Sat, 10 Jun 2023 23:33:28 GMT

Hi everyone,

I have the challange to make inly one Excel file containing a bunch of worksheets out of a big JMP table in stacked format. For each colum vallue of the JMP table there should result one excel worksheet containing the definded columns (and values) of the JMP table.

I hope that I described the intended workflow propperly nad that there is help available.

Thanks in advance

Egon

Re: JMP table to Excel with multiple worksheets depending on column property in JMP table.

txnelson — Thu, 08 Jul 2021 14:06:16 GMT

This task should be a fairly simple thing to do.

Create a separate JMP data table for each spreadsheet you want in the workbook.
Create a JMP list that contains the data table references to each of the above tables
Create a JMP list that contains the desired name of each spreadsheet in the workbook
Use the Create Excel Workbook() function to create the Excel Workbook

It is pretty tough to go beyond this listing of the steps to take, without more specifics of how the "Column Value" relates to the columns in the different spreadsheet.

If you can provide more details, or maybe an actual sample of your data etc. it would be very helpful.

Re: JMP table to Excel with multiple worksheets depending on column property in JMP table.

egon_gross — Fri, 09 Jul 2021 09:16:30 GMT

Hi Jim,

thanks for the reply and the suggestions. We'll try out and I'll come back.

Egon

Re: JMP table to Excel with multiple worksheets depending on column property in JMP table.

egon_gross — Fri, 16 Jul 2021 11:27:42 GMT

Hi Jim,

we finally tried it out and were satisfied.

Thanks

Egon