After reading a lot of posts regarding appending information into the same excel sheet, it doesn’t appear that this is something that can be done at this time. Debbie, I noticed on one of your latest postings that this was an enhancement request you were going to submit. I was going to check and see if this was submitted and if this would be a feature of a future product such as 3.6. With the ability to run the loop dataset, we would like to utilize this but allow each pull of the query to append to a single worksheet or .csv file, instead of either creating new worksheets or new workbooks. This would be extremely beneficial for us, because we utilize around 10 different databases and the loop data set could make things run a lot quicker and essentially, this would work in place of a union operation in the SQL combining the data into one worksheet.
It seems like you have had a lot a questions on it, so I hope it is some type of enhancement to come.