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.