I would like to write a program which will retrieve the data from the
EXCEL file and write into an SQL Server using Perl
script.Spreadsheet::WriteExcel programs are working fine.But while
executing Spreadsheet::ParseExcel i am getting the error like
Can't locate Spreadsheet/ParseExcel.pm in @INC (@INC contains: D:/Perl/lib D:/Pe
rl/site/lib .) at parse.pl line 5.
I used the following program.Can anyone tell me whether the problem
arise because of inproper installation of Spreadsheet::ParseExcel or the
error with the code
#PROGRAM TO RETRIEVE DATA
#!/usr/bin/perl
use strict;
use Spreadsheet::ParseExcel;
my $workbook = Spreadsheet::ParseExcel::Workbook->Parse("C:/tito.xls");
my $a3=$workbook->[1] {A3},"\n";
print "$a3";
用cpan 安装一下Spreadsheet::WriteExcel即可
进入cpan
install Spreadsheet::WriteExcel