November 5, 2008
用perl 讀取Excel (xls)檔案的方法
在windows下產生 unix 格式的檔案,並且存成utf8 格式
觀看全文...
use strict;
use Win32::OLE;
my $Excel = Win32::OLE->new('Excel.Application','Quit');
my $xlsfn = Win32::GetFullPathName("LANG_CHINESE.xls");
my $Book = $Excel->Workbooks->Open($xlsfn) or die "please assign file.";
my $working_sheet_1 = 1;
my $Sheet = $Book->Worksheets($working_sheet_1);
foreach my $row (2..3000)
{
next unless defined $Sheet->Cells($row,1)->{'Value'};
my $string_id = $Sheet->Cells($row,1)->{'Text'};
my $eng_str = $Sheet->Cells($row,2)->{'Text'};
my $cht_str = $Sheet->Cells($row,3)->{'Text'};
#display to screen
printf "%s %s %s\n",$string_id,$eng_str,$cht_str;
}
$Excel->Quit;
$Book = 0;
$Excel = 0;在windows下產生 unix 格式的檔案,並且存成utf8 格式
觀看全文...

































































