By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,851 Members | 1,410 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,851 IT Pros & Developers. It's quick & easy.

Manipulating Excel Using Perl.

P: 2
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.
Mar 19 '08 #1
Share this Question
Share on Google+
2 Replies


nithinpes
Expert 100+
P: 410
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,charts & filtering) can be done using Perl.

Have a look at Spreadsheet::Writeexcel .
Mar 19 '08 #2

P: 2
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.
Mar 19 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.