Sedang Disiapkan

Perl Script to fetch data from xls and output in csv

I need a perl script to connect to a sqlserver database and select data from a table based on 4-8 given parameters in the .xls files and report the results in .csv format.

For example I want to get the results from deal_entry table based on column in the excel workbook SHEETS (there could be x number of sheets) where I find a particular column with name of deal_id, and or another column with name of deal_ref in another excel workbook.

So script needs to look at 7 workbooks and search each sheet for a particular column and fetch the results based on the column value.

I hope it's clear enough to begin with.

I need this script ASAP (2-3 days) and need an expert perl developer to work on it.

Thanks

Sample Files



I have attached the excel workbooks (sDealNumber and sShipmentID).
sDealNumber workbook contains column sDealNumber in most of the sheets where all the values are displayed under it and sShipmentID workbook contains sShipment_ID.

What I want is : These are only 2 workbooks with several sheets in it. There could be x number of workbooks and x number of worksheets in them. We have to search for columns mentioned above (sDealNumber) in all the workbook/sheets and sShipment_ID in all the workbook/sheets based on the column results we have to pass the parameter to the sqlserver database so it can give the output and we can store it in a CSV format sorted numerically on a single page but sepaerate to each other so it can be identified easily.

I hope it's clear enough? If not please ask me again.

Kemahiran: Excel, Perl

Lihat lebih lanjut: perl output csv, perl xls csv, perl script read xls, perl script select data, xls perl, script perl csv database sample, perl login website fetch data, perl script retrieve data excel, perl output xls, xls excel expert, script sheets, perl search script, perl get, look for script developer, find perl, find an excel expert, excel 0 to expert, developer perl, be an expert in excel, perl output csv data, perl xls csv example, perl output csv sheet, perl script fetch data excel csv, perl script fetch database search, perl script find column database output results

Tentang Majikan:
( 14 ulasan ) new delhi, India

ID Projek: #316338

Dianugerahkan kepada:

shwetakagliwal

Please give some test data. I have dealt with excel file handling with perl. Thanks

$30 USD dalam 3 hari
(2 Ulasan)
1.8

17 pekerja bebas membida secara purata $130 untuk pekerjaan ini

gangabass

I can do this job for you. See PM for details.

$75 USD dalam 3 hari
(159 Ulasan)
6.0
dims

Please give me example of excel files and result csv

$100 USD dalam 2 hari
(93 Ulasan)
5.9
Arenabpo

Hello, I am very skillful on perl, i can do this job for you, Thank you!

$120 USD dalam 3 hari
(9 Ulasan)
4.9
kallidan

Please see PM for details. Thank you.

$150 USD dalam 3 hari
(5 Ulasan)
4.1
edatawiz

Hi Please check PM for details.

$200 USD dalam 4 hari
(10 Ulasan)
3.9
amsak

Expert perl programmer last 10 yrs. Located close to you.

$60 USD dalam 7 hari
(5 Ulasan)
3.0
petr999

Can deliver this to you.

$120 USD dalam 4 hari
(1 Ulasan)
2.5
ravipatel4

Hi dear, I can help you. check PM for more.

$50 USD dalam 2 hari
(1 Ulasan)
1.8
ashudotnet

Hi, I have estimated 4 days for your project. I would really appreciate if you could please let me know further details of your project

$250 USD dalam 4 hari
(0 Ulasan)
0.0
amedina79

Hi, no problem with this, I can help. I've made several projects like this before, see PM, Thanks

$150 USD dalam 3 hari
(0 Ulasan)
0.0
drgnome

I can help you.. It will be finished on 2-3 days. Can you send me an example xls file and csv output?

$80 USD dalam 3 hari
(0 Ulasan)
0.0
loviedo

hello, i have experience with perl, i can do it in 2 days

$200 USD dalam 2 hari
(0 Ulasan)
0.0
magamallidamodar

I am working as perl programmer .I have a experience in writing scripts for reading the log files from the production systems

$200 USD dalam 2 hari
(0 Ulasan)
0.0
dnay

This is a process that I have done hundreds of times, and could put it together quickly, but not sacrifice quality. I am -very- detail oriented, and pride myself in quality work. I could have it done for you tomorro Lagi

$150 USD dalam sehari
(0 Ulasan)
0.0
sarikaparmar

PLs chk PMB

$75 USD dalam 5 hari
(0 Ulasan)
0.0
krikbugs

Please provide DB and other details

$200 USD dalam sehari
(0 Ulasan)
0.0