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%3ESpaltentyp%20f%C3%BCr%20Excel-Import%20erzwingen%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-50997%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%C3%84hnlich%20wie%20Beitr%C3%A4ge%20in%20den%20Diskussionen%3C%2FP%3E%3CP%3E1.%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%3C%2FA%3E%3C%2FP%3E%3CP%3E2.%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%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJa%2C%20ich%20wei%C3%9F%20es%20zu%20sch%C3%A4tzen%2C%20dass%20JMP%20den%20Excel-Bildschirm%20%E2%80%9EZellen%20formatieren%E2%80%9C%20respektiert.%20Leider%20senden%20einige%20Leute%20(und%20einige%20Computer%2C%20die%20Excel-Dateien%20mit%20Daten%20erstellen)%20Formatierungsanforderungen%2C%20die%20einfach%20falsch%20sind.%20Ich%20h%C3%A4tte%20gerne%20eine%20M%C3%B6glichkeit%2C%20Excel%20zu%20%C3%BCberschreiben%2C%20wenn%20ein%20Benutzer%20etwas%20Dummes%20getan%20hat%2C%20wie%20eine%20Spalte%20mit%20Buchstaben%20als%20numerisch%20zu%20formatieren.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20wie%20es%20aussieht%2C%20muss%20ich%20die%20Benutzer%20anweisen%2C%20die%20Daten%20zu%20sammeln%20und%20die%20Maschine%20die%20Excel-Datei%20erstellen%20zu%20lassen%2C%20dann%20Excel%20zu%20%C3%B6ffnen%20und%20die%20Datei%20zu%20reparieren%20und%20dann%20zu%20JMP%20zu%20gehen.%20Ich%20w%C3%BCrde%20es%20vorziehen%2C%20wenn%20meine%20Benutzer%20Excel%20%C3%BCberspringen%2C%20damit%20sie%20nicht%20in%20Versuchung%20kommen%2C%20anzunehmen%2C%20dass%20Excel%20auch%20ihre%20Analysen%20durchf%C3%BChren%20k%C3%B6nnte.%20Die%20Konsequenz%20ist%2C%20dass%20ich%20gebeten%20werde%2C%20stattdessen%20ein%20VBA-Makro%20zu%20schreiben%2C%20um%20die%20Analyse%20durchzuf%C3%BChren%2C%20damit%20die%20Benutzer%20nicht%20zwei%20separate%20Programme%20verwenden%20m%C3%BCssen%2C%20um%20eine%20Analyse%20durchzuf%C3%BChren.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnd%20nein%2C%20die%20Maschine%20kann%20keine%20CSV-Datei%20erstellen.%20Es%20schreibt%20ein%20Excel%20mit%20mehreren%20Registerkarten.%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%3EDatenzugriff%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-560985%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Spaltentyp%20Excel-Import%20erzwingen%20-%20Status%20ge%C3%A4ndert%20in%3A%20Archiviert%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-560985%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EWir%20archivieren%20diese%20Anfrage.%20Wenn%20dies%20immer%20noch%20wichtig%20ist%2C%20kommentieren%20Sie%20bitte%20mit%20zus%C3%A4tzlichen%20Details%20und%20wir%20werden%20wieder%20%C3%B6ffnen.%20Danke%20sch%C3%B6n!%3C%2FLINGO-BODY%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!