Analyze a Worksheet Range
Read Excel workbook [item ID] in [drive ID], worksheet [name], range A1:F100. Summarize [analysis question] using the headers and identify missing values.
excel
Excel AI Employee
Leina connects to Excel to help you analyze worksheet data, add table rows, and write formulas. Ask in your team chat. Leina does the work and brings back the result.
Connect Excel, choose what to share, and hand off your first task.
Leina + Excel Example Result
You
In my order workbook, worksheet Orders, add formulas to E2:E10 that multiply the quantity in B by the unit price in D for each row. The workbook item ID is [item ID].
Leina
I added the line-total formulas to Orders!E2:E10. Each formula uses the quantity and unit price from its row.
Excel · Formulas added
Order line totals
Nine formulas written to the selected range.
- Range
- Orders!E2:E10
- Calculation
- E2 = B2 × D2; subsequent rows use their own quantity and price.
What Is a Excel AI Agent?
An Excel AI agent helps read worksheet data and explain calculations. It can add table rows, update specified cells, and write formulas into a connected workbook.
You specify the source and the destination. Leina uses the content available to your connection and returns the result for you to review.
Excel
Excel is Microsoft’s spreadsheet application for workbooks, tables, and calculations.
-
Identify the order workbook
Specify Orders and the quantity, price, and total columns.
-
Build the formulas
Use each row’s quantity and unit price.
-
Write nine formulas
Update Orders!E2:E10 with the row-specific calculations.
-
Review the totals column
Check the formulas and their calculated values in Excel.
What to Ask Leina to Do with Excel
Copy a prompt, add your details, and send it to Leina in your connected team chat.
Add Rows to a Table
Add these rows [values in column order] to table [table name or ID] in Excel workbook [item ID], drive [drive ID]. Append them after existing rows.
excel
Update a Selected Range
Set worksheet [name], range D2:D4 in Excel workbook [item ID] to [three status values]. Keep other cells unchanged.
excel
Add Calculation Formulas
In Excel workbook [item ID], worksheet [name], set E2:E10 to formulas multiplying the B and D values in each row.
excel
Your next Excel task can start with a message.
Connect. Ask. Get the Result.
Tell Leina what you need in your team chat. Include the source, destination, and expected result.
-
Connect Your Account
Connect the tools involved and give Leina access to the content it needs.
-
Try a Task
Share the source material, say where the result belongs, and describe what you need.
-
Check the Result
Review the result and any changes in the connected app.
Put Leina to Work in Excel
Hand off these everyday tasks to your AI employee.
Create Workbook
Create a new .xlsx workbook file and optionally populate worksheets and data.
Search Files
Search workbook files in the current OneDrive drive and return matching drive items.
List Drive Item Children
List direct child drive items for a folder or the drive root.
Create Session
Create an Excel workbook session for subsequent workbook operations.
Get Workbook
Read workbook metadata and optionally expand related workbook resources.
List Worksheets
List worksheets in a workbook.
Get Worksheet
Read a single worksheet by worksheet name or worksheet ID.
Add Worksheet
Add a new worksheet to a workbook.
Update Worksheet
Update worksheet metadata such as the name, position, or visibility.
Delete Worksheet
Delete one worksheet from a workbook.
Get Range
Read one worksheet range by A1-style address.
Get Worksheet Used Range
Read the used range for one worksheet.
Update Range
Update one worksheet range with values, formulas, formats, or visibility flags.
Clear Range
Clear one worksheet range.
Insert Range
Insert one worksheet range and shift existing cells to make space.
Merge Cells
Merge cells inside one worksheet range.
Sort Range
Apply a Microsoft Graph sort definition to one worksheet range.
List Tables
List workbook tables, optionally restricted to one worksheet.
Add Table
Create a new workbook table from an address range.
Update Table
Update table metadata such as the name, style, or header flags.
Convert Table To Range
Convert a workbook table back into a plain worksheet range.
List Table Rows
List rows for one workbook table.
Add Table Row
Add one or more rows to a workbook table.
Delete Table Row
Delete one row from a workbook table by row index.
List Table Columns
List columns for one workbook table.
Get Table Column
Read one workbook table column by column name or column ID.
Add Table Column
Add one column to a workbook table.
Delete Table Column
Delete one column from a workbook table.
Apply Table Filter
Apply a Microsoft Graph filter criteria object to one table column.
Clear Table Filter
Clear the current Microsoft Graph filter on one table column.
Apply Table Sort
Apply a Microsoft Graph sort definition to one workbook table.
More Tools for Your AI Employee
Connect the Apps your work depends on, and give Leina the context to carry the task forward.
Keep the Conversation Moving. Let Leina Pick Up the Work.
Hand off a task while your team is discussing it. Leina uses your connected tools and brings the result back to the conversation.
See How Leina Works in SlackLeinaExample Result I added the line-total formulas to Orders!E2:E10. Each formula uses the quantity and unit price from its row.
Order line totals
Excel + Leina: Your Questions, Answered
What do I provide for a cell task?
Provide the workbook item ID, drive if needed, worksheet name or ID, and an A1-style range such as A1:F100.
Can I write formulas?
Yes. Range updates support values and formulas. Explain which cells should contain formulas and which should contain plain values.
Can I experiment without saving changes?
Create a non-persistent workbook session and use it for subsequent operations when you want changes to remain temporary.
Make Leina Your Excel AI Employee
Start with one task you already need to do. Tell Leina what a finished result should look like.
Connect Excel, choose what to share, and hand off your first task.