cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Sign-in to the JMP Community will be unavailable intermittently Dec. 6-7 due to a system update. Thank you for your understanding!
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
  • JMP 19 is here! Learn more about the new features.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
NeF
NeF
Level III

Exporting data from jmp to excel without excluded rows

Hi, 

Is there any add-in for jmp that helps exporting data to excl without exclueded rows? 

Thanks,

Ne

4 REPLIES 4
txnelson
Super User

Re: Exporting data from jmp to excel without excluded rows

If you just use
File==>Save As
and then navigate to the folder you want to save the data table to and specify to save it as an Excel Workbook, the table will be saved without eliminating and Excluded rows.

Is this what you were asking, or is there something I am missing.....

 

Oops.....I misread the question......Dan below has an answer that works.....delete the excluded rows, but, you can also easily subset the data table, by selecting the non excluded rows, and then save that data table to Excel

Jim
NeF
NeF
Level III

Re: Exporting data from jmp to excel without excluded rows

Dear txnelson

Thanks for your kind reply. 

Dan's reply and yours as well (the second one :) )  helped me alot. 

Best,

NeF

Re: Exporting data from jmp to excel without excluded rows

If you want the Excel table WITHOUT the excluded rows, it is would be easiest to select the excluded rows (you can do that easily by clicking on the Excluded Rows number in the Row Panel), delete them, and use File > Save As and choose the Excel format.

Dan Obermiller
NeF
NeF
Level III

Re: Exporting data from jmp to excel without excluded rows

Dear Dan,
Thanks!
NeF

Recommended Articles