July 7, 2009 at 6:23 am
Hi,
I want to create multiple excel files dynamically through Script Task.
In script task editor, I am trying to create an object of Excel.Application but unable due to Microsoft.Office library is not in references. When I tried to add reference, I couldn't find Microsft Excel 11.0 Object Library and also couldnt locate any option to add / import library in Script Task Editor.
Is there any other way to create excel files dynamically?
:rolleyes:
July 7, 2009 at 8:25 am
Are the field names / types always the same, or do they need to be dynamic too?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
July 7, 2009 at 8:28 am
There is a thread here - and specifically a post by NaffMonk - that seems relevant to what you are trying to do.
http://qa.sqlservercentral.com/Forums/Topic531295-148-2.aspx
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply