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.
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.