| Server IP : 50.21.180.56 / Your IP : 216.73.216.139 Web Server : Apache System : Linux info 3.0 #1337 SMP Tue Jan 01 00:00:00 CEST 2000 all GNU/Linux User : ws67922704 ( 67922704) PHP Version : 8.5.13 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /kunden/usr/share/doc/libspreadsheet-parseexcel-perl/examples/sample/ |
Upload File : |
#!/usr/bin/perl
use strict;
use Spreadsheet::ParseExcel;
use Spreadsheet::ParseExcel::FmtJapan2;
if(!(defined $ARGV[0])) {
print<<EOF;
Usage: $0 Excel_File
EOF
exit;
}
my $iPreSheet=-1;
sub subCellHandler($$$$$) {
my ($oBook, $iSheet, $iRow, $iCol, $oCell) = @_;
if($iPreSheet<0) {
print "=========================================\n";
print "FILE :", $oBook->{File} , "\n";
print "COUNT :", $oBook->{SheetCount} , "\n";
print "AUTHOR:", $oBook->{Author} , "\n";
}
if($iPreSheet != $iSheet) {
print "--------- SHEET:",
$oBook->{Worksheet}[$iSheet]->{Name}, "\n" ;
$iPreSheet = $iSheet;
}
print "( $iRow , $iCol ) =>", $oCell->Value, "\n";
# $oBook->ParseAbort('Exceed Data') if($iRow >= 1);
}
my $oExcel = new Spreadsheet::ParseExcel
( CellHandler => \&subCellHandler, NotSetCell => 1);
my $oFmtJ = Spreadsheet::ParseExcel::FmtJapan2->new(Code => $ARGV[1]);
my $oBook = $oExcel->Parse($ARGV[0], $oFmtJ);
for(my $i=0;$i<$oBook->{SheetCount};$i++) {
print "LAST:\n";
print "Row:", $oBook->{Worksheet}[$i]->{MaxRow}, "\n";
print "Col:", $oBook->{Worksheet}[$i]->{MaxCol}, "\n";
}
print "ABORTED:", $oBook->{_ParseAbort} if($oBook->{_ParseAbort});