Hi
nagaraju,
You are correct,
Spreadsheet::WriteExcel can not write to an existing Excel file. See
this article from
IBM DeveloperWorks which demonstrates how to achieve this using
Spreadsheet::ParseExcel and
Spreadsheet::WriteExcel.
An alternative may be to use
DBI with
DBD::Excel (which is based on the modules I previously mentioned). I have never used
DBD::Excel which
CPAN shows as being in
Alpha state.
Hope this helps
Update: Added '(which is based on the modules I previously mentioned)'
Martin