API Home >> Sheet >> API Reference >> content

Get the public content of a range of sheet with sheet name.

Request URL :

XML : http://sheet.zoho.com/api/public/xml/content/[BookID]/sheet-name:[name]/[range]?apikey=[API Key]

JSON :http://sheet.zoho.com/api/public/json/content/[BookID]/sheet-name:[name]/[range]?apikey=[API Key]

-- Range for example can be a cell range [A1:C10], a cell [A1], an entire column [A], an entire row [1], columns A through D [A:D], rows 2 to 7 [2:5].

-- R1C1 range format will be supported later. Moreover getting content of shared workbook is not support as of now.

Response fields

Field	Description
range	Gets the content of a particular range with the specified sheet name. [range] can be A1:C10(a cell range) , A1(a cell), A(an entire column), 1(an entire row), A:C(columns A through C), 2:5(rows 2 to 5).
row	Identifies a particular row with the index number and subsequent cell values in that row.
cell	Gets content of each cell specific to each cell index. Other parameter may include dataType, value, formula etc.

Sample Response

The following is the sample response for the above method:

<?xml version="1.0" encoding="UTF-8" ?>
<response uri="/api/public/xml/content/15265000000006057/RGBConverter/B">
<result>

    <range rows="15" cols="1">
         <row index="6">
        <cell index="1" dataType="string">Color Converter - RGB to Hex</cell>
    </row>
      <row index="9">
        <cell index="1" dataType="string">Red</cell>
          </row>
      <row index="10">
        <cell index="1" dataType="string">Green</cell>
         </row>
      <row index="11">
        <cell index="1" dataType="string">Blue</cell>
          </row>
      <row index="15">
        <cell index="1" dataType="string">Enter RGB Values in the 'Number' column</cell>
          </row>
    </range>

</result>
</response>

Equivalent JSON response

{
"response":
   {
        "uri": "/api/public/json/content/15265000000006057/RGBConverter/B",
        "result":
        {
           "range":
           [
            {
                  "rows":"15",
                "cols":"1",

                "row":

                [
                    {"index":"6",
                   "cell":
                    [{"index":"1","dataType":"string","_content":"Color Converter - RGB to Hex"}]
                    },

                    {"index":"9",
                   "cell":
                    [{"index":"1","dataType":"string","_content":"Red"}]
                    },

                    {"index":"10",
                   "cell":
                    [{"index":"1","dataType":"string","_content":"Green"}]
                    },

                    {"index":"11",
                   "cell":
                    [{"index":"1","dataType":"string","_content":"Blue"}]
                    },

                    {"index":"15",
                   "cell":
                    [{"index":"1","dataType":"string","_content":"Enter RGB Values in the 'Number' column"}]
                    }

                  ]
            }
           ]
        }
    }
}

Errors

Displaying content of a sheet range with a sheet name may return general error with HTTP error code of 2851.