从 PowerApps 连接到 ExcelConnect to Excel from PowerApps

Excel

Excel 类似一种连接。Excel is kind of a connection. 在应用中显示 Excel 数据:To display Excel data in your app:

  1. 将 Excel 数据设置为表格格式Format the Excel data as a table.
  2. 在云存储帐户(例如 Box、Dropbox、Google Drive、OneDrive 和 OneDrive for Business)中存储 Excel 文件。Store the Excel file in a cloud-storage account, such as Box, Dropbox, Google Drive, OneDrive, and OneDrive for Business.
  3. 连接到云存储帐户,然后将 Excel 表格作为数据源添加。Connect to the cloud-storage account, and then add the Excel table as a data source.
  4. 通过自动生成应用或添加和配置控件等内容,在应用中显示此信息。Display this information in your app by generating an app automatically or by adding and configuring, for example, a Gallery control.

备注

在用户从 PowerApps 连接到 Excel 表后,PowerApps 会立即新建 _PowerAppsId_**** 列,并且 Excel 表的每一行都有唯一 ID。Once you connect to your Excel table from PowerApps, PowerApps will create a new column called _*PowerAppsId_*, with a unique ID for each row of your Excel table.

云存储连接概述中介绍了如何添加连接、将 Excel 表格作为数据源添加以及在应用中使用 Excel 数据。Overview of the cloud-storage connection shows you how to add the connection, add an Excel table as a data source, and use the Excel data in your app.

有关如何连接到其他数据类型的信息,请参阅 PowerApps 的连接列表For information about how to connect to other types of data, see the list of connections for PowerApps.

已知的限制Known limitations

若要了解如何在组织内共享 Excel 数据,请查看这些限制For information about how to share Excel data within your organization, review these limitations.