Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
SetRangeA1 Method

ExcelService.SetRangeA1 Method

Sets values or formulae 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)

[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 that 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.

Sets several values (numbers or text) or formulae into a workbook range, using a range name string to select the range. Values (numbers or text) or formulae may be passed together into a range.

Setting a formula into a cell requires open item or edit item permissions and is supported in view and edit mode You will get a formula editing not enabled alert if you attempt to set a formula into a cell in view mode with only view item permission.

Setting a value or a formula into a cell replaces the previous value or formula, but does not affect the formatting of the cell. To set a cell to be empty, use Null. 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.

Show:
© 2015 Microsoft