Friday, March 3, 2017

Reading XLSX, ODS and text/CSV file

We can easily read these files using PHP spreadsheet reader. At first download PHP spreadsheet reader from spreadsheet-reader. you can also get sample code there.
 example for reading .xls file-

<?php

header('Content-Type: text/plain');
$Filepath = 'test.xlsx';
require('php-excel-reader/excel_reader2.php');
require('SpreadsheetReader.php');
try
{
$Spreadsheet = new SpreadsheetReader($Filepath);
/* for reading only first sheet */
/*
   foreach ($Spreadsheet as $Row)
   {
       print_r($Row);
   }*/
   /* for reading all first sheet or reading specific sheet */
$Sheets = $Spreadsheet -> Sheets();
foreach ($Sheets as $Index => $Name)
{
echo '*** Sheet '.$Name.' ***'.PHP_EOL;
$Spreadsheet -> ChangeSheet($Index);
foreach ($Spreadsheet as $Key => $Row)
{
echo $Key.': ';
if ($Row)
{
print_r($Row);
}
else
{
var_dump($Row);
}
}
echo '*** End of sheet '.$Name.' ***'.PHP_EOL;
}

}
catch (Exception $E)
{
echo $E -> getMessage();
}

?>

No comments:

Post a Comment