01.<?php
02.
03.
04.require_once 'Classes/PHPExcel.php';
05.
06.
07.include 'Classes/PHPExcel/IOFactory.php';
08.
09.
10.$inputFileName = "myData.xls";
11.$inputFileType = PHPExcel_IOFactory::identify($inputFileName);
12.$objReader = PHPExcel_IOFactory::createReader($inputFileType);
13.$objReader->setReadDataOnly(true);
14.$objPHPExcel = $objReader->load($inputFileName);
15.
16.$objWorksheet = $objPHPExcel->setActiveSheetIndex(0);
17.$highestRow = $objWorksheet->getHighestRow();
18.$highestColumn = $objWorksheet->getHighestColumn();
19.
20.$headingsArray = $objWorksheet->rangeToArray('A1:'.$highestColumn.'1',null, true, true, true);
21.$headingsArray = $headingsArray[1];
22.
23.$r = -1;
24.$namedDataArray = array();
25.for ($row = 2; $row <= $highestRow; ++$row) {
26. $dataRow = $objWorksheet->rangeToArray('A'.$row.':'.$highestColumn.$row,null, true, true, true);
27. if ((isset($dataRow[$row]['A'])) && ($dataRow[$row]['A'] > '')) {
28. ++$r;
29. foreach($headingsArray as $columnKey => $columnHeading) {
30. $namedDataArray[$r][$columnHeading] = $dataRow[$row][$columnKey];
31. }
32. }
33.}
34.
35.
36.
37.
38.
39.
40.$objConnect = mysql_connect("localhost","root","1234") or die(mysql_error());
41.$objDB = mysql_select_db("testexcel");
42.$i = 0;
43.foreach ($namedDataArray as $result) {
44. $i++;
45. $strSQL = "";
46. $strSQL .= "INSERT INTO customer2 ";
47. $strSQL .= "(CustomerID,Name,Email,CountryCode,Budget,Used) ";
48. $strSQL .= "VALUES ";
49. $strSQL .= "('".$result["CustomerID"]."','".$result["Name"]."' ";
50. $strSQL .= ",'".$result["Email"]."','".$result["CountryCode"]."' ";
51. $strSQL .= ",'".$result["Budget"]."','".$result["Used"]."') ";
52. mysql_query($strSQL) or die(mysql_error());
53. echo "Row $i Inserted...<br>";
54.}
55.mysql_close($objConnect);
56.?>
Load balance : Server 05
Quote:
