I have requirement where I will load data into spreadsheet and edit,add,delete rows on same spreadsheet.
Now I want to validate only those changed records by sending them as a json object to my api.
Can I read only changed record from spreadsheet and convert as json object? Can you please help me here?
Hello and thank you for contacting Infragistics,
If you are using our built-in validation then you can hook the editModeValidationError event.
eg.
Also, the workbookDirtied event might help you.
Thank you for the reply. Can we convert workbook as Json object ?
You can use this tool. I believe someone at Infragistics built this about a year ago.
https://excel2json.io/
This is considered to be a new product idea and previously discussed here:
www.infragistics.com/.../545468
Thanks for your reply. I am not looking for any tool. I have loaded data from API to spreadsheet referring below URL
https://es.infragistics.com/products/ignite-ui-angular/angular/components/spreadsheet-overview.
I have done some add, delete, update on this spreadsheet.
Now I want to convert above workbook as json and want to send back to my API
for ex: convert to json( this.spreadsheet.workbook)