Archive

Posts Tagged ‘Web Data’

Use the Web as a Data Source

June 19, 2012 Leave a comment

As you have probably already seen, Sunset Reports can use an Excel Workbook as a data source.  Excel has the ability to pull data from a Web Page using what is called a Web Query.   When you are in Excel choose the Data tab on the ribbon bar, and then choose the item “From Web”.   You can pull data from a section of a web page and have it inserted into a worksheet.   If the inserted data is formatted with headers, give it a range name, and now you have a web based data source.   Be sure to setup the options to have the data extracted when Excel is opened so the data is refreshed automatically.

Advertisements