This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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
 
 
subject: Read and write from excel to excel - automated
 
Similar Threads
problem in reading data from Excel Sheet
opening Excel sheet
cewolf charts
Reading Data from Excel Sheets
Reading data from Excel Sheets