How to Get all the updated cell values fom spreadJs (row number ,column number)

How to Get all the updated cell values fom spreadJs (row number ,column number)

Posted by: sanjay812 on 8 September 2017, 9:45 am EST

• 

  sanjay812

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 8 September 2017, 9:45 am EST

  how to Get all the updated cell values fom spreadJs (row number ,column number) ,
  
  and using angularjs ,i have to save and retrieve data from mongoDb…

• 

  ashishjindal

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 9:45 am EST

  Hello Sanjay,

  There is no direct way to get all the cells, however, you can refer to the following thread discussing the same:
  
  http://wijmo.com/topic/sending-spreadjs-data-to-backend/

  Regards

• 

  c1_jonc

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 9:45 am EST

  Hi Ashish,

  Is there any method which accept array as datasource for row e.g.

  var source = [1,2,3,4,5,6,7,7,‘aaa’,‘test’];

  Suppose this is my datasource and i want to set it on a specific row.

  Any method which accept it?

  Regards
  
  Anil Sharma

• 

  reeva

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 9:45 am EST

  Hello,

  We cannot bind to a specific row in SpreadJS.

  However, we can bind to specific columns as given in links below:-
  
  http://helpcentral.componentone.com/NetHelp/SpreadHClientUG/webframe.html#scbindcol.html
  
  http://helpcentral.componentone.com/NetHelp/SpreadHClientUG/webframe.html#Spread~$.wijmo.wijspread.Sheet~bindColumn.html
  
  http://helpcentral.componentone.com/NetHelp/SpreadHClientUG/webframe.html#binding.html

  Hope it helps.

  Thanks,
  
  Reeva

• 

  ithelp

  • Post Options:
  • Link
    Copy

  Posted 19 July 2018, 7:21 am EST

  Hi @Reeva,

  Even for column it expects the name of the column.(test = [{“A”:0},{B,0}])
  
  This gives very limited options to us for setting cell values.
  
  Could we not set values for column irrespective of column name ?

  something like column : {index: 0, values: [1,2,3,4,5,6,7…]}