Query to Excel Stored Procedure

  • Darko Martinović

    Hall of Fame

    Points: 3535

    Comments posted to this topic are about the item Query to Excel Stored Procedure

  • Eirikur Eiriksson

    SSC Guru

    Points: 182347

    Nice piece Darko, thank you for this!
    😎

  • jbowers

    Old Hand

    Points: 343

    Darko, nice article with lots of great detail. I thought this might give me a 4th option for my query results; Results to Text, Results to Grid, Results to File, and now... Results to Excel?!?  When I got to the line "...SpreadSheetGear is commercial software that cannot be distributed without license", I popped over to https://www.spreadsheetgear.com/downloads/purchase.aspx to learn that their licenses go for $999. I can buy an Excel license for $129.99, which got me thinking, "Why would I ever want to do this instead of just copying the query results from the SSMS grid and pasting it into a blank Excel workbook, where I can then manipulate it further?"

    I was intrigued by the premise, which is why I read the article. You did a great job of documenting all of the of very detailed steps required to make this work. But I'm curious as to what you think the real-world application of this technique would be.

  • Robert Sterbal

    SSChampion

    Points: 10954

    jbowers - Monday, March 5, 2018 9:12 AM

    Darko, nice article with lots of great detail. I thought this might give me a 4th option for my query results; Results to Text, Results to Grid, Results to File, and now... Results to Excel?!?  When I got to the line "...SpreadSheetGear is commercial software that cannot be distributed without license", I popped over to https://www.spreadsheetgear.com/downloads/purchase.aspx to learn that their licenses go for $999. I can buy an Excel license for $129.99, which got me thinking, "Why would I ever want to do this instead of just copying the query results from the SSMS grid and pasting it into a blank Excel workbook, where I can then manipulate it further?"

    I was intrigued by the premise, which is why I read the article. You did a great job of documenting all of the of very detailed steps required to make this work. But I'm curious as to what you think the real-world application of this technique would be.

    The reviews of Excel 2016 were comically bad. Wow.

    412-977-3526 call/text

  • x

    SSC-Insane

    Points: 23433

    jbowers - Monday, March 5, 2018 9:12 AM

    Darko, nice article with lots of great detail. I thought this might give me a 4th option for my query results; Results to Text, Results to Grid, Results to File, and now... Results to Excel?!?  When I got to the line "...SpreadSheetGear is commercial software that cannot be distributed without license", I popped over to https://www.spreadsheetgear.com/downloads/purchase.aspx to learn that their licenses go for $999. I can buy an Excel license for $129.99, which got me thinking, "Why would I ever want to do this instead of just copying the query results from the SSMS grid and pasting it into a blank Excel workbook, where I can then manipulate it further?"

    I was intrigued by the premise, which is why I read the article. You did a great job of documenting all of the of very detailed steps required to make this work. But I'm curious as to what you think the real-world application of this technique would be.

    I rated this article a 1 based on the licensing price.

  • Darko Martinović

    Hall of Fame

    Points: 3535

    Eirikur Eiriksson - Monday, March 5, 2018 8:33 AM

    Nice piece Darko, thank you for this!
    😎

    Thank you Eirikur 🙂

  • Darko Martinović

    Hall of Fame

    Points: 3535

    jbowers - Monday, March 5, 2018 9:12 AM

    Darko, nice article with lots of great detail. I thought this might give me a 4th option for my query results; Results to Text, Results to Grid, Results to File, and now... Results to Excel?!?  When I got to the line "...SpreadSheetGear is commercial software that cannot be distributed without license", I popped over to https://www.spreadsheetgear.com/downloads/purchase.aspx to learn that their licenses go for $999. I can buy an Excel license for $129.99, which got me thinking, "Why would I ever want to do this instead of just copying the query results from the SSMS grid and pasting it into a blank Excel workbook, where I can then manipulate it further?"

    I was intrigued by the premise, which is why I read the article. You did a great job of documenting all of the of very detailed steps required to make this work. But I'm curious as to what you think the real-world application of this technique would be.

    The solution could be incorporated in SQL Server Agent jobs.For example, when you have to generate an Excel file without starting SSMS.

    Of course, there is a situation when you have to copy &paste, many times.
    I met  many people their job is to  copy and paste query results many times daily and do some basic Excel formatting.It is easy when Excel file contains only one sheet, but when contains ten or twelve, copying and pasting does not make sense.

    Of course, there is no sense to bay a license, only for consuming ‘Query To Excel’ stored procedure. If you are already licensed, for.NET developing, you might consider what I write above.

    Btw, there is an option to transform a query result to HTML which is described in my article

    http://www.sqlservercentral.com/articles/SQLCLR/156474/

  • Darko Martinović

    Hall of Fame

    Points: 3535

    robert.sterbal 56890 - Monday, March 5, 2018 10:54 AM

    jbowers - Monday, March 5, 2018 9:12 AM

    Darko, nice article with lots of great detail. I thought this might give me a 4th option for my query results; Results to Text, Results to Grid, Results to File, and now... Results to Excel?!?  When I got to the line "...SpreadSheetGear is commercial software that cannot be distributed without license", I popped over to https://www.spreadsheetgear.com/downloads/purchase.aspx to learn that their licenses go for $999. I can buy an Excel license for $129.99, which got me thinking, "Why would I ever want to do this instead of just copying the query results from the SSMS grid and pasting it into a blank Excel workbook, where I can then manipulate it further?"

    I was intrigued by the premise, which is why I read the article. You did a great job of documenting all of the of very detailed steps required to make this work. But I'm curious as to what you think the real-world application of this technique would be.

    The reviews of Excel 2016 were comically bad. Wow.

    Americans used to write TL;DR when the article is a little bit longer.
    I'm sorry your expectation is not fulfilled.
    But is a compromise.
    For those who are interested in the topic is quite enough.
    IMO it is not realistic to expect that SSC will teach you Excel or SSG object model.

Viewing 8 posts - 1 through 8 (of 8 total)

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