Skip to main content

Integration guideOffice add-in

Microsoft Excel

Neil reviews and edits the workbook you have open, once you accept edits.

Illustration of a seal beside a laptop showing a data table and an evidence binder linked by a red thread.

Microsoft Excel and NeilOffice add-in

Neil reads
The workbook you connect
Writes back
Edits you accept
Source of truth
Your file, saved in Office
Set up
Install Neil from Office’s add-in store
Neil › Formula review
draft

Review the formulas in this sheet and tell me which cells each one reads.

Neil

  • I’ll read the cells and formulas in the workbook you connected. The connection is read-only, so nothing in the file changes until you accept edits.
Reads
The workbook you connect
Returns
  • Each formula and the cells it reads
  • Formulas to check, and why
  • Questions for the sheet’s owner
Illustrative work with Microsoft Excel: a request to Neil, the source it reads and the draft it returns for your review.

1What’s connected.

Connect the workbook you have open to Neil with Neil for Office. Neil reads cells and formulas, and once you accept edits it formats data, creates pivot summaries on new worksheets and works with native charts and tables. To import structured workbooks into Seal records, or generate reports from Seal data, set up a connection with Seal’s API or Scripts.

Connection setup and permissions

Neil for Office is one add-in for Word, Excel and PowerPoint. Install it once from Office’s add-in store, or ask your Microsoft 365 administrator to deploy it. Installing it doesn’t give access to Seal: you need a Seal account and Neil for Office enabled for your organisation.

Set up Microsoft Excel

  1. Open Excel, choose Home → Add-ins, search for Neil and choose Add. Your Microsoft 365 administrator may need to permit or deploy the add-in.
  2. Open Neil from Home in the workbook you want to use, paste your Seal workspace link and sign in. Open the Neil conversation in your browser and wait for Chat linked.
  3. The connection starts read-only. To let Neil change a workbook, choose Use as output for it in the browser, then Scope → Accept edits, and send a new request.

2Import fixed-layout Excel workbooks, and reject the rest.

Route

Microsoft Graph reads and changes .xlsx workbooks in OneDrive for Business or SharePoint. It does not open .xls files or workbooks in consumer OneDrive.⁠¹ An .xlsx file is a zip package of SpreadsheetML parts, with each sheet’s cells in its sheetData element.⁠²

Record identity

Table and worksheet IDs stay the same when a table or sheet is renamed, and the workbook is a drive item with an ID unique within its drive.⁠³⁴⁵ A range returns raw values, each cell’s data type and its number format code, so a percentage or a date can be told from a plain number.⁠⁶

Revisions

A drive item’s eTag changes with its metadata or content and its cTag only with content, and earlier versions can be listed and restored.⁠⁵⁷ Without a session header, changes made through Graph are saved to the file at once.⁠¹

When it fails

Writes time out or conflict
Concurrent writes to one workbook usually do not run in parallel and often cause throttling, timeouts and merge conflicts.⁠⁸ Write to a workbook from one process at a time.
A request is rejected as too large
Ranges with too many cells, and oversized payloads, are rejected and should not be resent as they are.⁠⁹ Split the range and send it in parts.
Cells hold errors
Cell errors come back as error strings among the values.⁠⁶ Reject the import and give the sender the address of each cell in error.

Check one record

Import one workbook in the agreed layout and one with a column moved. The first should create Seal records with each value and number format intact; the second should be rejected, naming the column. Keep the cTag of each file imported.

3Before it goes live.

Access

Neil uses your Seal account and reads only the documents you connect. What it reads becomes part of the conversation. Disconnect stops further access.

Changes

The connection starts read-only. Neil changes a document only after you accept edits, and it can’t save: check the change, then save the file in Office. Stop cancels a request but doesn’t undo changes already made.

Review

Review formulas, answers and document changes before relying on them, and follow your usual review and approval procedures.

Read the assurance detail →

References

  1. 1Microsoft Graph: working with Excel.
  2. 2Microsoft: structure of a SpreadsheetML document.
  3. 3Microsoft Graph: table.
  4. 4Microsoft Graph: worksheet.
  5. 5Microsoft Graph: driveItem.
  6. 6Microsoft Graph: range.
  7. 7Microsoft Graph: driveItemVersion.
  8. 8Microsoft Graph: Excel best practices.
  9. 9Microsoft Graph: Excel error handling.