excel_analysis
Analyze Excel workbooks by computing statistics, generating pivot summaries, validating data, and identifying used ranges to extract actionable insights.
Instructions
Analyze data in Excel workbooks (statistics, pivot tables, data validation)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| itemId | No | Excel file item ID | |
| itemPath | No | Alternative: Excel file path | |
| siteId | No | SharePoint site ID (optional) | |
| site | No | Known SharePoint site alias or canonical URL | |
| siteUrl | No | Canonical SharePoint site URL (optional alternative to siteId) | |
| driveId | No | Drive ID for a specific document library (optional) | |
| analysisType | Yes | Type of analysis to perform | |
| worksheet | No | Worksheet name | Sheet1 |
| range | No | Cell range to analyze (optional, uses used range if not specified) |