Dowload APIs
Zoho Sheet's list of download APIs allows you to download the workbooks (both
private and public) in various formats. The formats currently supported by
download apis are:
- xls
-
xlsx
- ods
- sxc
- pdf
- html
- csv
- tsv
All you need to do is enter the request URIs in your
browser address bar along with authentication parameters (apikey,ticket) and a
dialog box will pop up that will prompt you to save or open the workbook in
various formats.
Example : http://sheet.zoho.com/api/private/xls/download/[bookId]?apikey=[apikey]&ticket=[ticket]
The
list of download API URL's and their description is tabulated
below:
Download URLs
Request URIs
|
Description
|
api/private/xls/download/[bookId]
|
Download the workbook[bookid] as
xls (Excel 97-2003 file format) |
| api/private/xlsx/download/[bookId] | Download the workbook[bookid] as
xlsx (Excel file format)
|
| api/private/ods/download/[bookId] | Download the workbook[bookid] as ods (OpenDocument format) |
api/private/sxc/download/[bookId]
|
Download the workbook[bookid] as
sxc (OpenOffice format)
|
api/private/pdf/download/[bookId]
|
Download the workbook[bookid] as
pdf (Portable Document Format)
|
| api/private/html/download/[bookId] | Download the workbook[bookid] as html (HyperText Markup Language) |
| api/private/csv/download/[bookid] | csv download for the first sheet of
workbook[bookId] (Comma Separated Values) |
api/private/tsv/download/[bookid]
|
tsv download for the first sheet of
workbook[bookId] (Tab Separated Values)
|
api/private/csv/download/[bookId]/[sheetIndex]
|
csv download for a specific sheet by passing
index value
|
api/private/csv/download/[bookId]/sheet-name:[name]
|
csv download for a specific sheet by sheet
name
|
api/private/csv/download/[bookId]/[sheetindex]/[range]
|
csv download for a specific cell range by
sheet index value
|
api/private/csv/download/[bookId]/sheet-name:[name]/[range]
|
csv download for a specific cell range by
sheet name
|
Similarly, to download all the
public workbooks available in Zoho Sheet in various formats, just replace the
word "private" with "public" in the request URL.
Example -
api/public/xls/downlad/[bookId] request
uri will download the public workbook in xls format.
Note: Downloading shared
workbook is not supported as of now
