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:
[TABLE="width: 543"]
<tbody>[TR]
[TD]CatID[/TD]
[TD]Website[/TD]
[TD]Level[/TD]
[TD] Access[/TD]
[TD] AccessKey[/TD]
[/TR]
[TR]
[TD]honda[/TD]
[TD]www.honda.com[/TD]
[TD="align: right"]2[/TD]
[TD]https://access.car-me.com[/TD]
[TD]65ri9387rg 34fdwtrw32[/TD]
[/TR]
[TR]
[TD]toyota[/TD]
[TD]www.toyota.com[/TD]
[TD="align: right"]2[/TD]
[TD]https://access.car-me.com[/TD]
[TD]t34t34t34yu56g36ert43[/TD]
[/TR]
[TR]
[TD]acura[/TD]
[TD]www.acura.com[/TD]
[TD="align: right"]2[/TD]
[TD]https://access.car-me.com[/TD]
[TD]nftr65237u6t24125y547[/TD]
[/TR]
[TR]
[TD]hyundai[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD]https://access.car- me.com[/TD]
[TD]46332r347656uhjndatw[/TD]
[/TR]
</tbody>[/TABLE]

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

[TABLE="width: 2479"]
<tbody>[TR]
[TD]CatID[/TD]
[TD]Website[/TD]
[TD]Previmage[/TD]
[TD]Previmage2[/TD]
[TD]WebEntrance[/TD]
[TD]WebEntrance2[/TD]
[TD]Mobileimage[/TD]
[TD]Mobileimage2[/TD]
[TD]Access[/TD]
[TD]level[/TD]
[TD]AccessKey[/TD]
[/TR]
[TR]
[TD]honda[/TD]
[TD]www.honda.com[/TD]
[TD]cars/images/honda/Red/car_honda_color.jpg[/TD]
[TD]cars/images/honda/Red/car_honda_color2x.jpg[/TD]
[TD]cars/images/honda/Red/car_honda_color.jpg[/TD]
[TD]cars/images/honda/Red/car_honda_color2x.jpg[/TD]
[TD]cars/images/honda/Red/car_honda_color.jpg[/TD]
[TD]cars/images/honda/Red/car_honda_color2x.jpg[/TD]
[TD]https://access.car-me.com[/TD]
[TD="align: right"]2[/TD]
[TD]65ri9387rg 34fdwtrw32[/TD]
[/TR]
[TR]
[TD]toyota[/TD]
[TD]www.toyota.com[/TD]
[TD]cars/images/toyota/Red/car_toyota_color.jpg[/TD]
[TD]cars/images/toyota/Red/car_toyota_color2x.jpg[/TD]
[TD]cars/images/toyota/Red/car_toyota_color.jpg[/TD]
[TD]cars/images/toyota/Red/car_toyota_color2x.jpg[/TD]
[TD]cars/images/toyota/Red/car_toyota_color.jpg[/TD]
[TD]cars/images/toyota/Red/car_toyota_color2x.jpg[/TD]
[TD]https://access.car-me.com[/TD]
[TD="align: right"]2[/TD]
[TD]t34t34t34yu56g36ert43[/TD]
[/TR]
[TR]
[TD]acura[/TD]
[TD]www.acura.com[/TD]
[TD]cars/images/acura/Red/car_acura_color.jpg[/TD]
[TD]cars/images/acura/Red/car_acura_color2x.jpg[/TD]
[TD]cars/images/acura/Red/car_acura_color.jpg[/TD]
[TD]cars/images/acura/Red/car_acura_color2x.jpg[/TD]
[TD]cars/images/acura/Red/car_acura_color.jpg[/TD]
[TD]cars/images/acura/Red/car_acura_color2x.jpg[/TD]
[TD]https://access.car-me.com[/TD]
[TD="align: right"]2[/TD]
[TD]nftr65237u6t24125y547[/TD]
[/TR]
[TR]
[TD]hyundai[/TD]
[TD][/TD]
[TD]cars/images/hyundai/Red/car_hyundai_color.jpg[/TD]
[TD] cars/images/hyundai/Red/car_hyundai_color2x.jpg[/TD]
[TD] cars/images/hyundai/Red/car_hyundai_color.jpg[/TD]
[TD]cars/images/hyundai/Red/car_hyundai_color2x.jpg[/TD]
[TD]cars/images/hyundai/Red/car_hyundai_color.jpg[/TD]
[TD]cars/images/hyundai/Red/car_hyundai_color2x.jpg[/TD]
[TD]https://access.car-me.com[/TD]
[TD="align: right"]2[/TD]
[TD]46332r347656uhjndatw[/TD]
[/TR]
</tbody>[/TABLE]

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