cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-241861%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EExcel%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%81%A8%E3%81%97%E3%81%A6%E4%BF%9D%E5%AD%98%E3%81%99%E3%82%8B%E3%81%A8%E3%81%8D%E3%81%AB%E3%83%95%E3%82%A9%E3%83%BC%E3%83%9E%E3%83%83%E3%83%88%E3%82%92%E5%86%8D%E7%8F%BE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-241861%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E5%AE%9F%E9%9A%9B%E3%81%AB%E3%81%AF%E3%80%81%E6%AE%8B%E5%BF%B5%E3%81%AA%E3%81%8C%E3%82%89%E3%80%81%E7%A7%81%E3%81%AE%E6%84%8F%E8%A6%8B%E3%81%A7%E3%81%AF%E3%80%81Microsoft%20Excel%E3%81%AF%E4%BE%9D%E7%84%B6%E3%81%A8%E3%81%97%E3%81%A6%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E5%BD%A2%E5%BC%8F%E3%81%AE%E3%83%87%E3%83%BC%E3%82%BF%E3%82%92%E4%BA%A4%E6%8F%9B%E3%81%99%E3%82%8B%E3%81%9F%E3%82%81%E3%81%AE%E4%BA%8B%E5%AE%9F%E4%B8%8A%E3%81%AE%E6%A8%99%E6%BA%96%E3%81%A7%E3%81%99%E3%80%82Google%E3%82%B9%E3%83%97%E3%83%AC%E3%83%83%E3%83%89%E3%82%B7%E3%83%BC%E3%83%88%E3%81%A7%E3%81%95%E3%81%88%E3%80%81%E3%83%A6%E3%83%BC%E3%82%B6%E3%83%BC%E3%81%ABExcel%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%82%92Google%E3%81%AE%E3%83%95%E3%82%A9%E3%83%BC%E3%83%9E%E3%83%83%E3%83%88%E3%81%AB%E5%A4%89%E6%8F%9B%E3%81%95%E3%81%9B%E3%82%8B%E3%81%AE%E3%81%A7%E3%81%AF%E3%81%AA%E3%81%8F%E3%80%81%E3%83%A6%E3%83%BC%E3%82%B6%E3%83%BC%E3%81%8CExcel%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%81%A7%E4%BD%9C%E6%A5%AD%E3%81%A7%E3%81%8D%E3%82%8B%E3%82%88%E3%81%86%E3%81%AB%E3%81%AA%E3%82%8A%E3%81%BE%E3%81%97%E3%81%9F%E3%80%82%E7%A7%81%E3%81%AF%E5%80%8B%E4%BA%BA%E7%9A%84%E3%81%ABJMP%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E3%82%92Excel%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%81%A8%E3%81%97%E3%81%A6%E3%82%A8%E3%82%AF%E3%82%B9%E3%83%9D%E3%83%BC%E3%83%88%E3%81%97%E3%81%A6%E3%80%81%E5%88%86%E6%9E%90%E3%81%AE%E3%80%8C%E3%83%A6%E3%83%BC%E3%82%B6%E3%83%BC%E3%80%8D%E3%81%A8%E5%85%B1%E6%9C%89%E3%81%99%E3%82%8B%E3%81%93%E3%81%A8%E3%81%8C%E3%82%88%E3%81%8F%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%E3%80%82%3C%2FP%3E%3CP%3EJMP%E3%81%8C%E3%83%87%E3%83%BC%E3%82%BF%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E3%82%92Microsoft%20Excel%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%81%A8%E3%81%97%E3%81%A6%E3%82%A8%E3%82%AF%E3%82%B9%E3%83%9D%E3%83%BC%E3%83%88%E3%81%99%E3%82%8B%E3%81%A8%E3%81%8D%E3%81%AB%E3%80%81%E4%B8%BB%E3%81%AA%E3%83%95%E3%82%A9%E3%83%BC%E3%83%9E%E3%83%83%E3%83%88%E3%82%AA%E3%83%97%E3%82%B7%E3%83%A7%E3%83%B3%E3%82%92%E5%B0%8A%E9%87%8D%E3%81%97%E3%81%9F%E3%81%84%E3%81%A8%E6%80%9D%E3%81%84%E3%81%BE%E3%81%99%E3%80%82%E5%85%B7%E4%BD%93%E7%9A%84%E3%81%AB%E3%81%AF%E6%AC%A1%E3%81%AE%E3%81%A8%E3%81%8A%E3%82%8A%E3%81%A7%E3%81%99%E3%80%82%3C%2FP%3E%3CP%3E%26nbsp%3B-%20%E5%88%97%E5%B9%85%3C%2FP%3E%3CP%3E%26nbsp%3B-%E3%83%87%E3%83%BC%E3%82%BF%E5%9E%8B%E3%80%81%E3%81%9F%E3%81%A8%E3%81%88%E3%81%B0Excel%E3%81%AE%E6%95%B0%E5%80%A4%E3%81%A8%E3%81%97%E3%81%A6%E3%81%AEJMP%E3%81%AE%E6%95%B0%E5%80%A4%E5%88%97%3C%2FP%3E%3CP%3E%26nbsp%3B-%E6%95%B0%E5%80%A4%E5%88%97%E3%81%AE%E3%83%95%E3%82%A9%E3%83%BC%E3%83%9E%E3%83%83%E3%83%88%3C%2FP%3E%3CP%3E%26nbsp%3B-%E5%80%A4%E3%83%A9%E3%83%99%E3%83%AB%3C%2FP%3E%3CP%3E%26nbsp%3B-%20%E3%82%B9%E3%82%AF%E3%83%AD%E3%83%BC%E3%83%AB%E3%83%AD%E3%83%83%E3%82%AF%3C%2FP%3E%3CP%3E%E5%AE%8C%E7%92%A7%E3%81%A7%E3%81%82%E3%82%8B%E5%BF%85%E8%A6%81%E3%81%AF%E3%81%82%E3%82%8A%E3%81%BE%E3%81%9B%E3%82%93%E3%80%82%E3%81%9F%E3%81%B6%E3%82%93%E3%80%81JMP%E3%83%81%E3%83%BC%E3%83%A0%E3%81%AB%E3%81%AF%E3%80%81JMP%E4%BB%A5%E5%A4%96%E3%81%AE%E3%83%A6%E3%83%BC%E3%82%B6%E3%83%BC%E3%81%A8%E3%83%87%E3%83%BC%E3%82%BF%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E3%82%92%E3%82%88%E3%82%8A%E3%82%B9%E3%83%9E%E3%83%BC%E3%83%88%E3%81%AB%E5%85%B1%E6%9C%89%E3%81%99%E3%82%8B%E3%81%9F%E3%82%81%E3%81%AEJMP%20Live%E9%96%A2%E9%80%A3%E3%81%AE%E4%BB%A3%E6%9B%BF%E6%89%8B%E6%AE%B5%E3%81%8C%E3%81%99%E3%81%A7%E3%81%AB%E3%81%82%E3%82%8B%E3%81%AE%E3%81%A7%E3%81%97%E3%82%87%E3%81%86%E3%81%8B%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-241861%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3E%E3%81%9D%E3%81%AE%E4%BB%96%E3%81%AE%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Choose Language Hide Translation Bar
0 Kudos

Reproduce format when saving as an Excel file

In reality, unfortunately in my opinion, Microsoft Excel is still the de facto standard for exchanging table-formatted data. Even Google Spreadsheet now lets users work on Excel files, rather than forcing users to convert Excel files to Google's format. I personally often export JMP tables as Excel files for sharing them with "users" of my analysis.

I wish JMP respects major formatting options when it exports a Data Table as a Microsoft Excel file, specifically:

 - Column Width

 - Data Type, e.g., Numeric Column in JMP as Number in Excel

 - Format of Numeric Columns

 - Value Labels

 - Scroll Lock

It does not have to be perfect. Maybe the JMP team already have a JMP Live-related alternative to sharing Data Tables with non-JMP users in a smarter way?

1 Comment
Ryan_Gilmore
Community Manager
Status changed to: Archived
We are archiving this request. If this is still important please comment with additional details and we will reopen. Thank you!