This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Using the JMP Excel Import Wizard
In JMP 12 for Mac and earlier versions of JMP for Windows, opening a Microsoft Excel file launches the Excel Import Wizard.
The W...
...alues to import/join only selected column values into the JMP table.
In the first part of this demo, Olivia imports data from different sources (Internet, database, Excel) and then joins t...
Note: Though JMP can read spreadsheet files both on Mac and Windows, with different tools than Excel, I refer in my posts to a windows machine and Excel. Some features will be related to newer v...
Have you ever experienced an issue importing data from Excel or other sources? I bet you are not alone, at least I had mine. In my previous blogs Part 1 and Part 1 cont. I showed in g...
In my previous blog post JMP and Excel - A Never ending story? - Part 1 I ended with an example importing spreadsheets with hierarchical headers and merged cells. This time I focus on i...
Excel sheets are still a common source of data. For analytical purpose JMP users know better tools, but how to make good use of JMP’s functionalities if the data is in a shape that is not e...
In this blog series about "JMP and Excel – A Never ending Story?" I spoke about importing spread sheet data, and described the first few typical challenges when importing data from s...
...ook at the spreadsheet data, it's weather data, and it is simplistic for demonstrating the concept. Attached you will find the script in the JMP Data Table and the Excel spreadsheets for the first case....
...cript:
1. Import worksheet with name of the current data table
// Read in Sheet2 of the Excel workbook
excelFile = "TransposedExcelWorksheet.xlsx";
// Get the name of the data table and n...