Find Jobs
Hire Freelancers

Desktop App to Merge Two CSV Files and create an Excel File

$30-100 USD

Cancelled
Posted almost 16 years ago

$30-100 USD

Paid on delivery
I have two csv files that share a common word. A desktop program needs to be developed that gets specific fields from both files and creates an excel spreadsheet (not just a csv file to import into excel). Code needs to be placed on each of the columns on the excel spreadsheet so that clicking it will sort the entire data by the contents of that field. ## Deliverables Either the program need to be statically linked so that it can just run as a standalone EXE requiring no installation program or alternatively an installation program needs to be included to do a standard install on a windows xp machine The csv input files may be delimited by space, tab, or comma. The program needs to create an excel spreadsheet as output that can be opened up and will be formatted with headings (bold, etc). A sample will be provided. Code needs to be embedded (VBAScript or whatever) so that when a button is clicked on each column all rows of the output are sorted by that column (This is to make it easier for the user to sort). The program needs to have a bit of error checking in it so that if (for example) two input files were chosen and they do not share a common key, it should show this error on the screen. It should also on a dialog screen that it is about to proceed (before creating the excel spreadsheet) that shows the number of records in each files, number of records matched, and number of records with no matches (where a common key does not exist in both). The actual data should be in csv or other delimited type format (pretty standard format). I will supply a sample of the data before you start. Data is stored one line at a time in both files, so should be easy to manipulate. Only certain fields would be required from each csv to be placed into the excel, not all of them. There should be a simple properties of xml configuration file to allow the user to define the total number of fields in each file, the type of delimited, and whether the field is to be included in the excel spreadsheet. There should also be a setting in the file to easily indicate the field order (left to right) of fields being placed in the excel spreadsheet.
Project ID: 3954993

About the project

21 proposals
Remote project
Active 16 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
21 freelancers are bidding on average $86 USD for this job
User Avatar
See private message.
$84.15 USD in 7 days
5.0 (122 reviews)
8.3
8.3
User Avatar
See private message.
$68 USD in 7 days
4.9 (90 reviews)
6.1
6.1
User Avatar
See private message.
$51 USD in 7 days
5.0 (51 reviews)
5.5
5.5
User Avatar
See private message.
$102 USD in 7 days
4.9 (26 reviews)
5.4
5.4
User Avatar
See private message.
$103.70 USD in 7 days
4.7 (44 reviews)
4.9
4.9
User Avatar
See private message.
$297.50 USD in 7 days
5.0 (41 reviews)
4.8
4.8
User Avatar
See private message.
$42.50 USD in 7 days
5.0 (25 reviews)
4.7
4.7
User Avatar
See private message.
$59.50 USD in 7 days
4.4 (15 reviews)
4.4
4.4
User Avatar
See private message.
$25.50 USD in 7 days
4.6 (16 reviews)
4.4
4.4
User Avatar
See private message.
$29.75 USD in 7 days
4.7 (5 reviews)
4.0
4.0
User Avatar
See private message.
$42.50 USD in 7 days
4.4 (25 reviews)
3.9
3.9
User Avatar
See private message.
$41.65 USD in 7 days
4.2 (11 reviews)
3.1
3.1
User Avatar
See private message.
$68 USD in 7 days
4.5 (4 reviews)
3.0
3.0
User Avatar
See private message.
$59.50 USD in 7 days
5.0 (12 reviews)
2.9
2.9
User Avatar
See private message.
$42.50 USD in 7 days
5.0 (1 review)
2.2
2.2
User Avatar
See private message.
$425 USD in 7 days
5.0 (2 reviews)
2.1
2.1
User Avatar
See private message.
$68 USD in 7 days
5.0 (2 reviews)
0.0
0.0
User Avatar
See private message.
$6.80 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$76.50 USD in 7 days
0.0 (2 reviews)
0.0
0.0
User Avatar
See private message.
$42.50 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of PHILIPPINES
Salisbury, Philippines
5.0
532
Member since Oct 16, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.