Manipulating Excel Using Perl.

[danny2000]

Hi all.

Please excuse my ignorance here, but is it possible and / or efficient to do things such as insert worksheets, make charts, pivot tables, filter data in an excel workbook using Perl?

I'm trying to establish whether I have a better option than VBA.

Thanks.

[nithinpes]

Hi all.

Please excuse my ignorance here, but is it possible and / or efficient to do things such as insert worksheets, make charts, pivot tables, filter data in an excel workbook using Perl?

I'm trying to establish whether I have a better option than VBA.

Thanks.

Not sure about pivot tables. But, the other tasks(inserting worksheets,char ts & filtering) can be done using Perl.

Have a look at Spreadsheet::Wr iteexcel .

[danny2000]

Hi
Thanks for the response, but if not PERL than which programming language would be best for manipulating excel in a more efficient and flexible way than VBA?

Some have told me that ASP is the best for this? Is this right?

Thanks in advance.