Using a Loop Value for an Object Assignment

[Steve Dyke]

I am trying to attempt the following with no success:

for(int i = 0; i < rtQueuesArray.length; i++){
		 			 		
HSSFSheet sheet(i) = wb.createSheet(rtQueuesArray[i]);

}

[Bear Bibeault]

You have a function call on the right-hand side of the assignment. What is it that you are expecting that to do?

[Steve Dyke]

Bear Bibeault wrote:You have a function call on the right-hand side of the assignment. What is it that you are expecting that to do?

I want to create several sheets with different tab names. Then I will run another loop on a data array to populate each sheet. This second loop will have to know what each sheet object name is.

[Bear Bibeault]

Perhaps an array?

[Steve Dyke]

Bear Bibeault wrote:Perhaps an array?

Can you elaborate? I have an array of tab names. My loop iterates through this array creating the HSSFSheets. However, I need the HSSFSheet objects to retain unique names so I can reference them latter in my code.

[Bear Bibeault]

You can reference them just as easily using an array. But if you also need unique names, perhaps a Map?

[Rob Spoor]

Perhaps you want a Map<String,HSSFSheet>.