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

Get the content of sheet with sheet index of a particular workbook.

Request URL :

XML : http://sheet.zoho.com/api/private/xml/content/[BookID]/[sheet index]?apikey=[API Key]&ticket=[Ticket]

JSON : http://sheet.zoho.com/api/private/json/content/[BookID]/[sheet index]?apikey=[API Key]&ticket=[Ticket]

Response fields

Field	Description
sheetContent(index)	Gets the content of a particular sheet with the specified sheet index in a workbook. 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 XML sample response for the above method:

<?xml version="1.0" encoding="UTF-8" ?>
<response uri="/api/private/xml/content/15265000000006057/2">
<result>
    <workbookContent>
      <sheetContent index="2" name="RGBConverter" rows="15" cols="5">

        <row index="6">
          <cell index="2" dataType="string">Color Converter - RGB to Hex </cell>
        </row>
        <row index="8">
          <cell index="3" dataType="string">Number</cell>
          <cell index="4" dataType="string">Float</cell>
          <cell index="5" dataType="string">Hexadecimal</cell>
        </row>
        <row index="9">
          <cell index="2" dataType="string">Red</cell>
          <cell index="3" dataType="float" value="235">235</cell>
          <cell index="4" formula="=C9/255" dataType="float" value="0.92156862">0.92</cell>
          <cell index="5" formula="=DEC2HEX(C9)" dataType="string">EB</cell>
        </row>
        <row index="10">
          <cell index="2" dataType="string">Green</cell>
          <cell index="3" dataType="float" value="61">61</cell>
          <cell index="4" formula="=C10/255" dataType="float" value="0.23992156862">0.24</cell>
          <cell index="5" formula="=DEC2HEX(C10)" dataType="string">3D</cell>
             </row>
           <row index="11">
          <cell index="2" dataType="string">Blue</cell>
                <cell index="3" dataType="float" value="60">60</cell>
                <cell index="4" formula="=C11/255" dataType="float" value="0.235294156862">0.24</cell>
        <cell index="5" formula="=DEC2HEX(C11)" dataType="string">3C</cell>
             </row>
        <row index="12">
          <cell index="5" formula="=CONCATENATE(E9;E10;E11)" dataType="string">EB3D3C</cell>
        </row>
        <row index="15">
          <cell index="2" dataType="string">Enter the RGB values in the 'Number' column above to convert it to HEX</cell>
        </row>

    </sheetContent>
    </workbookContent>
</result>
</response>

Equivalent JSON response

{
"response":
   {
        "uri": "/api/private/json/content/15265000000006057/2",
        "result":
        {
           "workbookContent":
            {
                "sheetContent":
                [
                    {
                        "index":"1",
                        "name":"RGBConverter",
                        "rows":"15",
                        "cols":"5",

                        "row":

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

                         {"index":"8",
                        "cell":
                    [
                           {"index":"3","dataType":"string","_content":"Number"},
                           {"index":"4","dataType":"string","_content":"Float"},
                           {"index":"5","dataType":"string","_content":"Hexadecimal"}
                        ]
                         },

                         {"index":"9",
                        "cell":
                    [
                           {"index":"2","dataType":"string","_content":"Red"},
                           {"index":"3","dataType":"float",value="235", "_content":"235"},
                           {"index":"4","formula":"=C9/255","dataType":"float",value="0.92", "_content":"0.92"},
                           {"index":"5","formula":"=DEC2HEX(C9)","dataType":"string", "_content":"EB"}
                        ]
                         },

                         {"index":"10",
                        "cell":
                    [
                           {"index":"2","dataType":"string","_content":"Green"},
                           {"index":"3","dataType":"float",value="61", "_content":"61"},
                           {"index":"4","formula":"=C10/255","dataType":"float",value="0.24", "_content":"0.24"},
                           {"index":"5","formula":"=DEC2HEX(C10)","dataType":"string", "_content":"3D"}
                        ]
                         },

                         {"index":"11",
                        "cell":
                    [
                           {"index":"2","dataType":"string","_content":"Blue"},
                           {"index":"3","dataType":"float",value="60", "_content":"60"},
                           {"index":"4","formula":"=C11/255","dataType":"float",value="0.24", "_content":"0.24"},
                           {"index":"5","formula":"=DEC2HEX(C11)","dataType":"string", "_content":"3C"}
                        ]
                         },

                         {"index":"12",
                        "cell":
                    [{"index":"5","formula":"=CONCATENATE(E9;E10;E11)","dataType":"string", "_content":"EB3D3C"}]
                         },

                         {"index":"15",
                        "cell":
                    [{"index":"2","dataType":"string", "_content":"Enter the RGB values in the 'Number' column above to convert it to HEX"}]
                         }

                        ]
                   }

                 ]
             }
         }
    }
}

Errors

Displaying content of a sheet with a sheet index may return general errors. Likely HTTP error codes are 2851 and 2853.