Transfering xls or odt content to mysql db

Completed Posted Mar 9, 2016 Paid on delivery
Completed Paid on delivery

Please develop a php project, to import each xls or openoffice calculation Content to mysql fields. Each field should be imported (not empty cells of course). It should be divided into 3 steps:

1) Reading xls or ods File

2) Mapping of fields (nameing and field description) as on image; all field assignments should be cached, if user login aborts or if error happens (here perhaps some substeps are necessary if there are to many cells, lets say 50 cells)

3) Writing fields to tables: there are two mysql tables to write to. variables and operations. if excel source cell is a value (number) it should import cell to variables db. if it is an "=" recognized in cell it should import to operations db. There should be different conditions to import operations. MAin problem are the possible xls functions as SUM, IF and so on which should be transfered to php code, so that calculating in php is possible. Here the most important 10 operations of xls should be meeted.

MySQL PHP Software Architecture

Project ID: #9894194

About the project

9 proposals Remote project Active Mar 11, 2016

Awarded to:

$105 USD in 3 days
(1222 Reviews)
9.4

9 freelancers are bidding on average $193 for this job

TenStar718

Hello, and thanks for the opportunity to bid on your project. https://www.freelancer.com/u/TenStar718.html I am an expert in many different area’s of web and mobile applications based on the following languages: P More

$210 USD in 3 days
(258 Reviews)
8.9
webxtor

A proposal has not yet been provided

$222 USD in 5 days
(315 Reviews)
7.0
florinbacu

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- More

$178 USD in 7 days
(37 Reviews)
6.1