Microsoft Office Tutorials and References
In Depth Information
If you choose to send information as a separate section of the HTTP request, you will be
using the POST field to transfer the information. POSTing data uses the POST field to send
information to the Web server. Because there’s almost no limit to the amount of data that can
be put in a POST field, it’s the preferred way of transferring information to the server.
How do you return information to the client? The data can be presented to the client as a Web
page that can be read using the same techniques described throughout this chapter.
Using Internet Solutions with Excel
Microsoft has enabled the Excel developer to use the Internet as an integral part of an
application solution. For example, workbooks can be opened from and saved to Web servers,
Excel can open HTML pages as though they were workbooks, and Web Queries can be used
to extract tables of data from Web pages. The Internet Explorer object library can also be
automated to retrieve individual items of data from a Web page, without the overhead of
using a workbook.
Besides the ability to utilize and extract data from the World Wide Web, you can also save
Excel workbooks as content-rich Web pages. Interactive Web pages can easily be produced,
providing Excel-like interaction within the Web browser.
All these tools discussed in this chapter enable you to develop new types of business
solutions where Excel is one key part of a larger business process. This process is not limited to a
single organization; rather, your solutions can span multiple organizations and
After reviewing this chapter, you might need to rethink your strategy on developing Excel
application solutions. The Internet is a valuable resource and can be easily used. Not only can
you use the information found on the Internet, but Excel has added Internet functionality to
assist you in sharing data with the world. While developing your solutions, you might need to
think outside the typical box to achieve the desired results.