Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Removes the list functionality from a Microsoft.Office.Interop.Excel.ListObject control.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Syntax
'Declaration
Sub Unlist
void Unlist()
Remarks
This method removes the list functionality from the native Excel Microsoft.Office.Interop.Excel.ListObject object but does not affect the Microsoft.Office.Tools.Excel.ListObject host control; the generated code for the control remains in the project.
After you use this method, the range of cells that made up the list will be a regular range of data.
Running this method leaves the cell data, formatting, and formulas in the worksheet. The Total row is also left intact. This method removes any link to a Microsoft Windows SharePoint Services site. AutoFilter and the Insert row are also removed from the list.
.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.