topic Re: Wouldn't it be nice to export tabulate to excel with header rows as hierarchies in Discussions

Wouldn't it be nice to export tabulate to excel with header rows as hierarchies

saitcopuroglu — Wed, 19 Oct 2016 00:05:00 GMT

We are able to import multiple column header rows as hieararchies when importing excel to jmp. Wouldn't it be nice to be able to to it opposite way directly from tabulate to excel with merged cells..etc...?

Re: Wouldn't it be nice to export tabulate to excel with header rows as hierarchies

KarenC — Thu, 30 Jul 2015 19:24:33 GMT

Hmm, I am always trying to get data out of excel and into JMP, not the other way around. However, you can get there if you "go around the block". Select the tabulate output with the selector tool, paste into word, copy from word to excel. Not ideal for repetitive tasks but it works (at least on a Mac ).

Re: Wouldn't it be nice to export tabulate to excel with header rows as hierarchies

saitcopuroglu — Fri, 31 Jul 2015 14:02:21 GMT

Thank you, it really is not for repetitive tasking but it works (luckily I am on Mac also).

Actually there are many managers in the company who would like to play with the data as they wish (sort, formulate, format) so excel is still a must for them. hi-tech but untouchable html5 output is not an output for them, 'it is only a picture' as they say...

I wish the beloved developers hear my dreams and they make it one day come true

Many thanks again!