Perl i kalkulacija u ExceluPostoji li negde opis editiranja excela preko perl skripte.
Naime konkretno, suma čelija u excelu, odnosno
čelija A1 = 4
čelija A2 = 4
e sad čelija a3 = A1 + A2
ovo je neuspeo pokušaj;
#!/usr/bin/perl -w
use strict;
use Spreadsheet::WriteExcel;
my $workbook = Spreadsheet::WriteExcel->new('unicode.xls');
my $worksheet = $workbook->add_worksheet();
$worksheet->write_number('A1', 123456);
$worksheet->write_number('A2', 2.3451);
$worksheet-> write('A3', '=SUM(A1:A2)');
poruka je:
The Parse::RecDescent module must be installed in order to write an Excel formula at C:\Perl\Vjezbe\excel_05.pl line 10
a kada koristim
use strict;
use Win32::OLE;
tada me ignorira.
molim pomoć.
Thx. Fender
Svi ljudi sve znaju !
Leon
Leon
Re: Perl i kalkulacija u Excelu