Hi Sridhar,
Its in the Global sheet.
The whole process is
1.2 scripts picks up(import) the xls file
2.Updates it
3.stores it at the different time(exports to the same loc and same file name).
the script which stores the datatable at the later time is actually replacing the old xls file . This is the pronblem .
what i need is something wherein the xls gets updated with preserving the existing data in it.
The approach i think is to read the xls first before saving any update and write to it with pervious data (which is read) with the new data.
pls suggest as i feel this is bit complicated approach.
Thanks,
Pradeep
Its in the Global sheet.
The whole process is
1.2 scripts picks up(import) the xls file
2.Updates it
3.stores it at the different time(exports to the same loc and same file name).
the script which stores the datatable at the later time is actually replacing the old xls file . This is the pronblem .
what i need is something wherein the xls gets updated with preserving the existing data in it.
The approach i think is to read the xls first before saving any update and write to it with pervious data (which is read) with the new data.
pls suggest as i feel this is bit complicated approach.
Thanks,
Pradeep