Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.duvo.ai/llms.txt

Use this file to discover all available pages before exploring further.

Microsoft Excel is a spreadsheet application within Microsoft 365. Connecting it to Duvo lets your assignments read, write, and analyze spreadsheet data stored in OneDrive or SharePoint, turning static workbooks into dynamic data sources for automated workflows.

​
Setup

Click Enable on the Connections page and authorize with your Microsoft account.

​
Capabilities

  • Create workbooks — Generate new Excel workbooks to store reports, logs, or structured output.
  • Manage worksheets — Add new worksheet tabs, list existing tabs, and rename them to organize data across logical sections within a workbook.
  • Read spreadsheet data — Retrieve values from workbooks stored in OneDrive or SharePoint for use in assignment workflows.
  • Update cells — Modify individual cell values to keep records current.
  • Batch update cells — Write to multiple cells in a single operation for efficient bulk data entry.
  • Append rows — Add new rows after the last occupied row in a table or range without overwriting existing content, keeping running logs and datasets growing cleanly.
  • Import from CSV — Overwrite a range of cells from a CSV file already in the assignment workspace, replacing existing data in a single operation.
  • Append rows from CSV — Add rows from a workspace CSV file onto an existing table or range, merging new records without disturbing what is already there.
  • Clear cells — Remove values, formatting, or both from one or more ranges in a single operation — useful for resetting templates or wiping stale data before a fresh run.
  • Format cells — Apply number formats when writing data — currency symbols, thousands separators, percentages, date patterns, and more — so values display correctly without manual reformatting.

​
Key Benefits

  • Central data hub — Connect assignments to the Excel workbooks your team already relies on in OneDrive or SharePoint.
  • Flexible data operations — Read individual values or batch-update hundreds of cells in a single step.
  • Real-time record keeping — Keep workbooks current with automated data entry instead of manual updates.
  • No database required — Use familiar Excel workbooks as your assignment’s data source without standing up a separate database.

​
Finding Workbooks

Assignments can open any Excel workbook you have access to — paste a URL or refer to the workbook by name, and Duvo locates the right file. Supported locations include personal OneDrive, SharePoint team sites, Microsoft Teams-connected sites, and root SharePoint libraries. Standard page links and “Copy link” share links from the Excel UI both work.

​
Works Well With

  • Microsoft Outlook — Pull data from incoming emails and log it directly into tracking spreadsheets, or send summary emails based on spreadsheet contents.
  • Microsoft SharePoint — Combine document management with spreadsheet data to maintain project dashboards and shared records in one ecosystem.
  • Microsoft OneDrive — Store and organize the workbooks your assignments read from and write to, keeping file access seamless.