OpenForum RSS: Perl+Excel

�� (Lex)

Mon, 27 Oct 2008 08:54:11 GMT

>>>� ��
>>> use strict;
>>> use Spreadsheet::ParseExcel::SaveParser;
>>> $oBook =
>>> Spreadsheet::ParseExcel::SaveParser::Workbook->Parse('Excel/Test97.xls');
>>> my $oWs = $oBook->AddWorksheet('TEST1');
>>> $oWs->AddCell(10, 1, 'New Cell');
>>> $oBook->SaveAs('iftest.xls');
>>

� �� , �� Parse �� Spreadsheet::ParseExcel::SaveParser::Workbook, �� ... ��

� �� :
my $worksheet1 = $workbook->add_worksheet(Encode::decode('utf8','�� '));
$worksheet1->write('C'.$i++,Encode::decode('utf8',"�� "));

�� (Anton)

Fri, 19 Sep 2008 15:58:00 GMT

>[�� ]
>>� ��
>> use strict;
>> use Spreadsheet::ParseExcel::SaveParser;
>> $oBook =
>> Spreadsheet::ParseExcel::SaveParser::Workbook->Parse('Excel/Test97.xls');
>> my $oWs = $oBook->AddWorksheet('TEST1');
>> $oWs->AddCell(10, 1, 'New Cell');
>> $oBook->SaveAs('iftest.xls');
>
>��.. ��

� �� ? � �� .. �� - ��

�� (aas202)

Tue, 19 Feb 2008 08:57:53 GMT

>[�� ]
>
>http://search.cpan.org/~szabgab/Spreadsheet-ParseExcel-0.32/lib/Spreadsheet/ParseExcel/SaveParser.pm
>� ��
> use strict;
> use Spreadsheet::ParseExcel::SaveParser;
> $oBook =
> Spreadsheet::ParseExcel::SaveParser::Workbook->Parse('Excel/Test97.xls');
> my $oWs = $oBook->AddWorksheet('TEST1');
> $oWs->AddCell(10, 1, 'New Cell');
> $oBook->SaveAs('iftest.xls');

��.. ��

�� (amdk7)

Tue, 19 Feb 2008 08:56:41 GMT

�� ۣ�!
�� Spreadsheet::ParseExcel::SaveParser - Expand of Spreadsheet::ParseExcel with Spreadsheet::WriteExcel

http://search.cpan.org/~szabgab/Spreadsheet-ParseExcel-0.32/lib/Spreadsheet/ParseExcel/SaveParser.pm
� ��
use strict;
use Spreadsheet::ParseExcel::SaveParser;
$oBook =
Spreadsheet::ParseExcel::SaveParser::Workbook->Parse('Excel/Test97.xls');
my $oWs = $oBook->AddWorksheet('TEST1');
$oWs->AddCell(10, 1, 'New Cell');
$oBook->SaveAs('iftest.xls');

�� (aas202)

Tue, 19 Feb 2008 08:37:35 GMT

�� . �� VB �� Excel � �� .

�� (amdk7)

Tue, 19 Feb 2008 08:31:11 GMT

�� . �� .
�.�. � �� , � � �� , � �� .
��, �� , �.�. �� , �� .

#!/usr/local/bin/perl

use strict;
use Spreadsheet::ParseExcel;
use Spreadsheet::WriteExcel;

print "Content-type:text/html; charset=windows-1251\n\n";
print "<html>\n<head>";

print "<TITLE>��</TITLE>\n<META NAME=\"content\" CONTENT=\"text/html; charset=windows-1251\">\n";
print "</HEAD><BODY>\n";

my $excel = Spreadsheet::ParseExcel::Workbook->Parse('/home/.../file1.xls');

my $workbook = Spreadsheet::WriteExcel->new('/home/.../file2.xls');
my $worksheet = $workbook->add_worksheet();

foreach my $sheet (@{$excel->{Worksheet}}) {
printf("Sheet: %s\n", $sheet->{Na

Perl+Excel (tx2)

Fri, 17 Aug 2007 02:52:58 GMT

�� , �� OLE...
�� :
http://www.thescripts.com/forum/thread50152.html

�� ... ��, �� , �� automation �� OpenOffice/StarOffice... �� . Excel�� /��...

Perl+Excel (aas202)

Tue, 14 Aug 2007 10:20:15 GMT

>>WriteExcel �� , � ��
>>�� .
>
>�� , ��
>� �� ? ��, �� , � �� )
>�� .

�� ? �� . �� .

Perl+Excel (phpcoder)

Tue, 14 Aug 2007 10:18:46 GMT

>WriteExcel �� , � ��
>�� .

�� , �� ? ��, �� , � �� ) �� .

OpenForum RSS: Perl+Excel

��� ���������� � �������� ��������� (Lex)

��� ���������� � �������� ��������� (Anton)

��� ���������� � �������� ��������� (aas202)

��� ���������� � �������� ��������� (amdk7)

��� ���������� � �������� ��������� (aas202)

��� ���������� � �������� ��������� (amdk7)

Perl+Excel (tx2)

Perl+Excel (aas202)

Perl+Excel (phpcoder)

�� (Lex)

�� (Anton)

�� (aas202)

�� (amdk7)

�� (aas202)

�� (amdk7)