Data Extraction API, October 2013
Import data into Excel with a web services request (URI) specifying the Excel format.
You can use Excel 2003, Excel 2007 or Excel 2010 to import data with the web services. In Excel 2007 and 2010, there are limitations with refreshing XML data. For this reason, the HTML format is recommended.
Note: The From Web option is recommended, because if you select to import data from a secure data source, and then use Refresh All on the imported data, an error occurs.
The New Web Query window opens.
The Select Data Source window opens.
Note: The Select Data Source window provides local files for selection, but a URI is valid in the File name field.
|Paste the URI into the Address field and click Go.|
|Paste the URI into the File name field and click Open.|
The Connect to ws.webtrends.com dialog box appears.
If an error was suppressed, the error message text appears.
The Import Data dialog box appears with the existing worksheet and current cell selected.