SpreadJS: Send modified rows to server

SpreadJS: Send modified rows to server

Posted by: spreadjsuser on 8 September 2017, 9:55 am EST

• 

  spreadjsuser

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 8 September 2017, 9:55 am EST

  I have a spreadjs sheet which typically will contain 200 columns and 100 rows.
  
  After user completes editing and clicks on a button (eg: Save), I want to get

  1. row level data for the modified rows (with all columns or range of columns) in an array of object

  row[0] = {id:1,name:ProductName1,price:10, qty:400,rating:5}
  
  row[1] = {id:5,name:ProductName5,price:45, qty:100,rating:4}
  
  row[2] = {id:65,name:ProductName65,price:3, qty:10,rating:5}

  or
  
  2) cell level data with column index / header grouped by rows with rowindex
  
  row[0] ={rowIndex:10,price:10}
  
  row[1] = {rowIndex:43, qty:22}
  
  row[2]= {rowIndex:68, price:10, qty:20}

  or
  
  3) any easier way to identify modified cells (with it row and column identifier) and send to server it one shot

  Please provide a sample implementing this

  Note:
  
  Version used:

  Spreadjs is integrated with asp.net mvc application.
  
  Trial version is being used and this is the key deciding factor to purchase the product.
  
  Response at the earliest would be appreciated.

  Thank you

• 

  reeva

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 9:55 am EST

  Hello,

  Please have a look at this sample, it should be of great assistance to you:-

  http://spread.grapecity.com/Demos/JS/TutorialSample/#/samples/dirtyItems

  Thanks,
  
  Reeva

• 

  apphelpdesk

  • Post Options:
  • Link
    Copy

  Posted 30 November 2018, 6:02 am EST

  Hi Reeva,

  I am unable to identified the modified rows in server side . we are using following methods

  
         let json: string = JSON.stringify(this.sheet.toJSON());
         let insertedRows = this.sheet.getDirtyCells();
        let deletedRows = this.sheet.getDeletedRows();
  
  

  please look into and update me.

  Thanks
  
  Manoj