Viewing Spreadsheet

Purpose 

To view a spreadsheet in Zoho Sheet editor.

HTTP Request URL

https://sheet.zoho.com/sheet/remotedoc.im

Request Parameters

ParameterData TypeDescription
Mandatory Parameters
apikeyStringUniquely identifies the web application in which the Sheet editor is integrated.
content

or

url
File

or

String
Method of providing the input file depending on its location.

content - if the input file is from your local drive or desktop.

url - if the input file is from a publicly accessible Web URL.
modeStringDefines the access privilege of the user while opening the spreadsheet in Sheet editor.
view - Spreadsheet opens in view or read-only mode for the user.
Optional Parameters
langStringEnables the Sheet editor interface to open in different languages.
Default value: en (English)

 

Viewing Spreadsheet - Error Codes

CodeDescription
2831Mandatory parameter(s) missing.
2890Invalid API key
2891The specific URL request is incorrect.

For a full list of error handling cases in Viewing Spreadsheet, refer here.

Sample Request:

Copiedcurl --request POST \
  --url 'https://sheet.zoho.com/sheet/remotedoc.im?apikey=1ee6127ff93882de82599eacc2668023' \
  --header 'content-type: multipart/form-data; boundary=----WebKitFormBoundary7MA4YWxkTrZu0gW' \
  --form content=@/Users/username/Spreadsheets/Sample.xlsx \
  --form mode=view \
  --form lang=en

Sample Response:

CopiedRESULT=TRUE
URL=https://sheet.zoho.com/sheet/editor.do?
doc=d55ce7a40befa74f501a88646e84769d8370b12883da6d9c9539af282a869ede6f75603ca2c557c013ad9f9b1f992cbdd233e36e3b19a7b655e352d0a8e6f27b&lang=en