• Post Reply Bookmark Topic Watch Topic
  • New Topic

Read and write from excel sheet to another excel sheet using java  RSS feed

Jeffreyy Smith
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

Tony Docherty
Posts: 3271
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Welcome to the Ranch.

Have you looked at JExcel and/or POI
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!