Read and write from excel sheet to another excel sheet using java or vb

[ChuckFin]

Hi All,

I have an excel document that's a very long list and i want to automate my process with extract certain information for my new document, but using java. I am also open to vb.

So I have 5 columns with information that i will need to use to create this new excel sheet. See example:


Sample Source File:

CatID	Website	Level	Access	AccessKey
honda	www.honda.com	2	https://access.car-me.com	65ri9387rg 34fdwtrw32
toyota	www.toyota.com	2	https://access.car-me.com	t34t34t34yu56g36ert43
acura	www.acura.com	2	https://access.car-me.com	nftr65237u6t24125y547
hyundai		2	https://access.car- me.com	46332r347656uhjndatw

<tbody>
</tbody>

And i want to take that and make it look like this:
"cars/images/[INSERT CatID]/car_[INSERT CatID]_color.jpg"

CatID	Website	Previmage	Previmage2	WebEntrance	WebEntrance2	Mobileimage	Mobileimage2	Access	level	AccessKey
honda	www.honda.com	cars/images/honda/Red/car_honda_color.jpg	cars/images/honda/Red/car_honda_color2x.jpg	cars/images/honda/Red/car_honda_color.jpg	cars/images/honda/Red/car_honda_color2x.jpg	cars/images/honda/Red/car_honda_color.jpg	cars/images/honda/Red/car_honda_color2x.jpg	https://access.car-me.com	2	65ri9387rg 34fdwtrw32
toyota	www.toyota.com	cars/images/toyota/Red/car_toyota_color.jpg	cars/images/toyota/Red/car_toyota_color2x.jpg	cars/images/toyota/Red/car_toyota_color.jpg	cars/images/toyota/Red/car_toyota_color2x.jpg	cars/images/toyota/Red/car_toyota_color.jpg	cars/images/toyota/Red/car_toyota_color2x.jpg	https://access.car-me.com	2	t34t34t34yu56g36ert43
acura	www.acura.com	cars/images/acura/Red/car_acura_color.jpg	cars/images/acura/Red/car_acura_color2x.jpg	cars/images/acura/Red/car_acura_color.jpg	cars/images/acura/Red/car_acura_color2x.jpg	cars/images/acura/Red/car_acura_color.jpg	cars/images/acura/Red/car_acura_color2x.jpg	https://access.car-me.com	2	nftr65237u6t24125y547
hyundai		cars/images/hyundai/Red/car_hyundai_color.jpg	cars/images/hyundai/Red/car_hyundai_color2x.jpg	cars/images/hyundai/Red/car_hyundai_color.jpg	cars/images/hyundai/Red/car_hyundai_color2x.jpg	cars/images/hyundai/Red/car_hyundai_color.jpg	cars/images/hyundai/Red/car_hyundai_color2x.jpg	https://access.car-me.com	2	46332r347656uhjndatw

<tbody>
</tbody>

So, the idea is that i want to take the CatID and use it to create the name of the file of the .jpg and also in the path. See honda in bold. Its also case sensitive

The structure that i want to accomplish is:

cars/images/[INSERT CatID]/car_[INSERT CatID]_color.jpg

Everything else is much dymanic


I can provide more information, if needs be.
Thanks in advance for all the help