Grab Data from Excel file with multiple worksheet and import to mysql

This project received 28 bids from talented freelancers with an average bid price of $147 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $250 USD
Total Bids
Project Description

I will need a table in which I will provide userid and password

this userid and passw will go to a website, log in and download excel files (web site will be provided later)

Every excel file has multiple tabs

the First 2 tab names are the same in every file

Will need to extract several defined cells and insert into a table

I must be able to add and remove what cell to import using a web gui

I must also be able to define which cell to import what to field

the rest of the worksheets can have random names but all starting with the word x

script must go through all all worsheet whose name start with x and extract defined fields from every one of the worksheet starting with x and put them into a second table

process must repeat for every login and every file downloaded

if there are more than 1 worksheet starting with x and having the same name , only use the very first one, ignore the others

There are existing software/script out there which can already import form excel onto mysql , you may use those

an example file has been uploaded, please look at the multiple worksheets

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online