User Community
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: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.
  • JMP will suspend normal business operations for our Rest and Recharge Day on Friday, October 2, 2026.
    Regular business hours will resume on Monday, October 5, 2026.

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
Choose Language Hide Translation Bar

Excel import - named ranges

Status: New Submitted by on ‎02-21-2018 05:23 AM
Comment

In  case there are named ranges in Excel sheets it would be good if those could be accessed when importing data into JMP.

I have workbooks containing data in named ranges and want to automate data import. The only way i have so far is to script some "search algorithm" to find the boundaries of the named range or using additional software tools like R or Excel-VBA.