June 4, 2014 at 1:01 pm
I have a for each loop(ADO Enumerator) container which executes for each Advertiserid which is coming from database.In for each loop I have to create a new excel file with the advertiser name.So if the loop executes 7 times there should be seven excel spreadsheets with seven advertiser names.
How can i create an excel dynamically in the foreach loop container.Can anyone please help!!!
June 4, 2014 at 2:34 pm
An easy trick is to have an empty excel file somewhere.
Each time you enter the loop, you copy the file to the directory you want it to be and you rename it.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy