Skip to main content


serializes data of spreadsheet into a JSON object

serialize: () => any[] | IDataWithStyles;


A serialized JSON object.


var data = spreadsheet.serialize();

Serialized data presents an object with the following attributes:

  • formats - an array of objects with number formats
  • styles - an object with the applied CSS classes
  • sheets - an array of sheet objects. Each object contains the following attributes:
    • name - the sheet name
    • data - an array of data objects
    • rows - an array of height objects
    • cols - an array of width objects

Related articles

Data loading and export