Spreadsheet component get values of all sheets

Webix JS
#1

I am using a spread sheet component in my application. I am trying to find a solution where I can get all data from a spreadsheet across all sheets. I am currently using the api $$(‘spreadsheet’).serialize() . But this does not give me data across all the sheets. It gives data only for that sheet. Please let me know if there is an api I can use.

#2

You can use

var data = sh.serialize({ sheets: true });

It will return data for all sheets.
If you need just a value of some specific cell, you can use getSheetData instead

https://docs.webix.com/api__ui.spreadsheet_getsheetdata.html

#3

Thank you so much! The solution worked.