<?php error_reporting(E_ALL ^ E_NOTICE); require_once 'SpreadsheetExcelReader.php'; $reader = new SpreadsheetExcelReader("example.xls"); // or $reader = new SpreadsheetExcelReader(); $fileContent = file_get_contents("example.xls"); $reader->readFromBlob($fileContent); ?> <html> <head> <style> table.excel { border-style:ridge; border-width:1; border-collapse:collapse; font-family:sans-serif; font-size:12px; } table.excel thead th, table.excel tbody th { background:#CCCCCC; border-style:ridge; border-width:1; text-align: center; vertical-align:bottom; } table.excel tbody th { text-align:center; width:20px; }
<?php $data = new SpreadsheetExcelReader(); $data->read('excel/kurs_bit08.xls'); /* echo '<pre>'; print_r($data->sheets[0]); echo '</pre>'; */ $spalte = array(); $numRows = $data->sheets[0]['numRows']; $numCols = $data->sheets[0]['numCols']; for ($i = 1; $i < $numRows; $i++) { for ($j = 1; $j < $numCols; $j++) { $spalte[$i][$j] = $data->sheets[0]['cells'][$i][$j]; } } echo Html::buildTable($spalte); /* echo '<pre>'; print_r($spalte); echo '</pre>'; */