Spreadsheet-WriteExcel reviews

cpanratings
 

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

Spreadsheet-WriteExcel (2.37) ****

This is just too good. We use this in our company's product and it's very helpful for dealing with excel files. Thanks to the author :)

Chankey Pathak - 2012-09-16T07:18:22 (permalink)

1 out of 2 found this review helpful. Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (2.37)

I've used this module many times for working with the Horrible Spreadsheet Format, and am always impressed by it. The interface, while perhaps not perfect, does try to make most common tasks easy. Where that isn't the case, there may be a module in the CPAN ecosystem that handles things. And if not, the extensive documentation and examples probably have some advice or sample code to cadge.

Some examples:

* Unicode: just write the string with utf8, and it Just Works. (S::WE converts the data into Excel's required UTF16BE format, so you don't have to care). Really pleased with this useful attention to detail!

* Dates: this doesn't quite Just Work, but it's well documented, so you just have to make sure you issue a ->write_date_time call instead of the usual ->write.

* Formatting: S::WE::Styler lets you sensibly reuse styles. Ideally this could be merged into the release

* Autofit columns: that's a feature of the Excel client, not of the spreadsheet format. But the examples suggest how to replicate the functionality, by adding a write-handler that guesstimates and stores the maximum width for a given column.

Hakim - 2011-04-11T02:56:31 (permalink)

3 out of 3 found this review helpful. Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (2.37) *****

Allows the easy manipulation of XLS files without resorting to Microsoft technology. Superb documentation, intuitive API, functional in almost every feature.

Lee Goddard - 2011-02-09T09:45:51 (permalink)

Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (2.37) *****

Amazing utility to generate excel sheets and charts from perl!

Sujay Phadke - 2010-08-10T11:57:40 (permalink)

1 out of 1 found this review helpful. Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (2.37) *****

Slick interface, excellent examples, works great.

James R Skaggs - 2010-08-06T08:52:16 (permalink)

1 out of 1 found this review helpful. Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (2.25) *****

easy to use and lots of documentation.

Everything I needed was there and worked on my first attempt.

Philip - 2009-10-19T06:08:29 (permalink)

2 out of 2 found this review helpful. Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (2.25) *****

Excellent tool. I´m impressed with the chart addition table and have used it with no problems.
Thank you very much John!

Efren Gonzalez Armayor - 2009-09-25T06:33:35 (permalink)

1 out of 1 found this review helpful. Was this review helpful to you?  Yes No

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-16T01:50:38 (permalink)

4 out of 5 found this review helpful. 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:

svn.apache.org/repos/asf/poi/tags/REL...

(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-05T12:01:13 (permalink)

3 out of 3 found this review helpful. 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-06T02:10:54 (permalink)

2 out of 4 found this review helpful. 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-08T23:15:18 (permalink)

8 out of 8 found this review helpful. 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-25T09:11:47 (permalink)

5 out of 5 found this review helpful. Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (2.18)

Spreadsheet-WriteExcel is an excellent utility.

Karthic Somalinga - 2007-05-22T00:18:38 (permalink)

0 out of 1 found this review helpful. 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.

readparse - 2005-06-10T15:44:55 (permalink)

5 out of 6 found this review helpful. Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (2.14) ****

Keep up the good good good work!

joris - 2005-06-07T01:18:56 (permalink)

1 out of 3 found this review helpful. 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-07T00:40:15 (permalink)

3 out of 3 found this review helpful. 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!

nervenet - 2004-09-17T07:45:57 (permalink)

5 out of 5 found this review helpful. 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-28T00:38:15 (permalink)

3 out of 3 found this review helpful. 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

htoug - 2004-08-20T00:09:26 (permalink)

2 out of 2 found this review helpful. 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);
}

phil_bv - 2004-08-16T23:45:11 (permalink)

2 out of 2 found this review helpful. 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-12T19:31:21 (permalink)

3 out of 3 found this review helpful. 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-09T01:46:11 (permalink)

1 out of 1 found this review helpful. 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-10T15:38:15 (permalink)

3 out of 3 found this review helpful. 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!

toma - 2003-10-25T00:32:11 (permalink)

1 out of 1 found this review helpful. 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-17T03:35:26 (permalink)

3 out of 3 found this review helpful. Was this review helpful to you?  Yes No

Spreadsheet-WriteExcel (0.42) *****

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

gessig - 2003-09-15T08:14:07 (permalink)

1 out of 1 found this review helpful. 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!

gadfly - 2003-09-12T08:38:23 (permalink)

1 out of 1 found this review helpful. 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.

vek - 2003-08-14T17:29:29 (permalink)

2 out of 2 found this review helpful. 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-13T16:13:16 (permalink)

4 out of 4 found this review helpful. Was this review helpful to you?  Yes No