cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-382601%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EWie%20kann%20ich%20Excel-Tabellen%20importieren%2C%20die%20beim%20Import%20in%20JMP%20auf%20den%20Namen%20der%20Excel-Arbeitsmappe%20verweisen%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-382601%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EIch%20habe%20eine%20Menge%20Excel-Dateien%20im%20Wert%20von%20etwa%20zwei%20Jahren%2C%20die%20monatlich%20zusammengestellt%20werden.%20Ich%20m%C3%B6chte%20aus%20jeder%20Arbeitsmappe%20ein%20Blatt%20in%20JMP%20importieren.%20Leider%20wird%20auf%20den%20Datums-%2FZeitstempel%20nur%20im%20Titel%20jeder%20Arbeitsmappe%20verwiesen%20und%20nicht%20irgendwo%20auf%20den%20Bl%C3%A4ttern%2C%20die%20ich%20importieren%20m%C3%B6chte.%20Gibt%20es%20eine%20M%C3%B6glichkeit%2C%20den%20Arbeitsmappentitel%20mit%20dem%20Blatt%20zu%20importieren%3F%3C%2FP%3E%3CP%3EDanke%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-382601%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-525226%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Wie%20kann%20ich%20Excel-Tabellen%20importieren%2C%20die%20beim%20Import%20in%20JMP%20auf%20den%20Namen%20der%20Excel-Arbeitsmappe%20verweisen%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-525226%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EWenn%20ich%20verstehe%2C%20was%20Sie%20wollen%2C%20k%C3%B6nnen%20Sie%20auf%20jeden%20Fall%20ein%20JSL-Skript%20schreiben%2C%20das%20damit%20umgehen%20kann.%20Wie%20das%20JSL-Skript%20aussehen%20und%20was%20es%20tun%20soll%2C%20h%C3%A4ngt%20stark%20von%20den%20Daten%20ab%2C%20die%20Sie%20haben%20und%20wie%20diese%20erstellt%20werden.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EH%C3%B6chstwahrscheinlich%20ben%C3%B6tigen%20Sie%20mindestens%20Files%20In%20Directory()%2C%20For-Schleife%20(oder%20vielleicht%20noch%20besser%20For%20Each)%2C%20Open()%20und%20dann%20einige%20Funktionen%20zur%20Manipulation%20von%20Zeichenfolgen%2FDatentabellen.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-525205%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Wie%20kann%20ich%20Excel-Tabellen%20importieren%2C%20die%20beim%20Import%20in%20JMP%20auf%20den%20Namen%20der%20Excel-Arbeitsmappe%20verweisen%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-525205%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EHallo%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F5579%22%20target%3D%22_blank%22%3E%20%40Wendy_Murphrey%3C%2FA%3E%20%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEs%20tut%20mir%20leid%2C%20dass%20ich%20ein%20abgeschlossenes%20Gespr%C3%A4ch%20noch%20einmal%20aufleben%20lasse%2C%20aber%20ich%20habe%20eine%20%C3%A4hnliche%20Frage.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGenau%20wie%20Fiona%20habe%20ich%20jede%20Menge%20Excel-Dateien%2C%20aus%20denen%20ich%20Daten%20zur%20Analyse%20in%20JMP%20%C3%BCbertrage.%20Bis%20vor%20Kurzem%20habe%20ich%20das%20auf%20sehr%20mittelalterliche%20Weise%20gemacht%2C%20indem%20ich%20die%20Excel-Dateien%20manuell%20ge%C3%B6ffnet%20und%20die%20relevanten%20Informationen%20direkt%20in%20die%20JMP-Tabellen%20kopiert%20habe.%20Obwohl%20dies%20vertretbar%20ist%2C%20glaube%20ich%2C%20dass%20die%20Importfunktion%20(zusammen%20mit%20der%20Verkettung%20zum%20Anh%C3%A4ngen%20an%20vorhandene%20Datentabellen)%20eine%20viel%20bessere%20langfristige%20L%C3%B6sung%20zur%20Verbesserung%20der%20Wirksamkeit%20darstellt.%3CBR%20%2F%3E%20Was%20Fiona%20betrifft%2C%20sind%20meine%20relevanten%20Informationen%20in%20Blatt%204%20jeder%20Arbeitsmappe%20enthalten%20und%20mit%20%E2%80%9EZyklus%E2%80%9C%20gekennzeichnet.%20Ich%20muss%20zwischen%204%20und%2020%20solcher%20Arbeitsmappen%20gleichzeitig%20importieren%2C%20um%20meine%20JMP-Tabellen%20zu%20aktualisieren.%20Jede%20Arbeitsmappe%20hat%20einen%20Zeichenfolgentitel%2C%20der%20normalerweise%208%20Zeichen%20lang%20ist.%20Dies%20ist%20eine%20eindeutige%20Kennung%20f%C3%BCr%20das%20getestete%20Objekt.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMeine%20Fragen%20lauten%20wie%20folgt%3A%20Ist%20es%20f%C3%BCr%20mich%20m%C3%B6glich%2C%20den%20Namen%20der%20generierten%20Tabelle%20beim%20Import%20zu%20ersetzen%3F%20Wenn%20ich%20beispielsweise%20derzeit%208%20Dateien%20importiere%2C%20sind%20die%20in%20JMP%20generierten%20Tabellen%20%E2%80%9EZyklus%E2%80%9C%2C%20%E2%80%9EZyklus%202%E2%80%9C%2C%20%E2%80%9EZyklus%203%E2%80%9C%20usw%20.)%20die%20Titel%20der%20urspr%C3%BCnglichen%20Excel-Arbeitsmappen%20sein%20sollen%20(in%20diesem%20Beispiel%20%E2%80%9EArbeitsmappe%201%E2%80%9C%2C%20%E2%80%9EArbeitsmappe%202%E2%80%9C%2C%20%E2%80%9EArbeitsmappe%203%E2%80%9C%20usw.)%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMeine%20n%C3%A4chste%20Frage%20betrifft%20die%20Verkettung.%20Ist%20es%20f%C3%BCr%20mich%20m%C3%B6glich%2C%20ein%20Skript%20zu%20schreiben%2C%20das%20eine%20bestimmte%20Zelle%20analysiert%20(z.%20B.%20die%20von%20Ihrem%20Skript%20generierte%2C%20die%20beim%20Import%20den%20Titel%20der%20Arbeitsmappe%20in%20eine%20bestimmte%20Spalte%20kopiert)%20und%20dann%20den%20Wert%20in%20dieser%20Zelle%20zum%20Anh%C3%A4ngen%20verwendet%3F%20die%20Informationen%20in%20den%20verbleibenden%20Spalten%20in%20eine%20vorhandene%20JMP-Tabelle%20einf%C3%BCgen%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStellen%20wir%20uns%20zur%20Verdeutlichung%20vor%2C%20dass%20ich%20ein%20Objekt%20teste%2C%20in%20diesem%20Fall%20mit%20der%20Bezeichnung%20%E2%80%9EA71320%E2%80%9C.%20Ich%20habe%20eine%20JMP-Datentabelle%20mit%20dem%20Namen%20%E2%80%9EA71320%E2%80%9C%2C%20die%20eine%20Zusammenstellung%20aller%20meiner%20relevanten%20Daten%20f%C3%BCr%20dieses%20Testobjekt%20ist.%20Bei%20jedem%20neuen%20Test%20wird%20eine%20Excel-Datei%20mit%20der%20Bezeichnung%20%E2%80%9EA71320%E2%80%9C%20generiert.%20Ich%20m%C3%B6chte%20diese%20Datei%20mit%20Ihrem%20Skript%20importieren.%20Wenn%20ich%20das%20richtig%20verstanden%20habe%2C%20werden%20dann%20alle%20Daten%20aus%20Blatt%204%2C%20%E2%80%9EZyklus%E2%80%9C%2C%20kopiert%2C%20eine%20neue%20JMP-Tabelle%20mit%20der%20Bezeichnung%20%E2%80%9EZyklus%E2%80%9C%20erstellt%20und%20dann%20in%20dieser%20neuen%20Tabelle%20eine%20neue%20Spalte%20mit%20einer%20gef%C3%BCllten%20Zelle%2C%20%E2%80%9EA71320%E2%80%9C%2C%20erstellt.%20.%20Ich%20m%C3%B6chte%20dann%20ein%20Skript%20ausf%C3%BChren%2C%20das%20diese%20Zelle%20%E2%80%9EA71320%E2%80%9C%20sieht%2C%20eine%20vorhandene%20Tabelle%20in%20JMP%20mit%20dem%20Namen%20%E2%80%9EA71320%E2%80%9C%20erkennt%20und%20alle%20Informationen%20au%C3%9Fer%20der%20Titelzelle%20von%20%E2%80%9Ecycle%E2%80%9C%20an%20%E2%80%9EA71320%E2%80%9C%20anh%C3%A4ngt.%20Ist%20das%20m%C3%B6glich%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMein%20aufrichtiger%20Dank%20daf%C3%BCr%2C%20dass%20Sie%20sich%20die%20Zeit%20genommen%20haben%2C%20diese%20Frage%20zu%20lesen.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAntilope%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-384727%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Wie%20kann%20ich%20Excel-Tabellen%20importieren%2C%20die%20beim%20Import%20in%20JMP%20auf%20den%20Namen%20der%20Excel-Arbeitsmappe%20verweisen%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-384727%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EEindrucksvoll!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-384696%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Wie%20kann%20ich%20Excel-Tabellen%20importieren%2C%20die%20beim%20Import%20in%20JMP%20auf%20den%20Namen%20der%20Excel-Arbeitsmappe%20verweisen%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-384696%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F16121%22%20target%3D%22_blank%22%3E%40fionaweston%3C%2FA%3E%20Es%20h%C3%B6rt%20sich%20so%20an%2C%20als%20w%C3%A4re%20die%20Kontrolle%20%C3%BCber%20den%20Tab-Import%20f%C3%BCr%20Excel-Tabellen%20eine%20n%C3%BCtzliche%20JMP-Verbesserung.%20Ich%20fand%20diese%20Anfrage%20auf%20der%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2Fquot-Import-Multiple-Files-quot-improvement-suggestion%2Fidi-p%2F184615%22%20target%3D%22_self%22%3E%20JMP-Wunschliste%3C%2FA%3E%20-%20Geben%20Sie%20ihm%20ein%20gro%C3%9Fes%20Lob%20und%20vielleicht%20sehen%20wir%20diese%20Verbesserung%20in%20JMP%20in%20Zukunft!%3C%2FP%3E%0A%3CP%3EIn%20der%20Zwischenzeit%20haben%20Ihre%20oben%20genannten%20JMP-Kollegen%20eine%20nette%20JSL-L%C3%B6sung%20bereitgestellt%2C%20die%20Ihnen%20weiterhilft.%3C%2FP%3E%0A%3CP%3EAm%20besten%2C%3C%2FP%3E%0A%3CP%3EJeff%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-383330%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Wie%20kann%20ich%20Excel-Tabellen%20importieren%2C%20die%20beim%20Import%20in%20JMP%20auf%20den%20Namen%20der%20Excel-Arbeitsmappe%20verweisen%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-383330%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EDanke%20Wendy%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-383312%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Wie%20kann%20ich%20Excel-Tabellen%20importieren%2C%20die%20beim%20Import%20in%20JMP%20auf%20den%20Namen%20der%20Excel-Arbeitsmappe%20verweisen%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-383312%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EWendys%20Antwort%20zeigt%20eine%20einfache%20M%C3%B6glichkeit%2C%20die%20Quellspalte%20hinzuzuf%C3%BCgen%2C%20w%C3%A4hrend%20der%20Import%20mehrerer%20Dateien%20erstellt%20wird.%3C%2FP%3E%0A%3CP%3EDie%20Verwendung%20von%20Files%20in%20Directory()%20zum%20Abrufen%20der%20Dateien%20und%20das%20anschlie%C3%9Fende%20Einlesen%20einer%20Datei%20nach%20der%20anderen%20in%20einer%20einfachen%20For()-Schleife%2C%20wobei%20jede%20Datei%20die%20Spalte%20hinzuf%C3%BCgt%2C%20wie%20Wendy%20es%20dargestellt%20hat%2C%20ist%20ein%20sehr%20einfacher%20Ansatz.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-383303%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Wie%20kann%20ich%20Excel-Tabellen%20importieren%2C%20die%20beim%20Import%20in%20JMP%20auf%20den%20Namen%20der%20Excel-Arbeitsmappe%20verweisen%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-383303%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EJeff%2C%3C%2FP%3E%3CP%3EDer%20Import%20mehrerer%20Dateien%20verf%C3%BCgt%20%C3%BCber%20die%20Funktion%2C%20die%20ich%20ben%C3%B6tige%20und%20die%20Sie%20hervorgehoben%20haben%20(f%C3%BCgen%20Sie%20eine%20Dateinamenspalte%20hinzu%2C%20die%20ich%20ben%C3%B6tige%2C%20da%20der%20Name%20jeder%20Arbeitsmappe%20das%20Datum%20enth%C3%A4lt%2C%20z.%20B.%20%E2%80%9E04%2F21-Metriken%E2%80%9C).%20Wenn%20ich%20jedoch%20den%20Import%20mehrerer%20Dateien%20verwende%2C%20erhalte%20ich%20nur%20das%20erste%20Blatt%20jeder%20Arbeitsmappe%20zur%C3%BCck%20und%20ich%20ben%C3%B6tige%20das%20dritte%20Blatt%20in%20jeder%20Arbeitsmappe.%20Gibt%20es%20eine%20M%C3%B6glichkeit%2C%20das%20dritte%20Blatt%20aus%20jeder%20Arbeitsmappe%20mithilfe%20des%20Imports%20mehrerer%20Dateien%20abzurufen%3F%20Ich%20habe%20ungef%C3%A4hr%2020%20Arbeitsmappen.%3C%2FP%3E%3CP%3EUmgekehrt%2C%3C%2FP%3E%3CP%3E%C3%9Cber%20Datei%2F%C3%96ffnen%20kann%20ich%20aus%20jeder%20Arbeitsmappe%20das%20richtige%20Arbeitsblatt%20(Blatt%203)%20aufrufen.%20Jetzt%20habe%20ich%20also%2020%20des%20richtigen%20Arbeitsblatts%2C%20kann%20aber%20nicht%20sagen%2C%20von%20welchem%20Datum%20sie%20stammen%2C%20da%20diese%20Methode%20keine%20Option%20zum%20Erstellen%20einer%20Quellspalte%20bietet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDanke%3C%2FP%3E%3CP%3EFiona%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-382913%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Wie%20kann%20ich%20Excel-Tabellen%20importieren%2C%20die%20beim%20Import%20in%20JMP%20auf%20den%20Namen%20der%20Excel-Arbeitsmappe%20verweisen%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-382913%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F16121%22%20target%3D%22_blank%22%3E%40fionaweston%3C%2FA%3E%20Wie%20importieren%20Sie%20diese%20Bl%C3%A4tter%3F%20Der%20Mehrfachdateiimport%20verf%C3%BCgt%20%C3%BCber%20ein%20Kontrollk%C3%A4stchen%20zum%20Hinzuf%C3%BCgen%20von%20Dateinamen%20zu%20einer%20Spalte%2C%20die%20der%20endg%C3%BCltigen%20Datentabelle%20hinzugef%C3%BCgt%20wird.%20Sie%20k%C3%B6nnen%20eine%20%C3%A4hnliche%20Datentabellenspalte%20erstellen%2C%20wenn%20Sie%20Dateien%20mithilfe%20der%20Concatenate-Plattform%20manuell%20verketten.%20Der%20Dateiname%20f%C3%BCr%20jedes%20importierte%20Blatt%20ist%20der%20Titel%20der%20Datei%2C%20der%20Ihrer%20Beschreibung%20zufolge%20den%20Dateizeitstempel%20enthalten%20sollte.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202021-05-06%20at%209.51.35%20AM.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Screen%20Shot%202021-05-06%20at%209.51.35%20AM.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Screen%20Shot%202021-05-06%20at%209.51.35%20AM.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F32655i0F159F6A60A66052%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Screen%20Shot%202021-05-06%20at%209.51.35%20AM.png%22%20alt%3D%22Screen%20Shot%202021-05-06%20at%209.51.35%20AM.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20399px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20399px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F32653i285BFB73C91C50EF%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-382893%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Wie%20kann%20ich%20Excel-Tabellen%20importieren%2C%20die%20beim%20Import%20in%20JMP%20auf%20den%20Namen%20der%20Excel-Arbeitsmappe%20verweisen%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-382893%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EHallo%2C%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F16121%22%20target%3D%22_blank%22%3E%20%40fionaweston%3C%2FA%3E%20.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAngenommen%2C%20Sie%20verwenden%20JSL%20zum%20Importieren%20der%20Daten%2C%20k%C3%B6nnten%20Sie%20den%20Dateinamen%20(oder%20einen%20beliebigen%20Teil%20des%20Dateinamens)%20in%20einer%20Variablen%20speichern%2C%20die%20zum%20F%C3%BCllen%20einer%20neuen%20Spalte%20verwendet%20werden%20k%C3%B6nnte.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Efilepath%20%3D%20%22%24SAMPLE_IMPORT_DATA%2FTeam%20Results.xlsx%22%3B%0Afile%20%3D%20Word(%20-2%2C%20filepath%2C%20%22%2F.%22%20)%3B%3CBR%20%2F%3E%0Adt%20%3D%20Open(%0A%20filepath%2C%0A%20Worksheets(%20%22Grouped%20Team%20Results%22%20)%2C%0A%20Use%20for%20all%20sheets(%201%20)%2C%0A%20Concatenate%20Worksheets(%200%20)%2C%0A%20Create%20Concatenation%20Column(%200%20)%2C%0A%20Worksheet%20Settings(%0A%20%201%2C%0A%20%20Has%20Column%20Headers(%201%20)%2C%0A%20%20Number%20of%20Rows%20in%20Headers(%201%20)%2C%0A%20%20Headers%20Start%20on%20Row(%203%20)%2C%0A%20%20Data%20Starts%20on%20Row(%204%20)%2C%0A%20%20Data%20Starts%20on%20Column(%201%20)%2C%0A%20%20Data%20Ends%20on%20Row(%200%20)%2C%0A%20%20Data%20Ends%20on%20Column(%200%20)%2C%0A%20%20Replicated%20Spanned%20Rows(%201%20)%2C%0A%20%20Replicated%20Spanned%20Headers(%200%20)%2C%0A%20%20Suppress%20Hidden%20Rows(%201%20)%2C%0A%20%20Suppress%20Hidden%20Columns(%201%20)%2C%0A%20%20Suppress%20Empty%20Columns(%201%20)%2C%0A%20%20Treat%20as%20Hierarchy(%200%20)%2C%0A%20%20Multiple%20Series%20Stack(%200%20)%2C%0A%20%20Import%20Cell%20Colors(%200%20)%2C%0A%20%20Limit%20Column%20Detect(%200%20)%2C%0A%20%20Column%20Separator%20String(%20%22-%22%20)%0A%20)%0A)%3B%0A%20%0Adt%20%26lt%3B%26lt%3B%20New%20Column(%20%22Workbook%20Name%22%2C%20Character%2C%20Set%20Each%20Value(%20file%20)%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EAlternativ%20k%C3%B6nnen%20Sie%20die%20gew%C3%BCnschten%20Informationen%20auch%20automatisch%20direkt%20in%20die%20Excel-Datei%20einf%C3%BCgen.Sehen%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Finsert-the-current-excel-file-name-path-or-worksheet-in-a-cell-186833c6-c899-4912-a14c-240c2eb51e0b%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3E%20In%20diesem%20Beitrag%20finden%20Sie%20Anweisungen.%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHoffentlich%20hilft%20das.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-382617%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EBetreff%3A%20Wie%20kann%20ich%20Excel-Tabellen%20importieren%2C%20die%20beim%20Import%20in%20JMP%20auf%20den%20Namen%20der%20Excel-Arbeitsmappe%20verweisen%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-382617%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EDie%20Open()-Funktion%20zum%20%C3%96ffnen%20von%20Excel-Arbeitsmappen%20verf%C3%BCgt%20%C3%BCber%20ein%20Element%20namens%20%E2%80%9EWorksheets%E2%80%9C%2C%20das%20innerhalb%20des%20%C3%96ffnens%20festgelegt%20werden%20kann.Unten%20wurde%20der%20Eintrag%20%E2%80%9EQuelle%E2%80%9C%20f%C3%BCr%20eine%20Arbeitsblatteingabe%20in%20JMP%20entnommen.Es%20zeigt%20den%20Namen%20des%20einzulesenden%20Arbeitsblatts%20an%3C%2FP%3E%0A%3CP%3EArbeitsbl%C3%A4tter(%20%22Sheet1%22%20)%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EOpen(%0A%20%22%24DOCUMENTS%2FDiscussion%20Group%2FData%20wrangling%20.xlsx%22%2C%0A%20Worksheets(%20%22Sheet1%22%20)%2C%0A%20Use%20for%20all%20sheets(%201%20)%2C%0A%20Concatenate%20Worksheets(%200%20)%2C%0A%20Create%20Concatenation%20Column(%200%20)%2C%0A%20Worksheet%20Settings(%0A%20%201%2C%0A%20%20Has%20Column%20Headers(%201%20)%2C%0A%20%20Number%20of%20Rows%20in%20Headers(%201%20)%2C%0A%20%20Headers%20Start%20on%20Row(%201%20)%2C%0A%20%20Data%20Starts%20on%20Row(%202%20)%2C%0A%20%20Data%20Starts%20on%20Column(%201%20)%2C%0A%20%20Data%20Ends%20on%20Row(%200%20)%2C%0A%20%20Data%20Ends%20on%20Column(%200%20)%2C%0A%20%20Replicated%20Spanned%20Rows(%201%20)%2C%0A%20%20Replicated%20Spanned%20Headers(%200%20)%2C%0A%20%20Suppress%20Hidden%20Rows(%201%20)%2C%0A%20%20Suppress%20Hidden%20Columns(%201%20)%2C%0A%20%20Suppress%20Empty%20Columns(%201%20)%2C%0A%20%20Treat%20as%20Hierarchy(%200%20)%2C%0A%20%20Multiple%20Series%20Stack(%200%20)%2C%0A%20%20Import%20Cell%20Colors(%200%20)%2C%0A%20%20Limit%20Column%20Detect(%200%20)%2C%0A%20%20Column%20Separator%20String(%20%22-%22%20)%0A%20)%0A)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
fionaweston
Level III

How can I import excel sheets that will reference the Excel workbook name when they are imported to JMP

I have a bunch of excel files, about 2 years worth, which are compiled monthly. I would like to import a sheet from each workbook into JMP. Unfortunately the date timestamp is only referenced in the title of each workbook and not anywhere on the sheets that I want to import. Is there a anyway to have the workbook title imported with the sheet?

Thanks

10 REPLIES 10
fionaweston
Level III

Re: How can I import excel sheets that will reference the Excel workbook name when they are imported to JMP

Awesome!

Recommended Articles