Impementing a PHP5 Excel to JSON converter

This is a small project for an experienced PHP developer

The script/class should a accept the following parameters:

input File: path to Excel file .xls, if possible also .xlsm

output File: path to JSON file

convertOnlyWhenInputNewerThanOutput: Boolean

These parameters are quite generic (superclass?): in this case we want to convert xls to JSON, but in other cases it will be xml to JSON, CSV to ...

Excel/JSON specific parameters

multidimensional array: array of objects specifiying which spreadsheets to use, with corresponding keys (for the JSON object), containing arrays of objects specifying which colums to use, with corresponding keys

for the included example Excel list it would be something like this

[

{0:'thisIsTheFirstSpread', colKeys: [{0:'zip'}, {3:'d_f'}, {5:'ib'}, {7:'g'}, {9:'hb'}]}, // first spread

{2:'keyForThirdSpread', colKeys:[{0:'repID'}, {1:'repName'}]}// third spread, second spread is ignored

]

[ {0:'zip'},

{3:'d_f'},

{5:'ib'},

{7:'g'},

{9:'hb'}

]

in this example columns C,D,F,H,J must be ignored and not converted to JSON

default/no columsKeys specified: use all columns, use index numbers for keys (0, 1, 2 ...)

mustHaveNColumns: Int - in this example 10. A ultra-basic sanity check that the structure of the Excel File has not changed

Exceptions should be thrown when

- input File does not exist

- input File is not of proper type (.xls or xlsm)

- input File has more or less columns than mustHaveNColumns

- more, as you see fit

Please add an examle how to

load the JSON file in Javascript and output the data for a given zip, e.g. 8750

I googled some PHP Excel parsers, up to you ot chose one:

[login to view URL]

a big list here: [login to view URL]

Deadline: completion within 3 days

PHP

Project ID: #4882349

About the project