How to read excel template file and replace a text finded in handsontable

Tags: #<Tag:0x00007f51c7309c40>
#1

I have a excel file like this

excel.PNG1428×67 6.52 KB

and i am reading excel file data and displaying it in handsontable

447405B0.PNG1358×735 34.5 KB

Now my issue is if i replace the value of Last Name/Entity Name as shown in image as test it should replace this value in excel sheet also how to achieve it.

#2

Hey @chethanbv.10

why do you refer to Excel? Are you doing export-to-file operation? Can you share any demo?

#3

I am able to read the excel sheet now those source column are coming from excel sheet header only now i need to update those values

#4

Once you change anything in the table you need to generate a new Excel file. There is no way to update the current one. If you want to generate the new file you can attach the export-to-file option to the afterChange hook.

#5