RSS | Module Info | Add a review of Spreadsheet-WriteExcel

Spreadsheet-WriteExcel (2.25)

20 minutes flat from never having used Spreadsheet::WriteExcel, to having converted a script that used to output a formatless CSV that Excel kept asking me how to parse.

The module has comprehensive documentation and examples, and was very easy to get running with. Within 20 minutes I could easily learn the gist, lookup specific information about and currency formatting, write the code and have it output exactly what I wanted.

Dan Dascalescu - 2009-04-16 01:50:38
Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (2.25)

Very useful! I found I couldn't write the HYPERLINK function, however, since it was not defined in the hash in Formula.pm. But I figured out the code for HYPERLINK and added it. I didn't have a copy of the Excel Developer's Kit but was able to find the code from the following:

https://svn.apache.org/repos/asf/poi/tags/REL_3_0_ALPHA2/jakarta-poi/src/scratchpad/src/org/apache/poi/hssf/record/formula/eval/FunctionEval.java

(code I added to line 1313 in Formula.pm:
'HYPERLINK' => [ 359, -1, 1, 0 ],
)
BTW, in case you're wondering, I used HYPERLINK instead of write_url because I wanted to write a URL that was based on a value contained in another cell, and write_url appears to not allow mixing of internal and web addresses.

R Hawk - 2008-12-05 12:01:13
Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (2.20)

Excellent Module !

Thanks to add autofilter to the release 2.20 !

Loic Dreux - 2008-02-06 02:10:54
Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (2.20)

Very good. I've used it, and it works. The various methods are handy, and just generally very easy to use, and intuitive.

No complaints here. Job well done.

Iftekharul Haque - 2007-10-08 23:15:18
Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (2.18)

Great module, it gets the job done efficiently. Keep up the good work!

Patrick LeBoutillier - 2007-07-25 09:11:47
Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (2.18)

Spreadsheet-WriteExcel is an excellent utility.

Karthic Somalinga - 2007-05-22 00:18:38
Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (2.14)

Fantastic. Very thorough and useful and the documentation is a dream come true.

John Ingram - 2005-06-10 15:44:55
Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (2.14)

Keep up the good good good work!

Joris - 2005-06-07 01:18:56
Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (2.12)

A great module that filled a need I had!

The documentation was long, but that was appropriate for the number of methods there are. I felt that it explained well the methods I needed.

I'm glad this module is there!

Philip Newton - 2005-04-07 00:40:15
Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (2.04)

I use this module since 2002, I'm a fan of this module. I use it for making monthly reports for the happy user (so they do not bother me with question on how to import a plain CSV file on Excel/OpenOffice). They get the numbers on a easy to use Excel file, preformatted and colored.

I use this module under Linux (Debian and Suse) and Windows (Active State) without problems, so actually I can run the same reports on different platforms without modification.

Documentation is very good. I wish only more examples.
The interface is easy to learn.
Overall rating is "Very Good".

Give it a try!

Javier - 2004-09-17 07:45:57
Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (2.11)

What more to ask? It takes seconds to learn the interface, another few seconds to write a test program. And if you've already got tabular fields such as SQL data, just a few more seconds to integrate into your application. A+. I use it with Spreadsheet::ParseExcel on a database project where the goal is to use Excel as the user-interface GUI.

Bryce Nesbitt - 2004-08-28 00:38:15
Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (2.04)

A *VERY* nice module for those of us who are forced to create Excel spreadsheets but want to avoid Win32

Henrik Tougaard - 2004-08-20 00:09:26
Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (2.03)

1.It's a need for generating Charts and Graphs !
2.In rest it offers a lot for generation excel files, and with good documented functions.

Some usefull functions for insert_bitmap():

sub width_pixels2excelunits {
my $pxs=$_[0];
my $exu;
if (int($pxs/12+0.7)<1) {
$exu=int($pxs/12+0.7);
} else {
$exu=int(($pxs-5)/7+0.7);
}
return ($exu);
}

sub height_pixels2excelunits {
my $pxs=$_[0];
my $exu=int($pxs*3/4+0.7);
return ($exu);
}

Bogdan Velcea - 2004-08-16 23:45:11
Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (2.03)

I'm amazed at the quality of this module. It all Just Works. It's allowed us to do amazing stuff for our customers. None of this "Just open this .csv file" crap. Bravo!

Andy Lester - 2004-08-12 19:31:21
Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (2.14)

I love it! I've used it for years, and it just gets better and better. I could not do my present job without it. It really eases automatic generation of presentation charts from voluminous output data.

Tom Browder - 2004-01-09 01:46:11
Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (0.42)

Overall it is a very good module, but it takes a lot of work to tweak if the formatting is complicated. It also requires figuring out arcane Excel speadsheet formatting codes, half experimentation and hacking and half searching through the documentation.

It would be nice to be able to generate the spreadsheet entirely in memory rather than a new file, though.

Robert Rothenberg - 2003-11-10 15:38:15
Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (0.42)

This module represents more work on the part of the author than anyone should have to do. It solves a difficult, important problem!

Tom Anderson - 2003-10-25 00:32:11
Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (0.42)

Very usefull and easy to use module.

The documentation is thorough and complete and the examples allow you to start doing simple tasks right away.

The interface is quite clean and intuitive. Even all the issues regarding dates were considered by the author.

This module saved me a lot of time by allowing the generation of excel reports in unix machines with the data of form submissions.

My thanks to the author

Cl�udio Valente - 2003-09-17 03:35:26
Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (0.42)

Greate module that lets you create Excel files even on Unix.

George Essig - 2003-09-15 08:14:07
Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (0.42)

an extremely useful module that helps keep developers on
the open source track by providing platform independence
from microsoft products. very well thought out and
written interface. and a very helpful author!

ravi - 2003-09-12 08:38:23
Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (0.41)

Another module that is used heavily here at work. Thorough documentation, nice API, easy to use. We've managed to automate a *lot* of very mundane and time consuming reporting thanks to Spreadsheet::WriteExcel.

Kevin Spencer - 2003-08-14 17:29:29
Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (0.41)

Combined with Spreadsheet::ParseExcel, this module allows dynamic interaction with Excel documents as data stores. The biggest limitation is that fields are limited to 255 characters. This prevents interaction with the full range of documents. This module provides substantial support for the appearence-oriented features of Excel docs.

Chris Dolan - 2003-08-13 16:13:16
Was this review helpful to you?  Yes No

Perl.org sites : bugs | dev | history | jobs | learn | lists | use © Copyright 2002-2009 The Perl Foundation Site Information and Contacts