從 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. 將 Excel 檔案儲存在雲端儲存體帳戶。例如 Box、Dropbox、Google 雲端硬碟、OneDrive 及商務用 OneDrive。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 資料表中的每個資料列都會有唯一識別碼。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.