cool experience: Spreadsheet::WriteExcel;

I just want to say, if you need to do some Excel, do it with Perl!

I needed to create some excel sheets based on automatically calculated data. Instead of copying huge amount of data I fired up my IDE, issued

use Spreadsheet::WriteExcel;
use Spreadsheet::WriteExcel::Utility;

$workbook = Spreadsheet::WriteExcel->new($myExcelFile);
$worksheet = $workbook->add_worksheet($sheet);

and was ready to go.
Spreadsheet::WriteExcel has very good documentation (excellent examples included), is very complete and is really a pleasure to use.

Besides: Use Spreadsheet::WriteExcel::Utility to convert between different cell notations. A1 <-> (0, 0) and be aware that one is base 1 ("base A", respectively) and the other base 0.

Leave a comment

About :m)

user-pic I blog about Perl.