Zoho Sheet
Zoho Sheet is a powerful spreadsheet editor that lets you create and edit complex spreadsheets online. With its Editor API, partners can integrate the feature-rich Sheet Editor in their Web application and work on standard Microsoft Excel and OpenOffice spreadsheets right from the web browser.
Zoho Office Integrator for Sheet supports all popular formats: .xlsx .xls .ods .sxc .csv .tsv
Table of Contents
Flowchart representation
Description
1. User opening his/her application.
2. Send a create request from your application client to the application server.
3. From user application server, a request will be sent to Create Document or other Editor API's to Zoho server.
4. We will be generating a JSON response with the document open URL in user application server.
5. User will send it back to his/her application client.
6. You can open this URL in two ways:
-> Either open it inside the user application iframe
-> Or open it a new tab - White label feature can be enabled here.
7. Once the editor is opened, user can edit the document - this task will take place in the Zoho server.
8. After editing, user needs to trigger the save.
9. When the user triggers the save, the latest edited document will be uploaded to the user application server.
If a user performs any of the below 2 functions, he/she needs to inform the other collaborators (if using Co-edit API)
11. Closes the editor.
12. When user calls Delete document or user session API's - The action will be processed and a success response will be sent back to the user application server.
Limitations:
Supported languages, file formats and file size (during import) are mentioned below;