Hi,
I have an excel document that's going to be a very long list and i want to automate my process using
java.
So i have 5 columns with information that i will need to use to create this new excel sheet. See example:
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
And i want to take that and make it look like this:
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
The idea is that i'm going to take the CatID and use it to create the image file name.
How would i accomplish this?
Thanks in advance