ExcelService.SetRangeA1 Method
Sets values into a range 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 SetRangeA1 ( _
sessionId As String, _
sheetName As String, _
rangeName As String, _
rangeValues 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 rangeValues As Object()
Dim status As Status()
instance.SetRangeA1(sessionId, sheetName, _
rangeName, rangeValues, status)
[WebMethodAttribute]
public void SetRangeA1(
string sessionId,
string sheetName,
string rangeName,
Object[] rangeValues,
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".
- rangeValues
Type: []
Array of values for the range being set.
- status
Type: []
Alert information.
Remarks
Sets values into a workbook range, using a range name string to select the range.
If a null object value is passed, the respective cell value will be cleared.
If the dimensionality of the array of values does not exactly match that of the range, the call will be aborted and will return an error.