How to use phpexcel to read data and insert into database?

by

Using the PHPExcel library to read an Excel file and transfer the data into a database

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

$inputFileName="./sampleData/example1.xls";

//  Read your Excel workbook
try {
    $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());
}

//  Get worksheet dimensions
$sheet = $objPHPExcel->getSheet(0); 
$highestRow = $sheet->getHighestRow(); 
$highestColumn = $sheet->getHighestColumn();

//  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
}

Anything more becomes very dependent on your database, and how you want the data structured in it

More Related Contents:

  1. PHPExcel — Color part of XLSX table
  2. Alternative for PHP_excel
  3. PHPExcel runs out of 256, 512 and also 1024MB of RAM
  4. phpexcel to download
  5. How to fix memory getting exhausted with PHPExcel?
  6. PHPExcel auto size column width
  7. PHPExcel download using ajax call
  8. Ignore empty cells PHPExcel
  9. How to read large worksheets from large Excel files (27MB+) with PHPExcel?
  10. Correct format for strings / numbers beginning with zero?
  11. phpexcel Allowed memory size of 134217728 bytes exhausted [duplicate]
  12. Changing the source php [closed]
  13. Remove a child with a specific attribute, in SimpleXML for PHP
  14. How to debug in WooCommerce 3+
  15. Trying to get property of non-object – Laravel 5
  16. PHP: exceptions vs errors?
  17. PHP Header redirect not working [duplicate]
  18. Using Mysqli bind_param with date and time columns?
  19. Setting environment variables for accessing in PHP when using Apache
  20. Can you create instance properties dynamically in PHP?
  21. How do I insert multiple checkbox values into a table?
  22. Trim unicode whitespace in PHP 5.2
  23. Can I “Mock” time in PHPUnit?
  24. Apache Mod Rewrite For Laravel
  25. What is normalized UTF-8 all about?
  26. Who Add “_” Single Underscore Query Parameter?
  27. Mail returns false
  28. How to get the newest file in a directory in php
  29. Using str_split on a UTF-8 encoded string
  30. Create Image From Url Any File Type

Leave a Comment