ExcelService.SetCellA1 Method

Sets a value into a cell in the open workbook, using the Excel "A1" range specification.

Namespace:  Microsoft.Office.Excel.Server.WebServices
Assembly:  Microsoft.Office.Excel.Server.WebServices (in Microsoft.Office.Excel.Server.WebServices.dll)

Syntax

'Declaration
<WebMethodAttribute> _
Public Sub SetCellA1 ( _
    sessionId As String, _
    sheetName As String, _
    rangeName As String, _
    cellValue As Object, _
    <OutAttribute> ByRef status As Status() _
)
'Usage
Dim instance As ExcelService
Dim sessionId As String
Dim sheetName As String
Dim rangeName As String
Dim cellValue As Object
Dim status As Status()

instance.SetCellA1(sessionId, sheetName, _
    rangeName, cellValue, status)
[WebMethodAttribute]
public void SetCellA1(
    string sessionId,
    string sheetName,
    string rangeName,
    Object cellValue,
    out Status[] status
)

Parameters

  • sessionId
    Type: System.String
    The Excel Web Services session ID.
  • sheetName
    Type: System.String
    The name of the sheet you want to reference. Sheet name length is limited to 31 characters.
  • rangeName
    Type: System.String
    A range name can be a range reference, a named range, or a named data object. A rangeName string can contain a sheet name; for example, "Sheet1!A1:G17".
  • status
    Type: []
    Alert information.

Remarks

Sets a value into a workbook cell, using a range name string to select the range.

See Also

Reference

ExcelService Class

ExcelService Members

Microsoft.Office.Excel.Server.WebServices Namespace