skills.rest
microsoft
microsoftOFFICIAL
Explore all skills by this author →
Website𝕏@OpenAtMicrosoftGitHub

add-excel

Add the Excel Online (Business) connector to a Power Apps code app.

483|135|Updated May 8, 2025
Search Tags:#excel#data integration#connector#sharepoint#onedrive#power apps#code app
One-click install
npx skills add https://github.com/microsoft/PowerAppsCodeApps --skill add-excel
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: add-excel
Source: https://github.com/microsoft/PowerAppsCodeApps/tree/main/plugin/power-apps-plugin/skills/add-excel
Command: npx skills add https://github.com/microsoft/PowerAppsCodeApps --skill add-excel

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill enables seamless integration of Excel workbooks as data sources within Power Apps code apps, allowing for efficient reading and writing of data.

Core Features & Use Cases

  • Add Excel Connector: Integrates Excel Online (Business) as a data source.
  • Data Operations: Supports reading and writing data to Excel tables.
  • Use Case: Connect your Power App to an Excel file stored in OneDrive or SharePoint to display inventory levels or update customer records directly from the app.

Quick Start

Use the add-excel skill to add an Excel Online (Business) connector for the workbook named 'SalesData.xlsx' located in your OneDrive.

Frequently Asked Questions about add-excel

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I connect Excel to Power Apps code apps?▼

To connect Excel to Power Apps code apps, you add the Excel Online (Business) connector to your project. This integration enables reading and writing data directly to specified tables within Excel files.

Can I use an Excel file stored in OneDrive or SharePoint with Power Apps?▼

Yes, you can use Excel files stored in OneDrive or SharePoint with Power Apps. The Excel Online (Business) connector accesses workbook data directly from these cloud storage platforms.

What do I need to configure the Excel Online connector in Power Apps?▼

Configuring the Excel Online connector in Power Apps requires a specific connection ID and the target table name. These parameters link your code app to the correct workbook data for operations.

How does data integration work between Power Apps and Excel tables?▼

Data integration between Power Apps and Excel tables works through the Excel Online connector. It facilitates efficient reading and writing operations, allowing your app to display or update records directly.

Does the Excel connector support writing data back to the workbook?▼

Yes, the Excel connector supports writing data back to the workbook. It enables both reading and writing operations to specified tables, allowing you to update customer records or inventory levels directly.

When should I use the Excel Online connector for my Power Apps data source?▼

Use the Excel Online connector when you need seamless integration of Excel workbooks as data sources within Power Apps code apps. It is ideal for scenarios requiring efficient reading and writing of tabular data.

Related Skills

Explore More Software Engineering Skills→
promitduttapromitdutta

add-excel

Add Excel Online (Business) connector to Power Apps code apps via PAC CLI.

Community
Intermediate
xukrutdonutxukrutdonut

excel

Read, write, format, merge, and export Excel workbooks to CSV, JSON, or Markdown.

Community
Intermediate
ArtisanClarinetsArtisanClarinets

nextjs-app-router

Architect Next.js 16 App Router apps with route groups and security patterns.

Community
Advanced
promitduttapromitdutta

add-datasource

Automate adding data sources and connectors to Power Apps code apps.

Community
Basic