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)

Syntax

'Declaration
Sub UpdateChanges ( _
    iConflictType As XlListConflict _
)

void UpdateChanges(
    XlListConflict iConflictType
)

Parameters

• iConflictType
  Type: Microsoft.Office.Interop.Excel.XlListConflict
  XlListConflict . Conflict resolution options.

Remarks

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

Examples

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 Sub ListObject_UpdateChanges()
        Me.customerListObject.UpdateChanges( _
            Excel.XlListConflict.xlListConflictDialog)
    End Sub

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

.NET Framework Security

• Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

See Also

Reference

ListObject Interface

Microsoft.Office.Tools.Excel Namespace