How do I create a new spreadsheet in Zoho Sheet? Any sample codes?
To create a new spreadsheet, please leave the "content" or "url" parameter in the Edit API request as blank. Zoho Sheet will create a new spreadsheet by default if no content is provided in the Edit request.
HTML Sample Code:
<form method="POST" action="https://sheet.zoho.com/sheet/officeapi/v1/spreadsheet" target="_self" accept-charset="UTF-8">
<input type="hidden" name="apikey" value="423s*****">
<input type="hidden" name="mode" value="normaledit">
<input type="hidden" name="filename" value="New Spreadsheet">
<input type="hidden" name="lang" value="en">
<input type="hidden" name="id" value="1 138859911">
<input type="hidden" name="format" value="xlsx">
<input type="submit" name="submit" value="Create New Spreadsheet">
</form>
Curl Sample Code:
curl -X POST \
-H 'content-type: multipart/form-data; boundary=----WebKitFormBoundary7MA4YWxkTrZu0gW' \
-F apikey=423s***** \
-F 'editor_settings={'\''language'\'':'\''en'\'','\''country'\'':'\''IN'\''}' \
-F 'permissions={'\''document.export'\'':true,'\''document.print'\'':true,'\''document.edit'\'':true}' \
-F 'callback_settings={'\''save_format'\'':'\''xlsx'\'','\''save_url'\'':'\''https://zylker.com/save.php/'/''}' \
-F 'document_info={'\''document_name'\'':'\''New Spreadsheet'\'', '\''document_id'\'':138859911}' \
-F 'user_info={'\''display_name'\'':'\''Keri'\''}'
You can also build and test create new spreadsheet requests right from your browser with Office Integrator Postman Collection.