What you can do with Microsoft Excel
Every task in plain language. Pick one, and we can help you get access.
12 things you can do
Microsoft Excel
APIs for automating, integrating, and extending Microsoft Excel functionality including workbook management, data manipulation, charting, and formula execution through Microsoft Graph REST APIs.
12 multi-step recipesRecipes: multi-step jobs
Add and Retire a Table ColumnAdd a column to an Excel table, confirm the new schema, and retire the column.Append a Row to a Table
Append a single record to an Excel table and verify it was written.Build a Chart from a Data Range
Create a chart over a verified source range and confirm it was added.Calculate with a Workbook Function and Write the Result
Invoke an Excel workbook function and persist its result into a cell.Create a Worksheet and Seed It with Data
Create a worksheet and populate it with an initial block of values.Delete a Table Row by Index
Safely remove a single row from an Excel table by index.Discover Workbook Structure
Inventory the structure of an Excel workbook without modifying it.Flatten a Table into a Plain Range
Archive a table by snapshotting it and flattening it into static cells.Read, Write, and Verify a Cell Range
Read a cell range, overwrite its values in a session, and verify the result.Scratch Worksheet Lifecycle
Exercise create, get, update, and delete against a single scratch worksheet.Sort, Filter, and Total a Table for Reporting
Order, narrow, and total an Excel table in one pass.Write Through a Named Range
Write into a workbook range addressed by its defined name rather than a fixed coordinate.