getRowData returns undefined

Hello,

I have a spreadsheet with data on the first 4 rows. This is in the 1st and only sheet in the spreadsheet.

I call getRowData as followed and the function returns undefined

this.spreadsheet.getRowData(2,0);

2 is the row index I want, so the 3rd row. It has data in it. 0 is for the index of the 1st and only sheet.

What I am doing wrong here? Thanks,

John


3 Replies

SP Sangeetha Priya Murugan Syncfusion Team May 16, 2023 01:56 PM UTC

Hi Jean,


The getRowData method returns the row data in object format properly in our end. Please find the below sample link, in this we have returns the row data using the getRowData method in a console window using the external button click action. Please find the sample link below.


Sample Link: https://stackblitz.com/edit/hqc7ia?file=index.html,index.ts


Could you please check the above sample and replicate your issue in the above link and send it back to us. Based on that we will be able to check and provide you with a better solution quickly.



JR Jean-Luc Robitaille May 16, 2023 02:51 PM UTC

Thanks for the reply.

I am doing basically the same thing as in your example. But it is not working on my side. I am using an older version of the package, so there might be a bug in my version. 

@syncfusion/[email protected]



SP Sangeetha Priya Murugan Syncfusion Team May 17, 2023 10:58 AM UTC

Hi Jean,


We have modified the sample with your reported version and the getRowData method return the values properly in our end. Please find the link below.


Sample Link: https://stackblitz.com/edit/hqc7ia-2i1zgb?file=index.html,package.json,index.ts


And we suspect that your sample level customization may affect the functionality. So, please share your rendering and customization codes. And replicate your issue in the above sample and send it back to us. Based on that we will be able to check and provide you with a better solution quickly.


Loader.
Up arrow icon