Using the New Excel Wizard to Import Data in JMP® 11 for Windows
Brian Corcoran, Director of Software Development for JMP Host Group, SAS
There is a lot of valuable data stored in Excel file formats. Unfortunately, this data is often formatted in ways that makes it difficult to use in JMP. The new Excel Import Wizard in JMP 11 for Windows aims to alleviate the pain of the import process. It provides a preview mechanism and a variety of options for specifying the shape of the data. Even if there are different settings for different worksheets within a workbook, the wizard can help. Import settings are retained to make fetching fresh data simple. This session will explore all of the options of the wizard and demonstrate the flexibility it provides through scripting, as well.