Closed

Read MySQL database and then create an excel file

This project was awarded to kalpesh2804 for $40.8 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
$30 - $50 USD
Total Bids
24
Project Description

I need you to built me a application that will run on Windows XP/Vista/7 that read mysql database and based on the database create a pricelist in Microsoft Excel 97/2000/XP format. You will need to format some cells with colors, text style (bold/underline, etc), adjust the column width based on the data width, format the cells that contain numbers with currency format, sort ascending based on particular column, etc. No GUI needed, I just need when I execute the app, it create a excel file. No GUI, no user interference, just execute and get the result (excel file). This application will need to read a configuration file (text file) that contain mysql credentials (servername/host, username, password, database name, table name), mysql field's name,title for excel column and which column for that field. This application will also need to read from another table to query data from two or more tables, based on a relationship between certain columns in these tables (SQL JOIN ?) and there will some rules involved. Any programming language is welcome. We will need to send me the source code after this project finish. Contact me with questions if you have any questions. Please make sure you know what we're going to create and how this works before you bid! Thanks

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online