Microsoft Graph Excel API Skill

Overview

This skill documents elegant patterns for working with Excel files in SharePoint using the Microsoft Graph API with ky HTTP client. It covers session management, reading/writing data, applying cell formatting (colors, fonts, alignment), handling file locks, and performance optimization for batch operations.

Key Topics:

• Session management with persistent changes
• Reading and writing cell values
• Applying cell formatting (fill colors, fonts, alignment, borders)
• Performance optimization for bulk operations
• Error handling and file lock detection

Setup

Required Packages

{
  "dependencies": {