PHP Classes
elePHPant
Icontem

File: Basic.test.php

Recommend this page to a friend!
  Classes of Karl Holz  >  PHP Convert Excel to JSON  >  Basic.test.php  >  Download  
File: Basic.test.php
Role: Example script
Content type: text/plain
Description: Example script
Class: PHP Convert Excel to JSON
Convert data from Excel spreadsheet to JSON format
Author: By
Last change:
Date: 3 years ago
Size: 509 bytes
 

 

Contents

Class file image Download
<?php
require_once 'excelMap.class.php';
$e=new excel2JSON();
$e->set_excel($file, 'false');
$e->load_sheet($sheet);
$e->load_sheet_data();

$e->add_cell_list('A1');

$e->add_cell_list('A2');
$e->add_cell_list('B2');

$e->add_cell_list('A4');
$e->add_cell_list('B4');

echo
'<h2>Filtered Cells</h2><pre>'.print_r($e->filter_cells(), TRUE).'</pre><hr />';

echo
'<h2>Filtered Cell Data</h2><pre>'.print_r($e->filter_data(), TRUE).'</pre><hr />';

echo
'<pre>'.print_r($e, TRUE).'</pre>';