Welcome to MSDN Blogs Sign in | Join | Help

Excel 2007 Web Data Add-In

Some folks at Microsoft Research have developed an add in that makes it easy to use a Web page as a data source in Excel.  Here is a brief description:

The Excel 2007 Web Data Add-In provides an intuitive user interface for importing textual data from any given webpage via a user’s selections of interest, such as stock quotes, weather temperature, ect, into a spreadsheet and keeping that data “up-to-date”. That is, if the webpage data changes, the spreadsheet can be updated by a click of the data “Refresh” button. Also note that the add-in can automatically learn from a user’s selection and optionally select similar items to help save time. 

Please note that this add-in is a research beta and is unsupported by Microsoft. Feedback and bugs can be sent via the add-in itself (under the it’s help menu) or the add-in’s blog comments.

The add-in is available here.  Please feel free to give the Research team feedback.

Published Tuesday, October 16, 2007 10:54 AM by David Gainer
Filed under: , ,

Comments

# Excel 2007 Web Data Add-In

Tuesday, October 16, 2007 3:23 PM by Excel 2007 Web Data Add-In

# Excel 2007 Web Data Add-In

Wednesday, October 17, 2007 5:58 AM by Tester

Did you see this post at blogs.msdn.com

# : Excel 2007 Web Data Add-In

Sunday, October 21, 2007 2:12 PM by doug churchill

with EXCEL 2007 open, using VISTA ... the add-in will not install ... it says "requires EXCEL 2007 to be installed"

Is this a Vista problem?

Thanks.

# re: Excel 2007 Web Data Add-In

Sunday, October 21, 2007 8:59 PM by Kory

How is this different from Web Query which has been in Excel for years?

# re: Excel 2007 Web Data Add-In

Wednesday, October 24, 2007 11:10 AM by xaw

@doug churchill

Hi Doug --

Thanks for trying to install the add-in. That message is probably unrelated to Vista. It only appears if the detect Excel 2007 launch condition fails in setup, specifically, if the value "Excel.Application.12" does not appear in the regkey "hkey_classes_root\excel.application\curVer." If you don't have that value in your registry, I'd suspect an install issue for Office or you're running a non 2007 release. To follow up on this issue please contact us via email by reaching us on the contact form of our blog (see above post for link). Thanks!

# re: Excel 2007 Web Data Add-In

Thursday, October 25, 2007 7:56 AM by John Greenan

Hi Dave,

Must be about time I ask for the technology roadmap again?  Come on Dave, you know you want to let all us Excel developers know the Microsoft roadmap for developers - should we write XLLs, .xlas, COM addins, .net addins etc etc.  Tell all!!

Cheers,

John

# re: Excel 2007 Web Data Add-In

Monday, October 29, 2007 2:57 PM by Kendell Burton

is the book online somewhere to see online in stead of buying it?

# re: Excel 2007 Web Data Add-In

Monday, October 29, 2007 6:46 PM by David Gainer

Hi John - it is our our list.

# re: Excel 2007 Web Data Add-In

Thursday, November 15, 2007 9:50 AM by JJ

Hi,

this application is indeed helpful. But may I know how do I prevent the updated data to save over the old data?

I would like to keep a list of the old data also.

Thanks

New Comments to this post are disabled
 
Page view tracker