importing from asp to excel worksheets

I'm trying to import data from an array into a spreadsheet using xml
but I am having trouble with getting the data to go into different
worksheets.

In the header I have the xml portion



<% for i=1 to rowcount %>

<%=array(i) %>
which creates the separate worksheets.

How would I get the data in the body of the html to go into the correct
worksheet? Everything goes into the first sheet.

Laura