Udostępnij za pośrednictwem


ListObject.SharePointURL Property (2007 System)

Gets the URL of the SharePoint list for a given ListObject control.

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

Syntax

'Declaration
<BrowsableAttribute(False)> _
Public ReadOnly Property SharePointURL As String
'Usage
Dim instance As ListObject 
Dim value As String 

value = instance.SharePointURL
[BrowsableAttribute(false)]
public string SharePointURL { get; }
[BrowsableAttribute(false)]
public:
property String^ SharePointURL {
    String^ get ();
}
public function get SharePointURL () : String

Property Value

Type: System.String
The URL of the SharePoint list for a given ListObject control.

Remarks

Accessing this property causes an exception to be thrown if the list is not linked to a SharePoint site.

Examples

The following code example publishes a ListObject to a Web site that is running Microsoft Windows SharePoint Services. This example assumes that there is a ListObject named customerListObject on the current worksheet, and that the ListObject is linked to a SharePoint site.

This example is for a document-level customization.

Private Sub ListObject_SharePointURL()
    Dim TargetParam As String() = {customerListObject.SharePointURL, _
        "Customers", "Customer data"}
    customerListObject.Publish(TargetParam, False)
End Sub
private void ListObject_SharePointURL()
{
    string[] TargetParam = { customerListObject.SharePointURL,
        "Customers", "Customer data" };
    customerListObject.Publish(TargetParam, false);
}

.NET Framework Security

See Also

Reference

ListObject Class

ListObject Members

Microsoft.Office.Tools.Excel Namespace