OpenDocuments.ViewInExcel Method

This content is outdated and is no longer being maintained. It is provided as a courtesy for individuals who are still using these technologies. This page may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

Queries Excel Web Services relative to the specified Web site URL to retrieve an Excel stream and opens the stream in a spreadsheet application.

expression.ViewInExcel(SiteUrl As String, FileName As String, SessionId As String, Cmd As String, Sheet As String, Row As Long, Column As Long, varProgID)

Parameters

expression

An expression that returns an OpenDocuments Control object.

SiteUrl

A string that contains the URL of the Web site that hosts the Excel Web Service from which to retrieve data.

FileName

A string that contains the name to give the file in which to open the stream. If SessionId is not specified, FileName can be either a URL that is relative to SiteUrl, or an absolute URL that specifies the path to the file to open the server stream.

SessionId

A string that contains the session ID of the currently opened file, or an empty string if the workbook is not open and a URL is passed.

Cmd

A string that contains the command to execute on the workbook on the server.

Sheet

A string that contains the name of the active sheet.

Row

A Long that specifes the active row.

Column

A Long that specifies the active column.