PHP Classes

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: Update of Basic.test.php
Date: 1 year 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>';