Exporting to Excel Using a CLR Stored Procedure

Question

Post reply

Exporting to Excel Using a CLR Stored Procedure

Anders Pedersen

SSChampion

Points: 11410
More actions
December 1, 2009 at 10:23 pm

#218176

Comments posted to this topic are about the item <A HREF="/articles/SQLCLR/68842/">Exporting to Excel Using a CLR Stored Procedure</A>

Viewing 15 posts - 1 through 15 (of 124 total)

You must be logged in to reply to this topic. Login to reply

Tim Wolf SSC Enthusiast Points: 112 More actions · Answer 1

Tim Wolf

SSC Enthusiast

Points: 112

December 1, 2009 at 10:26 pm

#1086261

Where is the CLR source attachment?

tejwanigulab SSC Rookie Points: 49 More actions · Answer 2

But its of no use for somebody whose application supports the three databases MSSQL, Sybase and Oracle. I guess we don't have anything like this for Sybase and Oracle.

arora.sandeep Grasshopper Points: 14 More actions · Answer 3

arora.sandeep

Grasshopper

Points: 14

December 1, 2009 at 11:35 pm

#1086272

Where is the Source Code attachment?

Shubhajyoti Ghosh SSC Veteran Points: 203 More actions · Answer 4

Good attempt, But where is your source code ?

Regards,

Shubha

http://www.freegamingnow.com/

Praveen Balanagendra Grasshopper Points: 11 More actions · Answer 5

Could not find the source code or the dll mentioned in the article.

gerhard.vanniekerk-1031535 SSC Rookie Points: 39 More actions · Answer 6

gerhard.vanniekerk-1031535

SSC Rookie

Points: 39

December 2, 2009 at 1:30 am

#1086297

CLR Download or source?

Madhivanan-208264 SSCertifiable Points: 7516 More actions · Answer 7

This is another method that uses OPENROWSET command which doesnot require CLR

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail

DeWet Valued Member Points: 61 More actions · Answer 8

DeWet

Valued Member

Points: 61

December 2, 2009 at 1:59 am

#1086308

Yeah the source code would be nice 😉

matija.gluhak Grasshopper Points: 13 More actions · Answer 9

+1 to "where is the source code ?" you mentioned.

I could use that CLR but i would like to add some specific things in it (like sending dynamic SQL, sending list of columns you like to export and replaced with captions you send as another parameter .. etc.)

ashutosh.pathak SSC Journeyman Points: 80 More actions · Answer 10

ashutosh.pathak

SSC Journeyman

Points: 80

December 2, 2009 at 2:36 am

#1086323

Where is source code!!!!!!!!!!!!!!!!!

bharathsivam SSC Enthusiast Points: 158 More actions · Answer 11

bharathsivam

SSC Enthusiast

Points: 158

December 2, 2009 at 3:13 am

#1086334

Attachment (ExcelExport.dll) is missing.

Rob Fisk SSCommitted Points: 1861 More actions · Answer 12

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.

[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]

alber-1003707 Grasshopper Points: 20 More actions · Answer 13

Looking forward to test it. Exactly what I need

http://www.xodox.ch - LCD vs Plasma

h 47762 SSC Rookie Points: 46 More actions · Answer 14

h 47762

SSC Rookie

Points: 46

December 2, 2009 at 4:03 am

#1086347

Nice, but where is the .... ?