Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.
Juggernaut

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

Mike Tubman
in FileMaker Pro 2023

Featured Replies

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

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?

  • Author
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.

Create an account or sign in to comment

https://fmforums.com/topic/109857-can-i-import-from-a-specific-worksheet-within-an-excel-file/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.