1. Home
  2. Forum
  3. React - EJ 2
  4. How to add dynamically insert data to spreadsheet?

How to add dynamically insert data to spreadsheet?

Hi
Is there any example for  insert data (row, cell) to spreadsheet component?
thanks

5 Replies 1 reply marked as answer
MV Madhan Venkateshan Syncfusion Team June 25, 2020 10:49 AM UTC

Hi Ali, 
 
Good day to you. 
 
You can use ‘updateCell’ method to insert the data for a cell, please refer the below sample link. 
 
 
Regards, 
Madhan V 


Marked as answer
ML Marius Leustean May 24, 2022 07:09 PM UTC

Hi Madhan,


I had the same need and the solution you provided works good.

However, I noticed a small issue in the Stackblitz example: 

- when the active cell is `A1`and update button is clicked -> the text displayed in the Formula bar is not updated at the same time as the cell content - it is only updated when the active cell changes.


Can you please help me with a solution to update the text in the Formula bar at the same as the cell content?


Thanks!


SP Sangeetha Priya Murugan Syncfusion Team May 25, 2022 04:03 PM UTC

Hi Marius,


We need to validate more on your reported issue, so we will update you the further details on May 27th, 2022.


Regards,

Sangeetha M


SP Sangeetha Priya Murugan Syncfusion Team May 27, 2022 11:57 AM UTC


Hi Marius,


We have checked your reported issue and confirmed this as defect and the fix will be available in our June 15th, 2022 patch release, we appreciate your patience until then. You can track the status of this defect using below link from our feedback portal, 


Feedback Portal Link:  https://www.syncfusion.com/feedback/35194/formula-bar-not-refreshed-while-using-updatecell-method


Disclaimer: “Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works re prioritization.”


However, we suggest you to use resize method to refresh the formula bar until then. Please find the sample link below.


Sample Link: https://stackblitz.com/edit/react-yzkb5f-x6artp?file=package.json,index.js


Regards,

Sangeetha M


SP Sangeetha Priya Murugan Syncfusion Team June 16, 2022 10:27 AM UTC

Hi Marius,


We are glad to announce that our weekly patch release (20.1.60) is rolled out. And we have included the fix for the reported issue in this release. So, kindly upgrade your package versions to the latest to avail of these changes (20.1.60).


Package: https://www.npmjs.com/package/@syncfusion/ej2-react-spreadsheet


Feedback link:  https://www.syncfusion.com/feedback/35194/formula-bar-not-refreshed-while-using-updatecell-method


Please let us know if you need further assistance on this.


Regards,

Sangeetha M


Loader.
Up arrow icon