Excel Web Queries
Aug 27

Excel Web Queries

Updating Excel From the Web: Really great article on Excel Web Queries. Users always want to get data in Excel for some reason. Web queries are a rock-simple way to let them do this.

Web queries essentially let Excel read data in from an HTML table. Excel can call a URL, parse the table that the URL produces, and load that as rows and columns. Additionally, you can get Excel to prompt the users for querystring parameters without doing any VBA, and using some extensions to HTML, you can format the data, add formulas, filter boxes, etc.

With Web queries, you can get a lot of client-side functionality for your Web app without doing a blessed thing, really. Microsoft really hit this one out of the park.

by Deane   August 27, 2004 2:35 PM   |
  tags: 
Excel

Comments

by Matt,   August 27, 2004 3:23 PM  

Judging from the last part of the URL of the article (991021.htm), the article was written in October 1999 using Office 97. I can only imagine what Office 2003 is capable of. Actually, using Office 2003 with SharePoint 2003 for an intranet allows you to do some pretty cool collaboration.

by Sam,   February 18, 2007 8:01 PM  

any example for this?

Add Comment

Want to advertise on this site? Contact FM.
Laser Toner Cartridges UK laser toner, toner cartridges, hp toner, lexmark toner, samsung toner, canon, toner, epson toner, oki toner, kyocera toner, xerox toner, remanufactured toner, compatible toner
Direct TV Deals Free 4 room direct tv deals. no equipment to buy. free fast professional direct tv installation. this is the best direct tv deal available anywhere.
SEO Article Learn from the experts with our SEO article.
rope light Shopping with birddog distributing, inc., gives you access to the lowest prices, the best customer service and the quickest delivery times possible.
Laptop AC Adapter We offer genuine factory direct replacement AC adapters.
Direct TV Best satellite TV deals.
Direct TV Deals Direct TV programming deals are varied and include packages containing from 50 channels up to over 250 channels.
8mm film to DVD Retain family memories with the only frame by frame digital restoration service in the United States for your 8mm film to DVD today
Rubber Stamp Shop for custom self-inking stamps, hand stamps, address stamps, label stamps, check endorsement stamps, check deposit stamps, date stamps, pre inks, pocket stamps, ink and much more!