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

Get the content of a particular sheet by its sheet name of a public workbook.

Request URL :

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

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

Response fields

Field	Description
sheetContent	Gets the content of a sheet by its sheet name. Other parameters include name, rows and cols.
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 XML response for the above method:

<?xml version="1.0" encoding="UTF-8" ?>
<response uri="/api/public/xml/content/15265000000006067/sheet-name:Temperature%20Converter">
<result>
    <workbookContent>
      <sheetContent index="1" name="Temperature Converter" rows="12" cols="4">
        <row index="4">
          <cell index="2" dataType="string">Temperature Converter</cell>
        </row>
        <row index="6">
          <cell index="2" dataType="string">Enter Celsius degree here ==></cell>
          <cell index="3" dataType="float" value="0">0</cell>
          <cell index="4" dataType="string">°C</cell>
        </row>
        <row index="7">
          <cell index="2" dataType="string">Fahrenheit degree will be ==></cell>
          <cell index="3" formula="=(C6*1.8+32)" dataType="float" value="32">32</cell>
        <cell index="4" dataType="string">°F</cell>
        </row>
        <row index="8">
          <cell index="2" dataType="string">Kelvin degree will be ==></cell>
          <cell index="3" formula="=(C6+273.15)" dataType="float" value="273.15">273.15</cell>
          <cell index="4" dataType="string">°K</cell>
        </row>
        </sheetContent>
    </workbookContent>
</result>
</response>

Equivalent JSON response

{
"response":
   {
        "uri": "/api/public/json/content/15265000000006067/sheet-name:Temperature%20Converter",
        "result":
        {
           "workbookContent":
            {
                "sheetContent":
                [
                    {
                        "index":"1",
                        "name":"Temperature Converter",
                        "rows":"12",
                        "cols":"4",

                        "row":

                        [
                         {"index":"4",
                        "cell":
                    [{"index":"2","dataType":"string","_content":"Temperature Converter"}]
                         },

                         {"index":"6",
                        "cell":
                    [
                           {"index":"2","dataType":"string","_content":"Enter Celsius degree here ==>"},
                           {"index":"3","dataType":"float","value":"0","_content":"0"},
                           {"index":"4","dataType":"string","_content":"°C"}
                        ]
                         },

                         {"index":"7",
                        "cell":
                    [
                           {"index":"2","dataType":"string","_content":"Fahrenheit degree will be"},
                           {"index":"3","formula": =(C6*1.8+32)","dataType":"float",value="32", "_content":"32"},
                           {"index":"4","dataType":"string","_content":"°F"}
                        ]
                         },
                         {"index":"8",
                        "cell":
                    [
                           {"index":"2","dataType":"string","_content":"Kelvin degree will be"},
                           {"index":"3","formula":=(C6+273.15)","dataType":"float","value":"273.15", "_content":"273.15"},
                           {"index":"4","dataType":"string","_content":"°K"}
                        ]
                         }

                       ]
                    }

                ]
             }
         }
    }
}

Errors

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