Opening Excel Files

These procedures describes how to get an Excel sheet using the First Edition Excel Book.

This reference documentation is for the Legacy Microsoft Excel book. Refer to the latest version here.

Syntax

open a sheet at {the file | "<url>"} where
  the worksheet is "{name}"

📘 Local Excel Files

If you want to open a local Excel file with these actions, you will encounter a Question prompting you to Please Provide File. Your local Excel file can be uploaded here by selecting the Upload files method.

Question: Please Provide File for Upload

Inputs

1. {the file | "<url>"}: (one is required)

• the file: Use the phrase the file to upload a local Excel file.

• "<url>": The URL to be opened, as a quoted string. Kognitos cannot open files from private cloud drives, so ensure the file is publicly accessible, configured with the necessary access permissions, or use a presigned URL with an expiration date for temporary access.

1. name: The name of the worksheet within the Excel workbook. (optional)

Examples

1. Using the file

open a sheet at the file

2. Using a public URL

open a sheet at "https://onedrive.live.com/spreadsheet1.xlsx"

3. Using the file and specifying the worksheet name

open a sheet at the file where
  the worksheet is "Sheet1"

4. Using a public URL and specifying the worksheet name

open a sheet at "https://onedrive.live.com/spreadsheet1.xlsx" where
  the worksheet is "Sheet1"