Import multiple Excel files (xlsm, xlsx, xls, etc.) with same format and combine to 1 single file

[ShawnZhang36]

Currently we can use "open multiple" to open multiple .csv Excel files with same format and combine to 1 single file, however, this function seems not applicable for other Excel format (xlsm, xlsx, xls, etc.). Besides, the import settings is also only applicable for .csv document. Can JMP make changes to support for all Excel document format?

[SamGardner]

It is possible to use Multiple File Import (File > Open Multiple on MacOS, and File > Import Multiple Files on Windows).  It will use the default preferences under the Preferences (File > Preferences on Windows, JMP>Preferences on MacOS).  

Can you share an example that describe the problem you have and the limitations you are seeing with Multiple File Import for excel files.  

[Florent_M]

Hi!

Thank you @ShawnZhang36, I have the same wish.

For the moment it is not possible to parameterize the excel import when doing a multiple import.

For example, JMP takes as header the first line automatically, without the possibility to define another line.

In my case, I have several xlsx files whose headers are on line 5. So I can't do the multiple import correctly.

The ideal would be to have an additional xlsx tab where you can make some basic settings.

Best regards,

[mia_stephens]

Thank you for this additional information @Florent_M. 

[SamGardner]

We are working on this new feature and plan to make it available in a future release of JMP.  

[hogi]

I am a bit nervous because @Ryan_Gilmore just archived a similar request:
"Import Multiple Files..." improvement suggestion 

which options will be available?
- identify worksheet by name

- identify worksheet by number

- identify several worksheets

- row with header information

- data starts at row

[DaveB]

The goal was been to update Multiple File Import so there is a custom import settings panel for excel files that will contain most of the options in the Excel Import Wizard.  Some of the options in the wizard are for the preview pane so will not be applicable.  Worksheet names are the other important option supported by the wizard that might not be added to Multiple File Import.  A new column with the source worksheet name is planned which should help.  I think that it might be possible to add a text input field to allow manual entry of a list of worksheet names or names with the * and ? wildcard characters.  Is identifying by worksheet number a high priority or would a list of names with wildcards suffice? 

[hogi]

@DaveB, a list of names with wildcards is wonderful.

Together with the alternative (=current) option to import the "first" worksheet: quite sufficient.

Such settings

will be available for MFI Excel import as well?

[DaveB]

Yes, the plan is for those settings (has headers, first header line,...) to be available and they should be in the first EA for 18.0 when it is released.  We will try to get the worksheet names into a later EA.

[JMPinthePool]

Could we not have a preview pane for multiple file import (especially for excel files) showing the first file selected/in the list? It's highly likely that the files selected for multiple file import will be consistent format, but that format is usually defined by equipment vendors, and varies from instrument to instrument. So like @Florent_M, it would be great if we could define start/end rows and columns and sheets for the data we want to import and ideally stack. 

[hogi]

Thanks - works nicely.