Kode PHP Convert EXCEL 2007 to mySQL

kode ini powerfull
bisa multi sheet


<table border=1>

<?php
//<pre>
//error_reporting(E_ALL);
set_time_limit(0);
 ini_set("memory_limit","256M");
 include 'rand.php';
 include 'PHPExcel.inc.php';


 include "db.php";
 mysql_connect($site["dbhost"], $site["dblogin"], $site["dbpass"]);
mysql_select_db($site["dbname"]);


date_default_timezone_set('Europe/London');

 $inputFileName = $_GET[inputFileName];
 echo "inputFileName $inputFileName <br>";
/** Include path **/
set_include_path(get_include_path() . PATH_SEPARATOR . 'include_lib/Classes/');

//http://localhost/pilkada/tabulasi-dpt-kalbar/PHPExcel.php?inputFileName=
//data/Kota_Pontianak/Pontianak_Barat/Jawi_Luar/DPT_S_JAWI_LUAR_(1-35_TPS).xlsx
$b  = explode("/",$inputFileName);
$kab = $b[1];
$kecamatan = $b[2];
$kelurahan = $b[3];

//$kab = str_replace("_"," ",$kab);
//$kecamatan = str_replace("_"," ",$kecamatan);
//$kelurahan = str_replace("_"," ",$kelurahan);

$id_kab = TulisNama(id_kab,kab,kab,$kab);
$id_kecamatan = TulisNama(id_kecamatan,kecamatan,kecamatan,$kecamatan);
$id_kelurahan = TulisNama(id_kelurahan,kelurahan,kelurahan,$kelurahan);

/** PHPExcel_IOFactory */
include 'PHPExcel/IOFactory.php';


// $inputFileName = 'data/dpt.xlsx';
// $inputFileName = 'data/dpt.xlsx';
$objPHPExcel = PHPExcel_IOFactory::load($inputFileName);




$csheet = $objPHPExcel->getSheetCount();

echo "csheet $csheet";

//echo "<Br>urut tanda tps nik nama <br>";
echo "<tr>";
echo "<td>urut </td>";
echo "<td>tanda </td>";
echo "<td>tps </td>";
echo "<td>nik </td>";
echo "<td>nama </td>";
echo "<td> urut< urutx </td>";

echo "</tr>";

$loadedSheetNames = $objPHPExcel->getSheetNames();
foreach($loadedSheetNames as $sheetIndex => $loadedSheetName) {
$hal++;
$ahal[] = $hal;

echo "hal $hal <br>";

  $objPHPExcel->setActiveSheetIndexByName($loadedSheetName);
  $sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
$cbaris  = count($sheetData);
$cbaris1 = $cbaris+1;
for($baris=1;$baris<$cbaris1;$baris++){




$urut= $sheetData[$baris][A];
$ktp= $sheetData[$baris][B];
$nama= $sheetData[$baris][C];

$strlennama = strlen($nama);
$strlenktp = strlen($ktp);
$nama= mysql_real_escape_string($nama);
$ktp= mysql_real_escape_string($ktp);

if($urut =="TPS"){
$halaman=1;
// echo "halaman $halaman <br>";
 $ktpx =   $ktp;
 $tps =   str_replace(":","",$ktp);
 /*
 if(!$tps){
$tps=1;
 }
 */
 $atps[]=$tps;

  $urutx = $urut;

//in2dpt($id_kelurahan,$tps,$dpt,$kode);

}else if($urut=="KELURAHAN
KECAMATAN"){
$ktpx =   $ktp;

}else{
 //$ktpx =    exp_to_dec($ktp );
 $ktpx =   $ktp;
}

$atps0 = $atps[0];


if($nama=="NAMA PEMILIH" || $nama=="NAMA    PEMILIH" || $nama=="" || $nama=="KOTA" || $nama=="PROVINSI" ){
continue;
}
if($strlennama<3){
continue;
}

// $ktpx =  sprintf("%0.0f", $ktp);
//  $ktpx =    exp_to_dec($ktp );
// $ktpx =    printf("\$f = %0.0f\n", $ktp);
/*
echo "<tr>";
echo "<td>$a </td>";
echo "<td>$ktpx </td>";
echo "<td>$nama </td>";

echo "</tr>";
*/
$nik = $ktpx;
$id_dpt_data = TulisNama(id_dpt_data,dpt_data,nik,$nik);

if($id_dpt_data){
// echo "<font color=red>KTP $nik $nama sudah ada </font><br>";
$ganda=1;
$id_dpt_data2 = $id_dpt_data;
}else{
$ganda=0;
$id_dpt_data2 = 0;
}
if($urut<$urutx){
$urutx = $urutx;
$tanda=1;

}else{

$urutx = $urut;
$tanda=0;

}


//  echo " $nik $nama <br>";
/*
echo "<tr>";
echo "<td>$urut </td>";
echo "<td>$tanda </td>";
echo "<td>$tps </td>";
echo "<td>$nik </td>";
echo "<td>$nama </td>";
echo "<td>$urut<$urutx </td>";

echo "</tr>";
*/

// echo "$urut $tanda $tps $nik $nama <br>";







if($urut<27   ){

if($hal>1){
$tps27 = $tps+1;
}else{
$tps27 = 0;
}
// echo "urut<27 - urut $urut  - tps27 $tps27 -  tps $tps - $nama <br>";


in2dpt_data($closing,$id_kelurahan,$tps27,$nik,$nama,$ttl,$pengirim,$hp,$lewat,$urut,$tanda,$ganda,$id_dpt_data2,$hal);

}else{
// echo "urut $urut  - tps27 $tps27 -  tps $tps - $nama<br>";
in2dpt_data($closing,$id_kelurahan,$tps,$nik,$nama,$ttl,$pengirim,$hp,$lewat,$urut,$tanda,$ganda,$id_dpt_data2,$hal);
}




}


}

/*
 $sqldpt_data ="select id_dpt_data, tps  from dpt_data where tanda='1' ";
$datadpt_data =mysql_query($sqldpt_data );

while($rowdpt_data =mysql_fetch_array($datadpt_data )){

    $id_dpt_data=stripslashes($rowdpt_data ["id_dpt_data"]);
    $tps=stripslashes($rowdpt_data ["tps"]);
$tps1 = $tps+1;
// Update1(dpt_data,tps,$tps1,id_dpt_data,$id_dpt_data);

}


*/

//Update1(dpt_data,tps,1,tps,0);
$sqldpt_data ="select id_dpt_data, tps  from dpt_data where tps='0' ";
$datadpt_data =mysql_query($sqldpt_data );

while($rowdpt_data =mysql_fetch_array($datadpt_data )){

$id_dpt_data=stripslashes($rowdpt_data ["id_dpt_data"]);

Update1(dpt_data,tps,$atps0,id_dpt_data,$id_dpt_data);
// echo "Update1(dpt_data,tps,$atps0,id_dpt_data,$id_dpt_data); <br>";

}



$sqldpt_data2 ="select id_dpt_data, tps  from dpt_data where urut=26 and hal=3 and tanda2 = '0' ";
$datadpt_data2 =mysql_query($sqldpt_data2 );

while($rowdpt_data2 =mysql_fetch_array($datadpt_data2 )){

$id_dpt_data=stripslashes($rowdpt_data2 ["id_dpt_data"]);
$tps=stripslashes($rowdpt_data2 ["tps"]);
$tpsmin1 = $tps-1;

Update1(dpt_data,tps,$tpsmin1,id_dpt_data,$id_dpt_data);
Update1(dpt_data,tanda2,1,id_dpt_data,$id_dpt_data);
// echo "Update1(dpt_data,tps,$atps0,id_dpt_data,$id_dpt_data); <br>";

}

 echo "OK";

?>