<?php ini_set("memory_limit", "10000M"); $conn = mysql_connect("localhost", "jsmdevcons", "Jsmd1234") or die("Couldn't connect to server."); $db = mysql_select_db("test", $conn) or die("Couldn't select database."); ini_set("display_errors", 1); error_reporting(E_ALL); require_once 'excel/excel_reader2.php'; $data = new Spreadsheet_Excel_Reader("StkCSum.xls"); $unit_master = array(); for ($row = 5; $row <= $data->rowcount(); $row++) { if ($data->format($row, 3) != "") { $arr_test = explode(" ", $data->format($row, 3)); $uom = str_replace('"', "", $arr_test[1]); if (!in_array($uom, $unit_master)) { $unit_master[] = $uom; } } } foreach ($unit_master as $unit_name) { $sql_unit_master = "insert into ms_uom set\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tname = '" . $unit_name . "'"; $result_ins = mysql_query($sql_unit_master) or die("Error in query:" . $sql_unit_master . "<br>" . mysql_error() . ":" . mysql_errno()); } $dep_id = 0; for ($row = 5; $row <= $data->rowcount(); $row++) { if ($data->bold($row, 1, 0)) { $sql_department = "insert into ms_department set\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tname = '" . $data->value($row, 1, 0) . "'"; $result_ins = mysql_query($sql_department) or die("Error in query:" . $sql_department . "<br>" . mysql_error() . ":" . mysql_errno()); $dep_id = mysql_insert_id(); } else { $unit_id = 0;
<br><br> <table border="1"> <?php for ($row = 1; $row <= $xls->rowcount(); $row++) { ?> <tr> <?php for ($col = 1; $col <= $xls->colcount(); $col++) { ?> <td><?php echo $xls->val($row, $col); ?> <div><br>Format=<?php echo $xls->format($row, $col); ?> <br>FormatIndex=<?php echo $xls->formatIndex($row, $col); ?> <br>Raw=<?php echo $xls->raw($row, $col); ?> </div></td> <?php } ?> </tr> <?php } ?>