Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

If you choose not to provide auth information, you'll need to enter it again at some point in the future. You can do that from the Connection | Properties | Definition | Edit Query section of Excel.

Google Docs

You can import your data into a Google spreadsheet by using Google's importXml feature. The importXml call accepts the report url so that it can find the report and an XPath query to parse it. It is really very easy to do.

  1. Make sure that you have a working report URL. See Report URLs above if you need help with this. 
    1. The format parameter must be set to xml. For example, http://app.projectorpsa.com/myReport?format=xml
    2. The dateformat parameter must be set to googledocs to parse dates. For example, http://app.projectorpsa.com/myReport?dateformat=googledocs
    3. The columnheaders parameter must be set to firstrow if you want each column to be named. For example, http://app.projectorpsa.com/myReport?columnheaders=firstrow
  2. Test your URL by cutting and pasting it into your web browser
  3. Select the first cell in the Google Docs spreadsheet.
  4. In the value field, enter the following, replacing url with the your tested url
Code Block
langhtml
titleGoogle Spreadsheet
=importXml("url", "Report/Rows/Row")

Image Removed