PHP Classes
elePHPant
Icontem

File: makeconfig.php

Recommend this page to a friend!
  Classes of Karl Holz  >  PHP Convert Excel to JSON  >  makeconfig.php  >  Download  
File: makeconfig.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: 962 bytes
 

 

Contents

Class file image Download
<?php
require_once 'excelMap.class.php';
$e=new excel2JSON();
/**
 * you will need to set the $file variable for this to work
 */
$e->set_excel($file, 'false');
$path=array();
/**
 * get a list of excel sheets and add them to $path
 */
foreach ($e->excel_sheets['title'] as $k => $v) $path[]=$v;
//
$ini='';
/**
 * make the ini configuration for each sheet,
 * only file and sheet, plus the cells with data are set as keys
 */
foreach ($path as $p){
    unset(
$e);
   
$e=new excel2JSON();
   
$e->set_excel($file, 'false');
   
$e->load_sheet($p);
   
$e->load_sheet_data();
   
$excel=$e->get_loaded_workbook_cells();
// print_r($excel);
   
$ini.=<<<i
[$p]
i
;
    foreach (
$excel as $k =>$v) $ini.="$k=\"$k\"\n";
}
/**
 * write configuration file as test.ini
 */
file_put_contents(basename($file, '.xlsx') . '.ini', $ini);
/**
 * show newly made file
 */
if (basename($_SERVER['SCRIPT_NAME']) == 'makeconfig.php')echo "<pre>".$ini."</pre>";