visualizer / vendor / phpoffice / phpexcel / Documentation / Examples / Reader / exampleReader02.php

exampleReader02.php in Visualizer – Tables & Charts Manager with Built-in AI Generator 3.1.1, at vendor/phpoffice/phpexcel/Documentation/Examples/Reader/exampleReader02.php

50 lines 1.2 KB

Raw Download Zip

1	<?php
2
3	error_reporting(E_ALL);
4	set_time_limit(0);
5
6	date_default_timezone_set('Europe/London');
7
8
9	/ Include path /
10	set_include_path(get_include_path() . PATH_SEPARATOR . '../../../Classes/');
11
12	/** PHPExcel_IOFactory */
13	include 'PHPExcel/IOFactory.php';
14
15	?>
16	<html>
17	<head>
18	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
19
20	<title>PHPExcel Reader Example #02</title>
21
22	</head>
23	<body>
24
25	<h1>PHPExcel Reader Example #02</h1>
26	<h2>Simple File Reader using a Specified Reader</h2>
27	<?php
28
29	$inputFileName = './sampleData/example1.xls';
30
31	echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' using PHPExcel_Reader_Excel5<br />';
32	$objReader = new PHPExcel_Reader_Excel5();
33	// $objReader = new PHPExcel_Reader_Excel2007();
34	// $objReader = new PHPExcel_Reader_Excel2003XML();
35	// $objReader = new PHPExcel_Reader_OOCalc();
36	// $objReader = new PHPExcel_Reader_SYLK();
37	// $objReader = new PHPExcel_Reader_Gnumeric();
38	// $objReader = new PHPExcel_Reader_CSV();
39	$objPHPExcel = $objReader->load($inputFileName);
40
41
42	echo '<hr />';
43
44	$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
45	var_dump($sheetData);
46
47
48	?>
49	<body>
50	</html>