共用方式為


Excel [DEPRECATED]

Microsoft Excel is a spreadsheet developed by Microsoft. Connect to your Microsoft Excel spreadsheets in your file services like OneDrive for Business, OneDrive, Dropbox, Box, etc. You can perform various actions such as create, update, get, and delete on rows in a table.

This connector is available in the following products and regions:

Service Class Regions
Power Automate Standard All Power Automate regions except the following:
     -   China Cloud operated by 21Vianet
Power Apps Standard All Power Apps regions except the following:
     -   China Cloud operated by 21Vianet
Contact
Name Microsoft
URL Microsoft Power Automate Support
Microsoft Power Apps Support
Connector Metadata
Publisher Microsoft
Website https://products.office.com/excel

The Excel Connector currently connects to Tables only. It will insert a column called __PowerAppsId__ to the Table if there is no such column. This column is used to keep track of changes in the row.

To use this connector in Power Apps, learn more here.

This connector is deprecated in Power Automate, Logic Apps and Power Apps. Please try using the new connectors to work with Excel files: Excel Online (Business) and Excel Online (OneDrive).

LIMITS

The following are some of the limits and restrictions:

  1. Maximum number of rows and columns on a worksheet - 1048576 rows and 16384 columns

General Limits

Name Value
Maximum file size (in bytes) 2000000
Maximum number of requests being processed by the connector concurrently (per Excel file) 100

Creating a connection

The connector supports the following authentication types:

Default Parameters for creating connection. All regions Not shareable

Default

Applicable: All regions

Parameters for creating connection.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Name Type Description Required
Connection to file source connection Connection to file source True

Throttling Limits

Name Calls Renewal Period
API calls per connection 100 60 seconds

Actions

Delete row [DEPRECATED]

Deletes a row from an Excel table

Get row [DEPRECATED]

Retrieves a single row from an Excel table

Get rows [DEPRECATED]

Retrieves rows from an Excel table

Get tables [DEPRECATED]

Retrieves table names from an Excel file

Insert row [DEPRECATED]

Inserts a new row into an Excel table

Update row [DEPRECATED]

Updates an existing row in an Excel table

Delete row [DEPRECATED]

Deletes a row from an Excel table

Parameters

Name Key Required Type Description
File name
dataset True string

Excel file name

Table name
table True string

Excel table name

Row id
id True string

Unique identifier of the row to delete

Get row [DEPRECATED]

Retrieves a single row from an Excel table

Parameters

Name Key Required Type Description
File name
dataset True string

Excel file name

Table name
table True string

Excel table name

Row id
id True string

Unique identifier of row to retrieve

Returns

The outputs of this operation are dynamic.

Get rows [DEPRECATED]

Retrieves rows from an Excel table

Parameters

Name Key Required Type Description
File name
dataset True string

Excel file name

Table name
table True string

Excel table name

Top Count
$top integer

Total number of entries to retrieve (default = all).

Skip Count
$skip integer

The number of entries to skip (default = 0).

Returns

The outputs of this operation are dynamic.

Get tables [DEPRECATED]

Retrieves table names from an Excel file

Parameters

Name Key Required Type Description
File name
dataset True string

Excel file name

Returns

Represents a list of tables.

Body
TablesList

Insert row [DEPRECATED]

Inserts a new row into an Excel table

Parameters

Name Key Required Type Description
File name
dataset True string

Excel file name

Table name
table True string

Excel table name

Row
item True dynamic

Row to insert into the specified Excel table

Returns

The outputs of this operation are dynamic.

Update row [DEPRECATED]

Updates an existing row in an Excel table

Parameters

Name Key Required Type Description
File name
dataset True string

Excel file name

Table name
table True string

Excel table name

Row id
id True string

Unique identifier of the row to update

Row
item True dynamic

Row with updated values

Returns

The outputs of this operation are dynamic.

Definitions

Table

Represents a table.

Name Path Type Description
Name
Name string

The name of the table. The name is used at runtime.

DisplayName
DisplayName string

The display name of the table.

TablesList

Represents a list of tables.

Name Path Type Description
value
value array of Table

List of Tables