Transfering xls or odt content to mysql db
$30-250 USD
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.
Project ID: #9894194
About the project
Awarded to:
9 freelancers are bidding on average $193 for this job
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
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- More