Spreadsheet

Webix JS
#1

Hi,

How can I check whether data is available/pasted in the spreadsheet or not?

https://webix.com/snippet/834aa72d

#2

Hello,
Please, could you clarify your use-case?
You want to check is the data have already changed or data availability in the cell?

#3

I want to check the data availability in the cell?

#4

I mean to check if the cell is empty or not
That’s it?

#5

Hi,

I want to add a validation on button click, in which I have to check the data availability in particular spreadsheet.

So is there any way by which I can check such data length in spreadsheet?

#6

Hello,
If you want it for the whole Spreadsheet, it’s better to call the serialize method which returns all the available data.

$$("ssheet").serialize().data returns an array of data, which you can check whether it is empty or not. If the Spreadsheet contains more than one sheets, this method will serialize data in the currently displayed sheet.

If you want to check all sheets, the implementation will look like
$$("ssheet").serialize({sheets:true}).
You will get all data from all the sheets and can iterate it to check data availability.

And, finally, there’s a getCellValue method which returns the value of the cell by its row and column.