Perl -CGI -Excel

siddheshsawant has asked for the wisdom of the Perl Monks concerning the following question:

Hello Monks !!!!!

I am doing a project in perl and I want a helpful suggestion from you guys...I am working on the project in which a user will enter his choice .Depending on his choices a perl script (which is already written) will gather a data from the database. Now I want to write the output of that script in an excel file(In short I wanna generate an excel file with an output of API script).

So which modules from the CPAN would be helpful for that to achieve this? Also if possible suggest me some good articles to understand the concept of generating a Excel file with the help of Perl Script !!!

Thanks in advance !!!

Comment on Perl -CGI -Excel

Replies are listed 'Best First'.
Re: Perl -CGI -Excel by ahmad (Hermit) on Jun 03, 2010 at 15:26 UTC
Spreadsheet::WriteExcel	[reply]
Re: Perl -CGI -Excel by sierpinski (Chaplain) on Jun 03, 2010 at 15:39 UTC
For future reference, CPAN has a Search Page which does a pretty good job at finding modules based on keywords like 'excel' or 'spreadsheet'. It's an excellent place to start. Then, if you have problems implementing those modules, post what code you have already tried (along with error messages/warnings/etc) and what your expected and actual outputs are, and you'd be surprised how quickly the helpful and knowledgeable monks here can speed you along on your path to Perl enlightenment!	[reply]
Re: Perl -CGI -Excel by CountZero (Bishop) on Jun 03, 2010 at 15:44 UTC
Have a look at Spreadsheet::WriteExcel or Spreadsheet::WriteExcel::Simple. The documentation of these modules is very comprehensive, so go through it and if things remain unclear come back here with more specific questions. CountZero A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James	[reply]
Re: Perl -CGI -Excel by kbarker (Initiate) on Jun 03, 2010 at 15:35 UTC
Spreadsheet::WriteExcel is the module you want. Here is a link to some examples http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.37/lib/Spreadsheet/WriteExcel/Examples.pm	[reply]
Re: Perl -CGI -Excel by ww (Archbishop) on Jun 04, 2010 at 01:19 UTC
After reviewing your forty-three previous nodes, it is, IMO, time for you to start using Super Search, Google, and a lot more native effort. This question, like many you've posted, could be answered by applying rudimentary skills and minimal effort. While assisting others is a very basic element here at the Monastery, your lack of effort distracts the monks from other, more meritorious (and -- for a newcomer-- less easily answered) questions.	[reply]