Upload Results of TSQL Query to XLSX in SharePoint Document Library

• Brandon Forest

  SSCommitted

  Points: 1977

  More actions

  January 6, 2021 at 7:35 pm

  #3828244

  I inherited a manually produced report where I take the results of a TSQL query, and save it to a specific SharePoint document library as an XLSX file. To automate this report, I've experimented with SQLCmd and SSRS. The problem with both of those methods is that 1 or 2 intermediate files are produced. The first is a CSV, and the second is a XLSX file.

  I'm prototyping a PowerShell script to use the Invoke-SQL command to create a recordset object that is used to create an XLSX object before exporting the file to the final destination on the SharePoint site. I'm looking for a clear-cut example on how to render TSQL results as an XLSX object and then push it up to the SharePoint site, without producing a file on disk.

  Any PowerShell gurus that can point a finger in the right direction for me?

  Thanks!

  Brandon.Forest@RiverCityBank.com

  Senior SQL DBA

  • This topic was modified 4 years, 4 months ago by Brandon Forest.

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  January 7, 2021 at 8:10 pm

  #3828718

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.