We require a small PHP module for an existing system which will parse an Excel spreadsheet with merged cells and migrate the contents to a mySQL DB. Ideally, the option would be nice to tell the module the field names so that it can put the correct information into the database. Example: on one spreadsheet the information which needs to go into 'invoice' column in a DB table maybe called 'ref' on one spreadsheet and 'inv' on another. The data will not necessarily be in a logical line. Basically would be nice if it could be a little flexible. A standard upload form should be used to get the excel sheet onto the server. It is OK to use something like PHP Excel reader plug in or PHPExcel. The database table will be provided as well as the 2 example spreadsheets.
18 freelance font une offre moyenne de £331 pour ce travail
Had once created this kind of script to import meta data of songs from an excelsheet into a MySQL table. Should be a similar kind of a work which i can confidently accomplish.