SpreadsheetLauncher Control

Applies to: SharePoint Foundation 2010

An ActiveX control that enables a user to import lists from spreadsheets, or to verify whether a compatible spreadsheet application is available for list export in Microsoft SharePoint Foundation.

Remarks

This control is defined in the OWSSUPP.dll file, a dynamic-link library (DLL) that is installed in the %ProgramFiles%\Microsoft Office\Office14\ directory on the client computer during Microsoft Office 2010 Setup.

To instantiate this control, use the following function in ECMAScript (JavaScript, JScript):

var obj = new ActiveXObject(' SharePoint.SpreadsheetLauncher.2');

In Microsoft Visual Basic Scripting Edition (VBScript), use the following to instantiate the control:

Set obj = CreateObject(' SharePoint.SpreadsheetLauncher.2')

In both cases, the argument is the programmatic identifier (ProgId) of the control, SharePoint.SpreadsheetLauncher.2. For more information, see <ProgID> Key.

Note

In the context of an application whose version is earlier than Microsoft Office 2003, 1 is used as the version number.

In SharePoint Foundation, when a user clicks Export to Excel on the List Tools ribbon on a page that contains a list, the EnsureSSImporter function in INIT.js is called to verify that a version of the control is present on the client. Then the ExportList function in OWS.js is called to export the list.