[Excel] Web Services

Reporting Design Cookbook Data Design
1

This recipe shows how to read data from an online Excel file into an Excel DataSource.

Steps taken:

  1. Create an Excel DataSource (ExcelDS_ReadFromHTTP.ds).
  2. In the “URL” field, fill in the link that goes to an online Excel file, e.g.
    http://databases.about.com/library/samples/address.xls
  3. In the “Range” field, fill in the following content:=

Data will be loaded from the online Excel file into the datasource successfully.

To download the necessary files for this recipe, refer to the attached ZIP file.
WebServices.zip