Octopus reporting with an excel template
To help you get started, we provide a sample Excel spreadsheet that you can connect to your own Octopus Server.
The fastest way to get started is to use our Excel spreadsheet template. The spreadsheet uses Pivot Tables and Pivot Charts to summarize the data. You can use it as a starting point, and then modify or adapt it to suit your needs.
First, download the template and open it in Excel. The template fetches data from our public Demo Octopus Server.
Please make sure you unblock the file after downloading it, otherwise you may get a misleading error message like:
The file is corrupt and cannot be opened
To change the source of the data:
Go to the DATA ribbon tab in Excel, then click Queries & Connections:
Select the Octopus Deployment history connection, then click Properties...
Go to the Definition tab, then click Browse...
In the Select Data Source menu, instead of selecting a file, enter your reporting URL, then Open. To get your reporting URL, see the section below on Using the XML Feed.
Refreshing the data
Once you have set up your connection, you can refresh the data from the source whenever you like. If you make your own customizations to the spreadsheet, you can save them, and simply refresh the data in the sheet whenever you like.
Using the XML feed
The best way to consume reporting data from Octopus is using the XML feed. The feed is always available at:
<OCTOPUS-SERVER>is the hostname of your Octopus Server
<API-KEY>is one of your API keys
The XML feed can be consumed programmatically, or via Excel or Microsoft PowerBI. We have a blog on how to do this using PowerBI
Since a user-specific API key is used to consume the data, only data that the user can see will appear in the report.
If you encounter the following error when using your own Octopus Server
Unhandled exception from web server: The parameter is incorrect System.Net.HttpListenerException (0x80004005): The parameter is incorrect at System.Net.HttpResponseStream.Dispose(Boolean disposing) at System.IO.Stream.Close() at Octopus.Server.Web.OctopusNancyHost.OutputWithDefaultTransferEncoding(Response nancyResponse, HttpListenerResponse response) in Y:\work\refs\tags\3.2.0\source\Octopus.Server\Web\OctopusNancyHost.cs:line 353 at Octopus.Server.Web.OctopusNancyHost.ConvertNancyResponseToResponse(NancyContext nancyRequest, Response nancyResponse, HttpListenerResponse response) in Y:\work\refs\tags\3.2.0\source\Octopus.Server\Web\OctopusNancyHost.cs:line 339 at Octopus.Server.Web.OctopusNancyHost.Process(HttpListenerContext ctx) in Y:\work\refs\tags\3.2.0\source\Octopus.Server\Web\OctopusNancyHost.cs:line 447
This is due to that the revocation information for the certificate is not retrievable, to get around it, do the following
- Click New Source....
- Data Feed.
- Fill in your URL in the Link or File: field.
- Click Browse....
- This should give you a Security Alert "Revocation information for the security certificate for this site is not available. Do you want to proceed?"
- Click Yes.
- Cancel the File Open dialog.
- Cancel the Data Connection Wizard.
- Paste the URL in the File Name field.
Need support? We're here to help.