Namespace System.Integration.Excel

Codeunit

Name	Summary
Codeunit System.Integration.Excel."Edit in Excel"	This codeunit provides an interface to running Edit in Excel for a specific page.
Codeunit System.Integration.Excel."Edit in Excel Workbook"	This codeunit provides an interface to create workbooks using the Excel Add-in.
Codeunit System.Integration.Excel."Edit in Excel Filters"	This codeunit provides an interface to create filters for Edit in Excel.

Table

Name	Summary
Table System.Integration.Excel."Edit in Excel Settings"	Contains settings for Edit in Excel.

Page

Name	Summary
Page System.Integration.Excel."Excel Centralized Depl. Wizard"	This is a wizard which guides the user through setting up their tenant for using Edit in Excel with Excel add-in installed through centralized deployments.

Enum

Name	Summary
Enum System.Integration.Excel."Edit in Excel Edm Type"	This enum specifies the OData Edm type of the fields added to excel. These should generally reflect those in the $metadata document.
Enum System.Integration.Excel."Edit in Excel Filter Collection Type"	This enum specifies whether filters for the given field are connected or disconnected In other words if the filter being added specifies "Field = a&b" (and) or "Field = a|b" (or).
Enum System.Integration.Excel."Edit in Excel Filter Type"	This enum specifies the type of filter comparison to perform with the given value. Ex. Field < 1000 is "Less Than".

Interface

Name	Summary
Interface System.Integration.Excel."Edit in Excel Field Filter v2"	This codeunit provides an interface to create a filter for a specific field for Edit in Excel.

PermissionSet

Name	Summary
PermissionSet System.Integration.Excel."Edit in Excel-Admin"
PermissionSet System.Integration.Excel."Edit in Excel - View"

Events

Name	Summary
OnEditInExcelWithStructuredFilter	This event is called when Edit in Excel is invoked, handling JSON structured filters. It also allows overriding the Edit in Excel functionality. It is however recommended to use OnEditInExcelWithFilters below if possible to avoid taking dependency on a given structure.
OnEditInExcelWithFilters	This event is called when the Edit in Excel system action is invoked or EditInExcel is called in this codeunit. It allows modifying filters or overriding the Edit in Excel functionality completely.