Create an Excel sheet Dynamically in for each loop containe

• rahulabhinav15

  SSC Veteran

  Points: 237

  More actions

  June 4, 2014 at 1:01 pm

  #286267

  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!!!

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  June 4, 2014 at 2:34 pm

  #1719008

  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