Home Forums SQL Server 2005 T-SQL (SS2K5) SQL 2005 into designed Excel via Stored Procedure. RE: SQL 2005 into designed Excel via Stored Procedure.

  • August 6, 2013 at 2:15 pm

    #1639115

    Koen Verbeeck (8/6/2013)

    BOR15K (8/6/2013)

    I guess I need to look for another solution as customer's sites do not have SSRS installed.

    Any other advise, please?

    Kind Regards

    The only tool in the SQL Server stack that can format Excel files is SSRS.

    All the others (SSIS for example) just dump the raw data into the Excel file. You could try to work with named ranges though as destinations in SSIS, but SSIS is not included in SQL Server express.

    Macro's are always another alternative. You take an excel file with the layout already present and you fetch the data using a macro.

    I see there is also an option to export into html style file and just to change its extension. But then my issue is an image. Although I have converted it into base64 and can see it in html, in the excel it ignores it and just shows the x instead.

    <html xmlns:v="urn:schemas-microsoft-com:vml"

    xmlns:o="urn:schemas-microsoft-com:office:office"

    xmlns:x="urn:schemas-microsoft-com:office:excel"

    xmlns="http://www.w3.org/TR/REC-html40">

    Thanks a lot!