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%3EReproducir%20formato%20al%20guardar%20como%20archivo%20de%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%20realidad%2C%20desafortunadamente%20en%20mi%20opini%C3%B3n%2C%20Microsoft%20Excel%20sigue%20siendo%20el%20est%C3%A1ndar%20de%20facto%20para%20el%20intercambio%20de%20datos%20con%20formato%20de%20tabla.%20Incluso%20Google%20Spreadsheet%20ahora%20permite%20a%20los%20usuarios%20trabajar%20en%20archivos%20de%20Excel%2C%20en%20lugar%20de%20obligar%20a%20los%20usuarios%20a%20convertir%20archivos%20de%20Excel%20al%20formato%20de%20Google.%20Personalmente%2C%20a%20menudo%20exporto%20tablas%20JMP%20como%20archivos%20de%20Excel%20para%20compartirlas%20con%20los%20%22usuarios%22%20de%20mi%20an%C3%A1lisis.%3C%2FP%3E%3CP%3EDeseo%20que%20JMP%20respete%20las%20principales%20opciones%20de%20formato%20cuando%20exporta%20una%20tabla%20de%20datos%20como%20un%20archivo%20de%20Microsoft%20Excel%2C%20espec%C3%ADficamente%3A%3C%2FP%3E%3CP%3E%26nbsp%3B-%20Ancho%20de%20columna%3C%2FP%3E%3CP%3E%26nbsp%3B-%20Tipo%20de%20datos%2C%20por%20ejemplo%2C%20columna%20num%C3%A9rica%20en%20JMP%20como%20n%C3%BAmero%20en%20Excel%3C%2FP%3E%3CP%3E%26nbsp%3B-%20Formato%20de%20columnas%20num%C3%A9ricas%3C%2FP%3E%3CP%3E%26nbsp%3B-%20Etiquetas%20de%20valor%3C%2FP%3E%3CP%3E%26nbsp%3B-%20Bloqueo%20de%20desplazamiento%3C%2FP%3E%3CP%3ENo%20tiene%20que%20ser%20perfecto.%20%C2%BFQuiz%C3%A1s%20el%20equipo%20de%20JMP%20ya%20tiene%20una%20alternativa%20relacionada%20con%20JMP%20Live%20para%20compartir%20tablas%20de%20datos%20con%20usuarios%20que%20no%20son%20de%20JMP%20de%20una%20manera%20m%C3%A1s%20inteligente%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%3EOtro%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!