Page Comparison

...

Import your data directly into Microsoft Excel. By binding your Excel report to a report web url, you can rerun the report, updating all your numbers, but not lose all the custom formatting that you may have applied in Excel. This is a great alternative to Excel and Access DatabasesRefresh Files because it removes the overhead of saving out of Projector and having access to a network drive. The following instructions are for Excel 2010.

...

2. In the dialog that appears enter your report url. Remember to set the format to XML. If you don't provide authentication information in the URL, either via user password, auth token, or session ticket - then you'll be prompted to enter your username/password.   Be sure to select the table by clicking on the yellow right arrow before clicking Import.

3. Click Import

4. If you receive the following error dialog it can be safely ignored

...

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

=importXml("url", "Report/Rows/Row")

Image Removed