Dibatalkan

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

Kemahiran: Excel, Linux, Perl, PHP, Python

Lihat lebih lanjut: 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

Tentang Majikan:
( 87 ulasan ) dix hills, United States

ID Projek: #361523

27 pekerja bebas membida secara purata $148 untuk pekerjaan ini

A2Design

We can handle this. Take a look on our portfolio at http://www.a2design.biz/portfolio

$150 USD dalam 5 hari
(32 Ulasan)
7.8
SigmaVisual

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

$225 USD dalam 4 hari
(225 Ulasan)
7.7
MAnkita

Hello,Please refer your PMB.Thank you.

$200 USD dalam 5 hari
(94 Ulasan)
6.7
wincent

pretty easy work.

$80 USD dalam 0 hari
(80 Ulasan)
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 dalam 3 hari
(19 Ulasan)
5.2
getndone

Plz check PM

$30 USD dalam 0 hari
(35 Ulasan)
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 dalam 0 hari
(12 Ulasan)
4.6
kallidan

Please see PM for details. Thank you!

$200 USD dalam 5 hari
(7 Ulasan)
4.5
tahiralmas

Have experience of such tasks

$150 USD dalam 4 hari
(10 Ulasan)
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, ASP.NET, V Lagi

$250 USD dalam 6 hari
(2 Ulasan)
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 dalam 3 hari
(5 Ulasan)
3.1
frustum

Please, see pmb

$80 USD dalam 2 hari
(12 Ulasan)
2.9
rpdammu

Dear sir, Please check the PM Sincerely Rajendra

$30 USD dalam sehari
(7 Ulasan)
2.9
lyusilru

Please, check your PM box

$100 USD dalam 3 hari
(1 Ulasan)
1.8
gafdude

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

$250 USD dalam sehari
(1 Ulasan)
1.0
ParvindiaInfotec

you can trust on my work.it will be great. I will work untill you get 200% satisfaction.

$101 USD dalam 0 hari
(0 Ulasan)
0.0
gizmosolution

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

$110 USD dalam 2 hari
(0 Ulasan)
0.0
KittysMom

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

$30 USD dalam sehari
(0 Ulasan)
0.0
pearlveeram

Hi, Please check PMB for details. Thanks, Veera

$195 USD dalam 6 hari
(0 Ulasan)
0.0
fillman

Can do this job.

$200 USD dalam sehari
(0 Ulasan)
0.0