AnsweredAssumed Answered

Scripted Excel Import with variable file name - specify worksheet

Question asked by fmdataweb on Sep 18, 2018
Latest reply on Sep 19, 2018 by steve_ssh

I'm importing from the 2nd worksheet of an Excel file into my FileMaker table - everything works fine when I select the file and specify the worksheet to import manually.

 

I'm now trying to script this process and use a variable - $file - as the file to imported, but each time I run the script it reverts to using the first worksheet not the 2nd one. Have tried a number of times by adding the file as a file path and running the script which works fine, then replace the filepath with a variable and it always starts importing from the first worksheet again.

 

I saw a few similar reports of this dating back many years on this forum but nothing to indicate this has been resolved when using a variable for the file path - anyone know if this is still the case?

Outcomes