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".
- cellValue
Type: System.Object
Value for the cell being set.
- status
Type: []
Alert information.
Remarks
Sets a value into a workbook cell, using a range name string to select the range.