• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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

 
Bartender
Posts: 3323
86
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Welcome to the Ranch.

Have you looked at JExcel and/or POI
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic