[PerlChina] Want to get a module

Jeff Pang pangj at earthlink.net
Mon Jan 29 23:54:06 PST 2007


Thanks.
他的目的是要能写一个已存在的excel文件,就是说某个excel文件已存在,他可以打开,并从指定位置($location)开始追加数据(@data)。你的这个函数能做到吗?能搞定我马上给你pay money.:)

-----Original Message-----
>From: Wan <wanmyome at gmail.com>
>Sent: Jan 30, 2007 2:19 AM
>To: Jeff Pang <pangj at earthlink.net>, china-pm at pm.org
>Subject: Re: [PerlChina] Want to get a module
>
>#!/usr/bin/perl
>use Win32::OLE;
>my $ex = Win32::OLE->new('Excel.Application') or die "oops\n";
>#$ex->{Visible} = 1;
>my $wb = $ex->Workbooks->Open("D:/new.xls");
>my $sheet = $wb->Worksheets(1);
>$sheet->cells(1,1)->{value} = "哈哈,不到10分钟就可以挣100块钱,幸福啊";
>$sheet->cells(2,1)->{value} = "不过这样拿你钱好像有点好像有点残忍";
>$wb->Save;
>$wb->Close;
>$ex->Quit;
>
>你在网上查一下Excel.Application


--
Books below translated by me to Chinese.
Practical mod_perl: http://home.earthlink.net/~pangj/mod_perl/
Squid the Definitive Guide: http://home.earthlink.net/~pangj/squid/


More information about the China-pm mailing list