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
Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our Plus
Dear Sir/Madam, This is a very simple task for [login to view URL] see pmb for more details.
Hello, This can easily be done using PHPExcel (as I see that you know). The question is how many fields/sheets/tables are we dealing with. maybe you just want to run through the excel file a load a bunch of records. Plus
Dear Sir, I am working on Excel VBA programming more than 7 years with online service integration with web services.
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.