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