PHP Classes

File: examples/example1.php

Recommend this page to a friend!
  Classes of Rene Korss   PHPExcel Formatter   examples/example1.php   Download  
File: examples/example1.php
Role: Example script
Content type: text/plain
Description: Example script
Class: PHPExcel Formatter
Extract data from Excel into arrays or MySQL
Author: By
Last change:
Date: 7 years ago
Size: 1,014 bytes
 

Contents

Class file image Download
<?php
/**
 * PHPExcelFormatter example 1
 *
 * @author Rene Korss <rene.korss@gmail.com>
 */

require __DIR__ . '/vendor/autoload.php';

use
RKD\PHPExcelFormatter\PHPExcelFormatter;
use
RKD\PHPExcelFormatter\Exception\PHPExcelFormatterException;

try
{
   
// Load file
   
$formatter = new PHPExcelFormatter('example1.xls');

   
// Output columns array
   
$formatterColumns = array(
       
'username' => 'username',
       
'phone' => 'phone_no',
       
'email' => 'email_address'
   
);

   
// Set our columns
   
$formatter->setFormatterColumns($formatterColumns);

   
// Output as array
   
$output = $formatter->output('a');

   
// Print array
   
echo '<pre>'.print_r($output, true).'</pre>';

   
// Set MySQL table
   
$formatter->setMySQLTableName('users');

   
// Output as mysql query
   
$output = $formatter->output('m');

   
// Print mysql query
   
echo '<pre>'.print_r($output, true).'</pre>';

}
catch(
PHPExcelFormatterException $e)
{
    echo
'Error: '.$e->getMessage();
}

?>