getRow method not working

getRow method not working

Posted by: tedin_uriburu on 25 October 2019, 2:49 pm EST

• 

  tedin_uriburu

  • Post Options:
  • Link
    Copy

  Posted 25 October 2019, 2:49 pm EST

  Is getRow method still available? or has it been replaced?

  I am just doing:

  sheet.getRow(1)

  and I get sheet.getRow is not a function

  Thanks,

• 

  tedin_uriburu

  • Post Options:
  • Link
    Copy

  Posted 25 October 2019, 4:30 pm EST

  Same issue with getColumn(index) so I am doing something wrong or the sintax changed. Thanks.

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 28 October 2019, 8:41 am EST

  Hi,

  We are working on this case and will get back to you soon.

  Regards
  
  Sharad

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 30 October 2019, 12:55 am EST

  Hi,

  getRow()/getColumn() methods were removed in v10. Please use the getRange() method instead. Please refer to the following code snippet:

  // get row
  sheet.getRange(rowIndex, -1, rowCount, -1);
  // getColumn
  sheet.getRange(-1, colIndex, -1, colCount);
  

  API references:
  
  getRange: http://help.grapecity.com/spread/SpreadSheets12/webframe.html#SpreadJS~GC.Spread.Sheets.Worksheet~getRange.html

  You could refer to the following document for a complete list of changes in the API:
  
  http://help.grapecity.com/spread/SpreadSheets12/webframe.html#APIUIChanges.html

  Regards
  
  Sharad

• 

  tedin_uriburu

  • Post Options:
  • Link
    Copy

  Posted 30 October 2019, 2:21 pm EST

  Good, I will try and post here how it goes, thanks!

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 3 November 2019, 11:46 pm EST

  Please take your time and let us know if you face any issues.