Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12345»»»

Exporting to Excel Using a CLR Stored Procedure Expand / Collapse
Author
Message
Posted Wednesday, December 2, 2009 2:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 9, 2009 9:17 PM
Points: 4, Visits: 6
Where is source code!!!!!!!!!!!!!!!!!
Post #827274
Posted Wednesday, December 2, 2009 3:13 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, December 2, 2009 10:43 PM
Points: 12, Visits: 26
Attachment (ExcelExport.dll) is missing.
Post #827287
Posted Wednesday, December 2, 2009 3:21 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 22, 2014 8:32 AM
Points: 163, Visits: 428
Calm down everyone. Source has already been asked for repeatedly. Give it time.

Thanks for opening this alternative avenue.
It looks as if it could be a bit more flexible than the OPENROWSET and BCP examples if used within a SP for creation of a new sheet. I'm assuming it will have similar problems if called from an application in that the path will be local to the SQL server (thinking within a network, not over the internet of course).

Though if it was a web based application then that could be used to retrieve the sheet easily enough.



_______________________________________________________
Change is inevitable... Except from a vending machine.
Post #827290
Posted Wednesday, December 2, 2009 3:28 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 2:12 AM
Points: 12, Visits: 22
Looking forward to test it. Exactly what I need





http://www.xodox.ch - LCD vs Plasma
Post #827292
Posted Wednesday, December 2, 2009 4:03 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, March 5, 2010 2:49 AM
Points: 10, Visits: 3
Nice, but where is the .... ?
Post #827304
Posted Wednesday, December 2, 2009 4:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 26, 2014 6:38 AM
Points: 8, Visits: 64
Interesting.
But source code/DLL please?
Post #827324
Posted Wednesday, December 2, 2009 4:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 24, 2012 6:15 AM
Points: 8, Visits: 148
very good but, can't use with SQL2005....
Post #827325
Posted Wednesday, December 2, 2009 4:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 14, 2014 7:48 AM
Points: 1, Visits: 23
I love it - I think. Where is the download?
Post #827326
Posted Wednesday, December 2, 2009 4:53 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, October 19, 2012 4:32 AM
Points: 59, Visits: 22
Hi,

What kind of running times are we looking at? Say 1000 rows over 10 workbooks?
Obviously different kit will give different results but say just an average time.

Thanks
Post #827327
Posted Wednesday, December 2, 2009 5:01 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 6:57 AM
Points: 10, Visits: 27
Hi,

2 questions:
1. Will it work on SQL 2005?
2. Will I need to install Excel or other Office components on SQL Server machine?

Thanks,
Evgeny.
Post #827332
« Prev Topic | Next Topic »

Add to briefcase ««12345»»»

Permissions Expand / Collapse