In Progress

Excel add-in to import csv as text fields

I want to create an Excel add-in that does the following:

If the file being opened (Workbook_Open event) is .csv and column values are in quotes, then import columns as text field type.

Excel annoyingly tries to reinterpret fields and determine their type on open, which means zip code fields are interpreted as numbers and lose leading zeroes, etc. If installed, this add-in should automatically open .csv file fields as text type unless the values are not wrapped in quotes (text qualifier). The add-in should also not impede the manual data import functionality in any way (in other words -- people could still walk through the data import and select field types manually -- this add-in only impacts the default behavior for csv files).

Skills: Excel

See more: csv excel add, excel csv add, excel csv import add, excel add import csv, text qualifier excel, import csv fields text, excel add csv import, interpreted code, interpreted, reinterpret csv excel, add csv import, open csv add, excel import csv add, add text qualifier excel, csv excel add import, tries, excel add, CSV, add functionality, csv excel text, column text, add field code, csv text file, create 2010 add excel, excel text column

About the Employer:
( 1 review ) Albany, United States

Project ID: #833898

Awarded to:

thnam

Hi, I can do it. Give me a sample file and I will do it for check. Thanks.

$30 USD in 1 day
(3 Reviews)
2.3

5 freelancers are bidding on average $106 for this job

abhipan007

i have good [url removed, login to view] exp of so many projects in india

$180 USD in 5 days
(0 Reviews)
0.0
discoveryIT

We are a team of 3 developers, our experience varies from 3 to 5 years. We have excellent experience in VSTO (Visual Studio Tools for Office) projects. We have already made some add-ins before.

$90 USD in 10 days
(0 Reviews)
0.0
prabhat48

i am ready to do this project.

$30 USD in 5 days
(0 Reviews)
0.0
pfizer

Please check PM

$200 USD in 10 days
(0 Reviews)
0.0