ListObject.UpdateChanges Method

Updates the list on a Microsoft Windows SharePoint Services site with the changes made to the ListObject control in the worksheet.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

void UpdateChanges(
	XlListConflict iConflictType
)

Parameters

iConflictType
Type: Microsoft.Office.Interop.Excel.XlListConflict

XlListConflict. Conflict resolution options.

This method applies only to lists linked to a SharePoint site. If the SharePoint site is not available, an exception is thrown.

The following code example uses the UpdateChanges method to submit changes that were made in an existing ListObject to a Web site that is running Microsoft Windows SharePoint Services. This example assumes that the worksheet contains a ListObject named List1 that has already been published to a Web site running Microsoft Windows SharePoint Services.

This example is for a document-level customization.

private void ListObject_UpdateChanges()
{
    this.customerListObject.UpdateChanges(
        Excel.XlListConflict.xlListConflictDialog);
}

Show: