Feature:

★ wanayoo — archive 1999 http://idm.internet.com/corner/excel_from_web.html

IDM	Feature
[ Home \| eXchange \| F A Q \| Search \| Register ]	*Understanding Intranets*

Updating Excel From the Web

By Bill Jeffries

Too often, Microsoft Excel spreadsheets are updated through the laborious and tedious process of manually importing data from an external data source--or, worse yet, by cutting and pasting. Excel 97 implements a powerful, yet underpublicized feature called Web queries to simplify this task.
Web queries provide spreadsheets with the ability to update selected cells over an HTTP connection. By running a Web query, the user can circumvent manual data manipulation and make the spreadsheet update itself directly over the Web. By combining this feature with ASP, developers can create extremely powerful intranet and Internet Excel solutions.
Click here for the full tutorial

Of Interest

· Browser Compatibility and the Future of HTML

· Putting JavaScript to Work

Intranet Design Magazine®

Jim Miller Managing Editor

ITAdvisor
  • News & Analysis
  • Security
  • Security Updates
  • Intranet Buzz!
  • Intranet Talk
  • Intranet Corner
  • Intranet Case Studies
  • Recent Tutorials
Intranet Development
  • WirelessEnterprise
  • Getting Started
  • JavaScript
  • VBScript
  • HTML/DHTML
  • XML
  • ASP/IIS
  • Perl
  • PHP
Information Management
  • Content Management
  • Collaboration
  • Portals
  • ASPs
Intranet Resources
  • Intranet FAQ
  • Discussion Board
  • Jobs Board
  • Events Calendar
  • Intranet Books
  • Tools of the Trade
  • Glossary
Archive
Site Map

Modern Dazes on Comics Page

Intranet News

Weekly Intranet\Internet Product Summary: August 09, 2000
Netscape Releases New Beta
Portal Firms Team for Secure Content
Midwest Services Providers Unite
eCedar Fuels Shell's Oil Industry Startup
Computer Associates Reorganizes
Yahoo! Enhances Mail Feature

More News

Take IDM on the Road

Unwired edition
Intranet News, articles and Resources
To easily add IDM mobile edition to your PDA
(Palm or CE)
click here
NEW! IDM Unwired now available in Web Clipping format

Featured Archive Articles

Key Intranet Terms

  • Putting Your Intranet to Work: 50 Ideas for Department-Specific Applications
  • Five-steps to implement your intranet and manage your strategic information
  • A new generation of intranet tools intersects Customer Relationship Management and Sales Force Automation
  • Business Intelligence and the Intranet
  • Effective Intranet Publishing: Getting Critical Knowledge to Any Employee, Anywhere

  • Using an Intranet to Manage 610,000 animal specimens with Java
  • Putting JavaScript to Work for Your Intranet
  • JavaScript Forms and Frames
  • Introduction to the Browser Object Model
  • Black Hole Sun: Java is Going Supernova Thanks to its Creator's Gravitational Pull

  • Managing Large Collections of Documents: A full-length excerpt from the book "Intranet Document Management."
  • Intranet Traffic Management: Without Quality of Service standards, intranets and extranets face death by success
  • Issues in Intranet Security: A primer on keeping the keys to the enterprise safe

  • Report from the trenches: Firms weigh in on intranet deployment trends
  • The Magna Carta of the Intranet: From Smart Companies, Smart Tools
  • Prudential HealthCare Launches Extranet to Manage Health Benefits
  • Wells Fargo Unit Looks To Establish Its Intranet as a 'Portal'
  • Amkor/Anam's intranet is a study in open systems integration

  • Tutorial: Finding Your Way Around E-commerce
  • The Essential Supply Chain
  • A Definition of Data Warehousing
  • Internet Messaging: from the Desktop to the Enterprise

  • Improving Intranet Information Retrieval with Human Indexing
  • An XML Development Kit
  • When To Use Active Server Pages
  • Intranets and extranets for virtual project management
  • Why Groupware is Hard
  • Optimizing Web Pages For Handheld Devices

  • Version Control within a Collaborative Extranet
  • Electronic Procurement, Extranets and You
  • Intranet and extranets for virtual project management
  • Overview of Virtual Private Networks

  • What's the Future of Application Service Vendors?
  • 'Enterprise Portal' - a New Catch Phrase, But Definitions Vary
  • Portals, You Say? This One's Private Ericsson's intranet is a give-and-take affair with employees
  • Application Hosting

Disclaimer

[ Home | eXchange | F A Q | Search | Register ]