Exporting to Excel Using a CLR Stored Procedure

  • Anders Pedersen


    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


    Points: 14

    Where is the Source Code attachment?

  • Shubhajyoti Ghosh

    SSC Veteran

    Points: 203

    Good attempt, But where is your source code ?




  • Praveen Balanagendra


    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


    Points: 7516

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



    Failing to plan is Planning to fail

  • DeWet

    Valued Member

    Points: 61

    Yeah the source code would be nice 😉

  • matija.gluhak


    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


    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.

    Change is inevitable... Except from a vending machine.[/font]

  • alber-1003707


    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