EditGrid Developer Portal

Documentation / Web API

Methods

auth

cell

revision

sheetObject

list

user

workbook

worksheet

workspace

create
get

Entities

API Method

cell.setInput

Set an input value to a list of cells (as more convenient method over cell.set)

Authentication

Requires a valid session key obtained from calling auth.getSessionKey, passed as parameter "s" (HTTP-RPC) or "sessionKey" (SOAP) to authenticate your call.

Parameters

Name	Type	Req
workbook	string	*	The id or full path of the workbook.
range	string	*	The range of cells to be set, acceptable formats are Sheet1!A1, Sheet1!A:A, Sheet1!A1:A2, Sheet1!R1C1, Sheet1!R1C1:R2C2.
input	string	*	The input value, which is to be set to all cells in range.

Request Body

This method requires no request body.

Return Value

Cell[] The list of updated cells.

SOAP Example

CellSetInputRequest req = new CellSetInputRequest();
req.sessionKey = sessionKey;
req.worksheet = "/user/demouser/Book1/Sheet1";
req.range = "A1:B1";
req.input = "Hello World";

service.doCellSetInput(req);

For enquiries, please contact cs@editgrid.com , or visit our user forum .