Help

FILEMAKER PRO HELP 1280
Specify Excel Data dialog box
Use the Specify Excel Data dialog box when you’re importing data from a Microsoft Excel file that
contains more than one worksheet or includes a named range.
• To import data by worksheet, select Display worksheets, select the worksheet you want to
import, then click Continue.
• To import data by named range, select Display named ranges, select the named range
you want to import, then click Continue.
Related topics
Converting a data file to a new FileMaker Pro file
Importing data into an existing file
About importing data using an HTTP request
You can import data into a FileMaker Pro file by specifying a URL as the source of the data.
FileMaker Pro supports both HTTP GET and HTTP POST requests in these dialog boxes:
• Specify XML and XSL Options (see Importing XML data)
• “Insert from URL” Options (see Insert From URL script step)
The HTTP GET and HTTP POST requests work the same way, except that an HTTP POST request
lets you send (or post) data to the web server in the message body.
To specify the type of HTTP request, use one of the following schemes in the URL:
When your URL begins with http or https, FileMaker Pro sends the URL unchanged. However,
httppost and httpspost are custom schemes defined by FileMaker
Pro and are handled differently.
When your URL begins with httppost or httpspost, FileMaker
Pro sends the URL beginning with
http:// or https:// followed by the text before the first “?” character. All the text after the first “?”
character is sent as POST data in the message body.
Example
This URL specifies a POST request and two key-value pairs:
httppost://www.filemaker.com/path?fname=Bob&lname=Smith
FileMaker Pro sends this URL:
http://www.filemaker.com/path
The text after the “?” is sent as POST data:
fname=Bob&lname=Smith
For this HTTP request type Use this scheme in the URL
GET http
https (secure HTTP)
POST httppost
httpspost (secure HTTP)