Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- function excelToArray($file, $highestColumn) {
- include 'Classes/PHPExcel/IOFactory.php';
- $inputFileName = $file;
- // Read your Excel workbook
- try {
- $inputFileType = call_user_func(array('PHPExcel_IOFactory', 'identify'), $inputFileName);
- $objReader = call_user_func(array('PHPExcel_IOFactory','createReader'),$inputFileType);
- //$inputFileType = PHPExcel_IOFactory::identify($inputFileName);
- //$objReader = PHPExcel_IOFactory::createReader($inputFileType);
- $objPHPExcel = $objReader->load($inputFileName);
- } catch(Exception $e) {
- die('Error loading file "'.pathinfo($inputFileName,PATHINFO_BASENAME).'": '.$e->getMessage());
- }
- $sheet = $objPHPExcel->getSheet(0);
- $highestRow = $sheet->getHighestRow();
- //$highestColumn = 'E';
- // Loop through each row of the worksheet in turn
- for ($row = 1; $row <= $highestRow; $row++){
- // Read a row of data into an array
- $rowData[] = $sheet->rangeToArray('A' . $row . ':' . $highestColumn . $row, NULL, TRUE, FALSE);
- // Insert row data array into your database of choice here
- }
- return $rowData;
- }
- $data = excelToArray('test.xlsx','E');
- print_r($data);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement