Cancelled

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

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

Skills: Excel, Linux, Perl, PHP, Python

See more: excel vba import worksheet, jsp multiple worksheet, excel data multiple worksheets, excel grab cells data, excel grab multiple files, grab data excel file, grab creator information file, grab data excel tabs, grab data multiple spreadhsheets, php5 import excel, dqy multiple, excel dqy, grab cell multiple worksheets, importing excel files php5, vba excel grab cells, grab data excel sql, excel vba grab worksheet, grab information excel files, import worksheets vbnet, find names multiple worksheets

About the Employer:
( 87 reviews ) dix hills, United States

Project ID: #361523

27 freelancers are bidding on average $148 for this job

A2Design

We can handle this. Take a look on our portfolio at [url removed, login to view]

$150 USD in 5 days
(32 Reviews)
7.8
SigmaVisual

We can help in your project, please check PMB to see our related experience.

$225 USD in 4 days
(225 Reviews)
7.7
MAnkita

Hello,Please refer your [url removed, login to view] you.

$200 USD in 5 days
(94 Reviews)
6.7
wincent

pretty easy work.

$80 USD in 0 days
(80 Reviews)
6.0
nmarkovickv

I'm an expert in data processing, data mining. I finish and deliver the project in the fastest possible time. If you are interested we can discuss the details on PM.

$150 USD in 3 days
(19 Reviews)
5.2
getndone

Plz check PM

$30 USD in 0 days
(35 Reviews)
5.1
NashTrump

hi there, I am an expert in excelvba and mysql/sql. This seems a very straight forward task and I can complete it easily for you. Merry christmas.... Kind regards Nash

$130 USD in 0 days
(12 Reviews)
4.6
kallidan

Please see PM for details. Thank you!

$200 USD in 5 days
(7 Reviews)
4.5
tahiralmas

Have experience of such tasks

$150 USD in 4 days
(10 Reviews)
4.2
AGSTechnologies1

We have gone through the information that you have provided and understand your requirements very well. We have excellent expertise in PHP5, MYSQL, DRUPAL, JOOMLA, HTML, CSS, AJAX, JAVA, J2ME, JSP, SEO, SEM, [url removed, login to view], V More

$250 USD in 6 days
(2 Reviews)
3.8
refractocd

This can certainly be done using Excel VBA. Please allow some days for communication, timeline difference, etc. I am ready to start IMMEDIATELY. Please refer to PM.

$110 USD in 3 days
(5 Reviews)
3.1
frustum

Please, see pmb

$80 USD in 2 days
(12 Reviews)
2.9
rpdammu

Dear sir, Please check the PM Sincerely Rajendra

$30 USD in 1 day
(7 Reviews)
2.9
lyusilru

Please, check your PM box

$100 USD in 3 days
(1 Review)
1.8
gafdude

+++++++++ Please refer your pmb +++++++++++++

$250 USD in 1 day
(1 Review)
1.0
ParvindiaInfotec

you can trust on my [url removed, login to view] will be great. I will work untill you get 200% satisfaction.

$101 USD in 0 days
(0 Reviews)
0.0
gizmosolution

We can grab excel data and insert into MYSQL database. Please Contact us for further details.

$110 USD in 2 days
(0 Reviews)
0.0
KittysMom

I have several years experience in data entry, and I also have worked with Excel files.

$30 USD in 1 day
(0 Reviews)
0.0
pearlveeram

Hi, Please check PMB for details. Thanks, Veera

$195 USD in 6 days
(0 Reviews)
0.0
fillman

Can do this job.

$200 USD in 1 day
(0 Reviews)
0.0