Pre-Grant Publication Number: 20080172630
Please help the USPTO examine the application by evaluating the relevance of the publicly submitted prior art to the patent application.
Peer To Patent forwards the Top 10 most relevant prior art submissions and their annotations to the USPTO.
Review this prior art and click on the thumbs up (or down) to indicate whether this submission should be forwarded to the USPTO.
If you login then you can add an annotation by typing in the box at the bottom of the screen to comment on the relevance of the prior art to the claims of the patent application.
Review this prior art and click on the thumbs up (or down) to indicate whether this submission should be forwarded to the USPTO.
If you login then you can add an annotation by typing in the box at the bottom of the screen to comment on the relevance of the prior art to the claims of the patent application.
Prior Art Detail
Summary / Description
| Summary / Description | Summary: Learn how to use advanced Web query techniques to streamline data feeds into Microsoft Excel 2002. This article describes how to use some of the lesser-known abilities of the QueryTable object in Excel such as how to use it for importing data while sending parameters to the target Web server and how to cause a chart to change its data source after importing a new payload by using Web queries. |
Basic Information
| Type of Prior Art | Online Publication |
| URL | http://msdn.microsoft.com/en-us... |
| Author/Creator | John R. Durant |
| Title | Web Queries and Dynamic Chart Data in Excel 2002 |
| Publication Date | June 2003 |
| Publisher | |
| Directions to Document Location | |
| Additional Information | |
Notes / To Do
| Notes | |
Excerpt
Excerpt Excel Web Queries
Web queries are not new to Excel 2002 or to Microsoft Office Excel 2003. Actually, they have been around since Excel 97, but with Excel 2002, they became more obvious, more powerful, and easier to use. The basic principle behind Web queries is to allow Excel seamlessly use data that is retrieved from a URL. The data can be simple HTML pages, document content, XML, or any text-based data in a URL-addressable location. What this means is that, although a Microsoft ActiveX® server control or other complex binary object on a page cannot provide its internal data directly to Excel, virtually any other URL that offers data to your organization is a candidate for direct import into Excel for reporting needs. Users can employ the Excel user interface to initiate a Web query. However, what makes things intriguing for developers is that you can also do these activities programmatically, thus allowing Web queries to become part of a more complete and reusable solution that you develop. |
Relevance
Claims
1
Relevance
Disclosed is the ability for pulling data from online sources via URLs into
a 'graphical representation of aggregated data' which is in this case a spreadsheet.
Disclosed is the ability for pulling data from online sources via URLs into
a 'graphical representation of aggregated data' which is in this case a spreadsheet.
Claim Chart
All
