PHPExcelFormatter
PHPExcelFormatter is class to make getting data from Excel documents simpler.
- Read columns what you really need
- Set column names for documents what dosen't have column names on first row
- Set your DB field names for columns
- Retrieve data in array or MySQL query format
- Greate for importing files and then letting user to connect document columns with your DB fields :) (example coming)
Install
composer require renekorss/phpexcelformatter
Usage
// Require needed files
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 (document must have column names on first row)
$formatterColumns = array(
'username' => 'username',
'phone' => 'phone_no',
'email' => 'email_address'
);
// Output columns array (document dosen't have column names on first row)
// Skip fourth column (age) (third in array), because we don't need that data
// NOTE: if document dosen't have column names on first line, second parameter for PHPExcelFormatter should be $readColumns = false, otherwise it will skip first line of data
$formatterColumns = array(
'username',
'email_address',
'phone',
4 => 'sex'
);
// Set our columns
$formatter->setFormatterColumns($formatterColumns);
// Output as array
$output = $formatter->output('a');
// OR
// $output = $formatter->output('array');
// Print array
echo ''
.print_r($output, true).'';
// Set MySQL table
$formatter->setMySQLTableName('users');
// Output as mysql query
$output = $formatter->output('m');
// OR
// $output = $formatter->output('mysql');
// Print mysql query
echo ''.print_r($output, true).'';
} catch (PHPExcelFormatterException $e) {
echo 'Error: '.$e->getMessage();
}
View examples
License
PHPExcelFormatter is licensed under MIT
68 Sep 20, 2022
6.5k Jan 7, 2023
3k Jan 1, 2023
666 Dec 24, 2022
160 Jan 6, 2023
8 Aug 19, 2022
3 Apr 26, 2021
12 Feb 1, 2022
51 Dec 17, 2022
36 Aug 23, 2022
4 Aug 22, 2022
1 Nov 17, 2021
88 Oct 21, 2022
4 Sep 18, 2022
2 Sep 16, 2022
2 May 30, 2022
8 Jun 17, 2022
249 Nov 29, 2022
3 Apr 26, 2021
2 May 30, 2022
68 Sep 20, 2022
11.2k Jan 4, 2023
1.7k Jan 8, 2023
54 Dec 3, 2022
550 Dec 27, 2022
1 Oct 26, 2021
1 Dec 25, 2021
11.8k Dec 31, 2022