Get the Column values by passing column name

Get the Column values by passing column name

Posted by: mohitsinghal15 on 21 April 2018, 6:22 am EST

• 

  mohitsinghal15

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 21 April 2018, 6:22 am EST

  I am opening excel file using spread js. I have column E and row 19 then can i get the value by just passing the E19

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 23 April 2018, 8:41 am EST

  Hi Mohit,

  With Spread.Sheets both getValue() and getText() functions expect the row,column and sheet area as parameters bydefault. Spread. You would need to manually convert “E19” to respective row and column index and then call getValue() method to retrieve value from the cell.

  Thanks,
  
  Deepak Sharma