Exporting to Excel Using a CLR Stored Procedure

  • Anders Pedersen

    SSChampion

    Points: 11410

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

  • Tim Wolf

    SSC Enthusiast

    Points: 112

    Where is the CLR source attachment?

  • tejwanigulab

    SSC Rookie

    Points: 49

    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

    Where is the Source Code attachment?

  • Shubhajyoti Ghosh

    SSC Veteran

    Points: 203

    Good attempt, But where is your source code ?

    Regards,

    Shubha

    http://www.freegamingnow.com/

  • Praveen Balanagendra

    Grasshopper

    Points: 11

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

  • gerhard.vanniekerk-1031535

    SSC Rookie

    Points: 39

    CLR Download or source?

  • Madhivanan-208264

    SSCertifiable

    Points: 7405

    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

    SSC Rookie

    Points: 41

    Yeah the source code would be nice 😉

  • matija.gluhak

    Grasshopper

    Points: 13

    +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

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

  • bharathsivam

    SSC Journeyman

    Points: 93

    Attachment (ExcelExport.dll) is missing.

  • Rob Fisk

    SSCommitted

    Points: 1841

    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

    Looking forward to test it. Exactly what I need

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

  • h 47762

    SSC Rookie

    Points: 46

    Nice, but where is the .... ?

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

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