in reply to Loop through excel files and insert respective file name into cell within file

There are two common ways of doing this type of thing:

1) Use Spreadsheet::ParseExcel and Spreadsheet::WriteExcel as Corion suggested

2) Use Win32::OLE. There are examples for Excel automation specifically in the docs.

  • Comment on Re: Loop through excel files and insert respective file name into cell within file

In Section Seekers of Perl Wisdom