AnsweredAssumed Answered

Import excel file with more sheets

Question asked by josh84 on Oct 26, 2017
Latest reply on Oct 26, 2017 by philmodjunk

Hi I would like to ask if anyone knows how to import excel with more than 1 sheet.

 

As far as we know if we specify the file you want to import from in the Import Records script step  you should be prompted with a dialog asking what worksheet you want to import from and that becomes part of the script step. 

 

Import Records [No dialog; Source: "TestFile.xlsx"; Worksheet: "Sheet3";]

Import Records [No dialog; Source: "TestFile.xlsx"; Worksheet: "Sheet1";]

Import Records [No dialog; Source: "TestFile.xlsx"; Worksheet: "Sheet2";]

 

therefore we would like to do the same without giving the file...Anyone knows if there's a way to dp the same using variable to specify the file and the worksheet??

 

Im using FM16

 

Outcomes