In Progress

Excel Data Extract and Book Formatting Utility

The project is to build a utility that can take an Excel input file and create a directory book.

I have a database extract that comes to me in an Excel format. The data is somthing like a company profile (name, location(s), management info, company info, technologies, etc.). I need a utility written that I can point at my extract file, it takes the data and:

1) Creates either a Word or PDF document that has the appropriate formatting (example: bolded header for company name and field names with the data --- Address, Telephone, Email, etc.)

2) The utility needs to allow me to create the above into several different sections. For example, the first section will be a simple alphabetical list of companies, the second section will have them sorted by location.

3) Three indexes (name and page number where found) need to be created based on: alphabetical order, the industries they work in, and the technologies they support.

4) Each page in the sections and indexes should have a header that says what is on the page (for example, Sorted By Name, Sorted By Location, Industry Cross Reference, Technology Cross Reference).

5) I should be able to enter a footer (for example, 2008 Edition)

6) A Table of Contents needs to be created based all of the above.

7) The utility needs to be smart enough to know when the amount of space used on a page is completed to insert insert page breaks. Data from one listing CANNOT be split across pages.

I don't care what it's written in, I just need to know how to run the darn thing! A GUI would be nice but I'm happy to run a script with some parameters.

Skills: .NET, C Programming, Perl, XML

See more: extract data excel book, support need management, utility gui, sorted data, smart technologies, smart input, perl technology, me excel, gui number, formatting utility, excel support company, excel company profile, excel based companies, database technologies, perl data extraction utility, purchase book formatting, extract excel format, extract book, booklet formatting, data book formatting, excel formatting utility, excel utility data, excel data extract, book formating companies, extract data excel utility

About the Employer:
( 9 reviews ) Mesa, United States

Project ID: #234373

Awarded to:

VLADNOVA

Sir, I'd love to get done this project for You. See details in PM please.

$250 USD in 7 days
(10 Reviews)
4.8

21 freelancers are bidding on average $459 for this job

riyoyo

You can use the combination between Excel Object Library and Word Object Library (included within Office setup as default). Using these library, you will have any flexibilities on accessing items on both Excel and Word More

$381 USD in 1 day
(24 Reviews)
6.4
xamdam91

Looking forward to working with you.

$500 USD in 3 days
(30 Reviews)
6.1
kamosion

Please see PMB.

$250 USD in 3 days
(9 Reviews)
5.2
Popokatepetle

I can do it. Please, check PMB

$250 USD in 6 days
(7 Reviews)
5.2
Andrewmyk

Hello. Think I can do this program for Windows with nice GUI and all functionality you need. Best regards, Andrew.

$500 USD in 6 days
(7 Reviews)
4.8
logicland

We can do this for you.

$250 USD in 10 days
(5 Reviews)
4.7
CoVaLiDiTy

can help you. tnx.

$700 USD in 0 days
(31 Reviews)
4.8
Peterpay

see pmb for more details.

$750 USD in 3 days
(17 Reviews)
4.4
wincent

can be done.

$600 USD in 4 days
(10 Reviews)
4.5
msoftsolution

hi,we can do it

$250 USD in 3 days
(3 Reviews)
3.0
Xyris

I will provide you GUI. Please see PM. Thanks.

$700 USD in 2 days
(2 Reviews)
2.8
katsonis

I have long experience in developing add-ons for MS Office products. I can easily complete the project. Thank you

$450 USD in 7 days
(1 Review)
2.0
infowareindia

Please see PM for details, thanks

$650 USD in 15 days
(1 Review)
3.1
segeyplus

Hello. I could do with Excel almost everything imaginable. Once I have made in Excel self educating computer game using genetical algorithm with full visualization. Look PM please for some ideas. Sergey S.

$300 USD in 4 days
(0 Reviews)
0.0
nobleinfosys2

4 years of experiance in dot net. just contact me. give me project or not that dosent matter. I have many satisfied clients. price negotiable. I have worked on same kind of project before. Its a microsoft office applic More

$400 USD in 10 days
(0 Reviews)
0.0
prasliv

hi, Please read pm. Thank you.

$750 USD in 30 days
(0 Reviews)
0.0
srera11

quality service assured. i am a sun certified programmer having more than 5 years of experience in software development.

$500 USD in 10 days
(0 Reviews)
0.0
estebansalsano

Im a Computer Enginner and i had a lot of experience working with applications for migrate and generate reports in diferents formats (XML, Excel, Word, PDF, etc). Expect a excelent quality project with a good GUI, well More

$500 USD in 7 days
(0 Reviews)
0.0
gkotpalliwar

I have done may projects based on excel data extraction and loading them into either database or work or any other content. I can get it done in 5 days.

$350 USD in 5 days
(0 Reviews)
0.0
markomys

Hi, I have done Excel extracting and pdf reporting many times in database report needings. C# / GUI. thanks, regards

$600 USD in 7 days
(0 Reviews)
0.0