cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
New to using JMP? Hit the ground running with the Early User Edition of Discovery Summit. Register now, free of charge.
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar
fionaweston
fionaweston
Level III

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

Created: May 5, 2021 05:16 PM  |  Last Modified: Jun 10, 2023 4:29 PM (3083 views)

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
fionaweston
Level III

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

May 13, 2021 12:42 AM (457 views)  |  Posted in reply to message from Jeff_Upton 05-12-2021
Awesome!
0 Kudos