Home > Data Query, Data Reporting, Microsoft Excel, Web > Reporting from the Web

Reporting from the Web

July 26, 2011

If you need the ability to include Web data in a report, here is a great method.  Using Excel gives you the ability to get data from the Web.   The data comes from tables that exist on web pages.   You create a web query in Excel 2010 by going to the Data tab on the ribbon bar, then selecting the icon “From Web”.   Using the New Web Query dialog, select a data table on the web page.   Once you click “Import”, the data is loaded onto the worksheet and the data range is given a name.   You can change the name if you want.   Now, with a named range, Sunset Reports can directly read the data and you have a data source for your report.

We have plans to include Web RSS feeds as a data source for a report as well as capturing an image of a webpage and placing it in a report.   These changes are currently in development.

Advertisements