Linux excel导入数据库,Linux下将excel数据导入到mssql数据库中的方法

".($i+1)."\n";

if(isset($ws['cell'][$i]) && is_array($ws['cell'][$i]) ) {

for( $j=0; $j<=$ws['max_col']; $j++ ) {

if( ( is_array($ws['cell'][$i]) ) &&

( isset($ws['cell'][$i][$j]) )

){

// print cell data

print "$data = $ws['cell'][$i][$j];

$font = $ws['cell'][$i][$j]['font'];

$style = " style ='".ExcelFont::ExcelToCSS($exc->fonts[$font])."'";

switch ($data['type']) {

// string

case 0:

print "dt_string\"".$style.">";

$ind = $data['data'];

if( $exc->sst['unicode'][$ind] ) {

$s = uc2html($exc->sst['data'][$ind]);

} else

$s = $exc->sst['data'][$ind];

if( strlen(trim($s))==0 )

print " ";

else

print $s;

break;

// integer number

case 1:

print "dt_int\"".$style."> ";

print $data['data'];

break;

// float number

case 2:

print "dt_float\"".$style."> ";

echo $data['data'];

break;

// date

case 3:

print "dt_date\"".$style."> ";

$ret = $data[data];//str_replace ( " 00:00:00", "", gmdate("d-m-Y H:i:s",$exc->xls2tstamp($data[data])) );

echo ( $ret );

break;

default:

print "dt_unknown\"".$style.">  ";

break;

}

print "\n";

} else {

print "\n";

}

}

} else {

// print an empty row

for( $j=0; $j<=$ws['max_col']; $j++ )

print "";

print "\n";

}

print "