Loading an Excel spreadsheet with script

[jandrew]

I need a script (PowerShell, VB, C#, etc) to load an excel spreadsheet to my Power BI Report Server. Can someone help?

[bradsy · Accepted solution]

There is a set of PS modules you can use. https://github.com/microsoft/ReportingServicesTools 

[Anonymous]

To start off we can use the SpreadJS files hosted on NPM. To do this, we can install using command line argument. Open up a command prompt and navigate to the location of your application. There, you can install the required files with one command. In this case, we need the base Spread-Sheets library, Spread-ExcelIO, and jQuery: