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%3EReproduire%20le%20format%20lors%20de%20l'enregistrement%20en%20tant%20que%20fichier%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-241861%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EEn%20r%C3%A9alit%C3%A9%2C%20malheureusement%20%C3%A0%20mon%20avis%2C%20Microsoft%20Excel%20est%20toujours%20la%20norme%20de%20facto%20pour%20l'%C3%A9change%20de%20donn%C3%A9es%20au%20format%20tableau.%20M%C3%AAme%20Google%20Spreadsheet%20permet%20d%C3%A9sormais%20aux%20utilisateurs%20de%20travailler%20sur%20des%20fichiers%20Excel%2C%20plut%C3%B4t%20que%20de%20forcer%20les%20utilisateurs%20%C3%A0%20convertir%20des%20fichiers%20Excel%20au%20format%20de%20Google.%20Personnellement%2C%20j'exporte%20souvent%20des%20tableaux%20JMP%20sous%20forme%20de%20fichiers%20Excel%20pour%20les%20partager%20avec%20les%20%C2%AButilisateurs%C2%BB%20de%20mon%20analyse.%3C%2FP%3E%3CP%3EJe%20souhaite%20que%20JMP%20respecte%20les%20principales%20options%20de%20mise%20en%20forme%20lorsqu'il%20exporte%20un%20tableau%20de%20donn%C3%A9es%20sous%20forme%20de%20fichier%20Microsoft%20Excel%2C%20en%20particulier%3A%3C%2FP%3E%3CP%3E%26nbsp%3B-%20Largeur%20de%20colonne%3C%2FP%3E%3CP%3E%26nbsp%3B-%20Type%20de%20donn%C3%A9es%2C%20par%20exemple%2C%20colonne%20num%C3%A9rique%20dans%20JMP%20en%20tant%20que%20nombre%20dans%20Excel%3C%2FP%3E%3CP%3E%26nbsp%3B-%20Format%20des%20colonnes%20num%C3%A9riques%3C%2FP%3E%3CP%3E%26nbsp%3B-%20%C3%89tiquettes%20de%20valeur%3C%2FP%3E%3CP%3E%26nbsp%3B-%20Verrouillage%20du%20d%C3%A9filement%3C%2FP%3E%3CP%3EIl%20n'est%20pas%20n%C3%A9cessaire%20que%20ce%20soit%20parfait.%20Peut-%C3%AAtre%20que%20l'%C3%A9quipe%20JMP%20a%20d%C3%A9j%C3%A0%20une%20alternative%20li%C3%A9e%20%C3%A0%20JMP%20Live%20pour%20partager%20des%20tables%20de%20donn%C3%A9es%20avec%20des%20utilisateurs%20non-JMP%20d'une%20mani%C3%A8re%20plus%20intelligente%3F%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%3EAutre%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!