topic how to import multiple excel files sheets with subfolder/file name/sheet name lables with "JMP import multiple files function" ? in Discussions

how to import multiple excel files sheets with subfolder/file name/sheet name lables with "JMP import multiple files function" ?

SeanJYsh — Thu, 03 Mar 2022 02:20:26 GMT

Is there a way to import multiple excel files with more than one sheets in each excel files ? additionaly, is it possible set subfolder name of each excel files,file names and sheet names as labels ?

Attachments are the raw data and file path for simulation.

thanks!

Re: how to import multiple excel files sheets with subfolder/file name/sheet name lables with "JMP import multiple files function" ?

txnelson — Thu, 03 Mar 2022 07:33:37 GMT

the Multiple File Import() function handles all of your questions except for placing the complete file path(subfolder name). It can only add the file name as a column value.

Re: how to import multiple excel files sheets with subfolder/file name/sheet name lables with "JMP import multiple files function" ?

SeanJYsh — Tue, 08 Mar 2022 00:18:36 GMT

Got it,Thanks!