File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JavaFX and the fly likes Read and write from excel to excel - automated Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JavaFX
Bookmark "Read and write from excel to excel - automated" Watch "Read and write from excel to excel - automated" New topic
Author

Read and write from excel to excel - automated

Jeffreyy Smith
Greenhorn

Joined: Aug 20, 2013
Posts: 2
Hello Everyone,

Column A
Water
salt

I want to take Column A from sheet 1 and create the following in another sheet. Row by row. Column A is going to have hundreds of entry and I would need to automate this process
cat/images/[column A]/type/an_[ column A]_color.jpg
cat/images/[column A]/type/an_[ column A]_color2x.jpg
cat/images/[column A]/black/an_[ column A]_black.jpg
cat/images/[column A]/black/an_[ column A]_black2x.jpg

e.g.
cat/images/water/type/an_water_color.jpg
cat/images/water/type/an_water_color2x.jpg

cat/images/water/black/an_water_black.jpg
cat/images/water/black/an_water_black2x.jpg

Thanks so much in advance
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Read and write from excel to excel - automated