I gang

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.

Færdigheder: Excel, Perl

Se mere: 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

Om arbejdsgiveren:
( 14 bedømmelser ) new delhi, India

Projekt-ID: #316338

Tildelt til:

shwetakagliwal

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

$30 USD in 3 dage
(2 bedømmelser)
1.8

17 freelancere byder i gennemsnit $130 for dette job

gangabass

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

$75 USD in 3 dage
(159 bedømmelser)
6.0
dims

Please give me example of excel files and result csv

$100 USD in 2 dage
(93 bedømmelser)
5.9
Arenabpo

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

$120 USD in 3 dage
(9 bedømmelser)
4.9
kallidan

Please see PM for details. Thank you.

$150 USD in 3 dage
(5 bedømmelser)
4.1
edatawiz

Hi Please check PM for details.

$200 USD in 4 dage
(10 bedømmelser)
3.9
amsak

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

$60 USD in 7 dage
(5 bedømmelser)
3.0
petr999

Can deliver this to you.

$120 USD in 4 dage
(1 bedømmelse)
2.5
ravipatel4

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

$50 USD in 2 dage
(1 bedømmelse)
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 in 4 dage
(0 bedømmelser)
0.0
amedina79

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

$150 USD in 3 dage
(0 bedømmelser)
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 in 3 dage
(0 bedømmelser)
0.0
loviedo

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

$200 USD in 2 dage
(0 bedømmelser)
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 in 2 dage
(0 bedømmelser)
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 Mere

$150 USD på 1 dag
(0 bedømmelser)
0.0
sarikaparmar

PLs chk PMB

$75 USD in 5 dage
(0 bedømmelser)
0.0
krikbugs

Please provide DB and other details

$200 USD på 1 dag
(0 bedømmelser)
0.0