Can I import from a specific worksheet within an excel file?

[Mike Tubman]

Hello All,

I am running Filemaker 2023 on a windows 10 machine. I need to import from an excel file (xlsx) but the sheet has multiple worksheets within it. I need to be able to import from a specific sheet through scripting. It will be a weekly report and the worksheet name will change. Is this possible using a path variable?

Thanks in Advance

Mike

[comment]

AFAIK, the worksheet name must be hard-coded into the Import Records script step. Maybe possible using a plugin?

BTW, if the worksheet name can change then what determines which sheet is the correct one?

[Mike Tubman]

8 minutes ago, comment said:

BTW, if the worksheet name can change then what determines which sheet is the correct one?

The sheets are dates, the script asks the user which date they want to import and the plan was to format that date in a variable.

I wouldn't mind leaving the dialog on if it only asked about the worksheet. but I don't trust the users with the actual import screen.