cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-50997%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ETipo%20de%20columna%20de%20fuerza%20de%20importaci%C3%B3n%20de%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-50997%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3ESimilar%20a%20las%20publicaciones%20en%20las%20discusiones%3C%2FP%3E%3CP%3E1.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FDiscussions%2FHow-to-force-datatype-of-columns-when-importing-Excel-file%2Fm-p%2F41418%23M24172%22%20target%3D%22_blank%22%3E%20https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FDiscussions%2FHow-to-force-datatype-of-columns-when-importing-Excel-file%2Fmp%2F41418%23M24172%20%3C%2FA%3E%3C%2FP%3E%3CP%3E2.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FDiscussions%2FImport-Excel-table-with-columns-that-have-bad-data-types%2Fm-p%2F48132%23M27407%22%20target%3D%22_blank%22%3E%20https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FDiscussions%2FImport-Excel-table-with-columns-that-have-bad-data-types%2Fmp%2F48132%23M27407%20%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ES%C3%AD%2C%20aprecio%20que%20JMP%20respete%20lo%20que%20est%C3%A1%20en%20la%20pantalla%20%22Formato%20de%20celdas%22%20de%20Excel.%20Desafortunadamente%2C%20algunas%20personas%20(y%20algunas%20m%C3%A1quinas%20que%20crean%20archivos%20de%20datos%20de%20Excel)%20env%C3%ADan%20solicitudes%20de%20formato%20que%20simplemente%20son%20incorrectas.%20Me%20gustar%C3%ADa%20alguna%20forma%20de%20anular%20Excel%20cuando%20un%20usuario%20ha%20hecho%20algo%20est%C3%BApido%20como%20formatear%20una%20columna%20de%20letras%20como%20num%C3%A9rica.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETal%20como%20est%C3%A1%2C%20tengo%20que%20decirle%20a%20los%20usuarios%20que%20recopilen%20los%20datos%20y%20dejen%20que%20la%20m%C3%A1quina%20cree%20el%20archivo%20de%20Excel%2C%20luego%20abra%20Excel%20y%20arregle%20el%20archivo%2C%20luego%20vaya%20a%20JMP.%20Preferir%C3%ADa%20que%20mis%20usuarios%20se%20salten%20Excel%20para%20que%20no%20se%20sientan%20tentados%20a%20asumir%20que%20Excel%20tambi%C3%A9n%20podr%C3%ADa%20hacer%20su%20an%C3%A1lisis.%20La%20consecuencia%20es%20que%20se%20me%20pedir%C3%A1%20que%20escriba%20una%20macro%20de%20VBA%20para%20realizar%20el%20an%C3%A1lisis%2C%20de%20modo%20que%20los%20usuarios%20no%20tengan%20que%20usar%20dos%20programas%20separados%20para%20hacer%20un%20an%C3%A1lisis.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EY%20no%2C%20la%20m%C3%A1quina%20no%20puede%20crear%20un%20archivo%20CSV.%20Escribe%20un%20Excel%20de%20m%C3%BAltiples%20pesta%C3%B1as.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-50997%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3EAcceso%20a%20los%20datos%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Choose Language Hide Translation Bar

Excel Import force column type

Similar to posts in the Discussions

1. https://community.jmp.com/t5/Discussions/How-to-force-datatype-of-columns-when-importing-Excel-file/...

2. https://community.jmp.com/t5/Discussions/Import-Excel-table-with-columns-that-have-bad-data-types/m-...

 

Yes, I appreciate that JMP respects what is in Excel's "Format Cells" screen. Unfortunately, some people (and some machines that create Excel files of data) submit formatting requests that are simply wrong. I would like some way to override Excel when a user has done something stupid like format a column of letters as numeric.

 

As it stands I have to tell users to collect the data and let the machine create the Excel file, then open Excel and fix the file, then go to JMP. I would rather my users skip Excel so they aren't tempted to assume Excel could do their analysis, too. The consequence is that I am going to be asked to write a VBA macro to do the analysis instead so the users don't have to use two separate programs to make an analysis.

 

And no, the machine can't create a CSV file. It writes a multi-tabbed Excel.

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!