Programming Microsoft Office Web components Chapter I.

Web Translator Description: "Programming Microsoft Office Web Components" is a book I downloaded from the Internet on the OWC technology of an English ebook, the reason to translate the books, is based on the following ideas:
1, reading English materials often will be superficial understanding, ignoring a lot of details and not easy to read sentences, if forced to step into the translation, it will be the original English materials have more comprehensive, detailed and profound understanding.
2, can exercise their ability in English.
3, can give other need this information friend to provide certain help.
This is my first time in this area of work, my skills and English ability are very general, so I hope that friends will be able to my article in the errors and defects put forward valuable comments and suggestions, thank you!

You are welcome to visit my blog:http://daidaoke.donews.net/daidaoke/



Chapter One introduction to Office Web components



Microsoft Office 2000 contains a set of new controls named Office Web components (OWC). With these components, you can develop a number of useful data analysis and reporting solutions in a Web browser environment and in a traditional programming environment.

In this chapter, I'll explain why Office Web components are developed, what they are, and where you can use them. I will also give you some preliminary advice on using these components in a business solution, the second chapter of this book provides some common, hands-on usage of these components, and takes you step-by-step through the various techniques used in these solutions.

If you don't understand these controls at all, read on because this chapter provides the basics that are required in the rest of the book. If you're already familiar with these controls and just want to know how to use them in a business solution, skip to chapter sixth.

Why is Office Web components created in the first section?

Technologies developed for the World Wide Web have attracted large and small businesses like a storm, and companies are now aware that the Internet and the Web are key mechanisms for discovering customers and delivering information between customers, suppliers, and vendors. Companies are also aware that if they apply the same technology to the company's local area network or wide area network (the intranets we know), they can provide scalable, flexible, and easy-to-use mechanisms for sharing information and developing and deploying tools in their business operations.

Not long ago, the task of building and managing the content of the intranet within the enterprise was magic only for Web site administrators. As site management and content creation tools emerge, such as Microsoft FrontPage, ordinary people can create documents that can be published on the web, and manage them almost as much as documents on their local computer. Such tools make it possible for unprofessional technicians to build Web sites and share information among their colleagues.

Plain-text documents can be well compatible with HTML and Web browser technology, but not all documents can function effectively when using only static text browsing. Authors who create spreadsheets, databases, and data reports face special problems and opportunities when sharing these things on the intranet. The main value of sharing spreadsheets or data reports is to allow other users to interact with it and tailor the model to their own needs. For example, if you create a spreadsheet that analyzes product profitability based on the prices of various inputs, one important aspect of sharing the spreadsheet is to enable other users to change or enter new assumptions and view the results of the recalculation.

Similarly, if you create a PivotTable report for Microsoft Excel (often referred to as a crosstab), allowing others to sort, filter, group, rearrange, or drill down for more details is a fundamental purpose of sharing these documents. In other words, publishing a spreadsheet or data document on the Web is only half the story. The other half of the story is to enable other users to interact with the published documents and store the information that is useful to them, not just the publishers.

It corporate organizations are also aware of the benefits of web and Internet technology. When using Web technology to create information systems on the company's internal internet, many systems become very easy to develop, distribute, use, and maintain. There are two such types of systems: Decision Support Systems (DSS), also known as the Executive Information System (EIS), more recently known as Online analytical Processing systems (OLAP), and trading systems, which are rarely used or used only by the public. The seventh chapter of the Sales Analysis and reporting solution provides an example of OLAP based on Web browsers, and the timesheet solution described in chapter eighth shows an example of popular trading tools.

Decision support systems can make good use of Web technology and Web user experience. Want to know your product sales last month? Open your browser and click on a special link. Do you need to know the customer list for your area? This is just another click from your company's internal Internet homepage. Technologies such as CGI and ASP enable IT organizations to provide vivid reports that can be viewed, printed, or exported to various analysis tools as needed.

However, people looking at reports often want to view the report from a slightly different point of view, sort by a different value, group the data in a different order, drill through and get more detailed information about a number, or view the data in a graphical way. When any of these particular situations occur, the IT organization returns to the same problem that they have always had to deal with: how can they build a flexible, feature-rich, easy-to-use reporting system that meets everyone's needs?

The second type of system-trading system-also benefits from Web technology. Need to change your 401 (K) plan? (a program related to the US pension fund system) just follow the links on the Human Resources homepage and enter a new value, and click the Submit button. Do you need help to repair your computer? Roam through the Hotline support site, fill out the form to describe your problem, and click the Submit button. You do not need to run any installers, you do not need to perform complex applications, and you need very little client disk space, or even unwanted.

Sometimes these applications require a rich client interface to provide a grid-like data entry interface, recalculate functionality, update the chart to show the effect of the current data, and so on. In order to maintain the benefits of distribution, an IT organization will need to use one of these flexible components on the page, however, they often lack the resources to develop such components themselves.

Terminology interpretation

Strictly speaking, the term "decision support system", "competent information system", and "online analysis processing system" is not exactly the same-each term has its own focus, making it a little bit unique. Since information systems are no longer used solely by executives, the term "executive information system" is now rarely used; however, the term used to describe an information system that provides timely, high-level business information to executives who monitor the company's normal operations. The term "decision support system" is broadly generic and applies to systems that focus on decision making and the release of special data analysis. "OLAP" is the current buzzword, and it is often used to describe a class of techniques rather than the solutions that surround them. Alas, our friends in the field of commercial publishing often mix these terms.

So how do you publish an interactive experience on the intranet? How do you make spreadsheets or data reports lively in a Web browser? How can you develop and distribute solutions that provide a wealth of data analysis and data visualization capabilities? How do I use the FAT client interface to build a trading solution? The answer is the Office Web components.





Appendix:

English Original:

Chapter 1



Introducing the Office WEB components

Microsoft Office includes a new set of controls called the Office Web components (OWC). Using These components, your can build many useful data analysis and reporting solutions, both in the Web browser and in TR Aditional programming environments. In this chapter, I'll explain why the Office Web components were created, what they, and where can use are. I'll also give you a few initial ideas for their with use in business solutions. Part II of the book would provide some common, practical uses of the components and would take you on a step-by-step tour of The techniques used in those solutions.



If you don ' t know anything about these controls, read on, as this chapter'll serve as the foundation for the rest of the Book. If you are are already familiar with the components and just want to-to-to-use them in business solutions, skip ahead to Chapter 6.



Why were the Office Web components Created?

The technologies developed for the "World Wide" Web are taking both and large small by businesses. Companies now to the Internet and the WEB as key mechanisms for reaching their customers and for distributing information Among customers, suppliers, and vendors. Companies are also realizing this same technologies used internally on their LANs or WANs (known as intranets) provide Scalable, flexible, easy-to-use mechanisms for sharing information and for developing and deploying tools to run their BU Sinesses.



Not too long ago, setting up and managing the content on an intranet is a black art relegated to "webmasters." With the advent of site management and content creation tools such as Microsoft FrontPage, ordinary mortals could create W Eb-ready documents and manage them much like they managed the files on their the local computers. Tools such as made it possible for semitechnical individuals to set up Web sites and share information with their CO Workers.



Documents full of text lend themselves the browser technologies, but not all documents are useful when VI ewed as static text only. Authors who-Create spreadsheets, databases, and database reports encounter special problems and opportunities when sharing These are on their corporate intranets. Much of the value of sharing a spreadsheet or database, lies in letting, other users, interact with it and tailor the Model to their own needs. For example, if you create a spreadsheet to analyze a product ' s profitability given various input costs, a important ASPE CT sharing that spreadsheet are enabling other users to change or enter new assumptions and view the recalculated result S. Likewise, if you create a Microsoft Excel PivotTable the more commonly known as a crosstab, allowing People to sort, filter, group, reorganize, or drill down to the more detail are an essential this part of sharing. In the other words, publishing a spreadsheet or database DocumENT on a web be only half the story. The other half are enabling others to interact with the published document and garner information of that ' s meaningful to them , not just to the publisher.



Corporate Information Technology (IT) groups are also realizing the benefits of Web and Internet technologies. Many information systems are much easier to develop, deploy, use, and support when created with Web technologies on the CO Rporation ' s intranet. Two such classes of systems exist:decision support Systems (DSS), also known as Executive Information Systems (EIS) or th E more recent name online analytical processing (OLAP), and transactional systems, which are used infrequently or by large Audiences. The Sales analysis and Reporting solution into Chapter 7 gives an example of OLAP in a Web browser, and the timesheet Soluti On described in Chapter 8 shows a example of a transactional tool commonly by a used large.



Decision support systems lend themselves incredibly and user technologies the Web. Want to know how many units the your product were sold last month? Open your Web browser, and click a particular hyperlink. Need to the a list of customers in your district? Again, it's just a click away from the your team ' s intranet home page. Technologies such as Common Gateway Interface (CGI) and Microsoft Active Server Pages (ASP) have made it possible for it G Roups to deliver live reports on demand in a format so can is viewed, printed, or imported into a variety of Ols.



However, often the person viewing the "wants to" it in a slightly different, sort it by a way value, GR OUP the "data in a" different order, drill down and = more detail about a number, or to the data organized into a chart. When all of these scenarios occurs, it groups return to the same problem they, have always to had deal do with:how BU ILD a flexible, robust, and easy-to-use reporting system that satisfies everyone ' s needs?



The second class of systems-transactional systems-also benefits from the technologies of the Web. Need to change your 401 (k) contribution? Just follow a hyperlink on the Human Resources Home page, enter the new value, and click the Submit button. Need help fixing your computer? Navigate to the helpdesk site, fill out the form describing your problem, and click Submit. There ' s no install program to run, no complex application to execute, and little to no client-side disk spaces needed.



Sometimes these applications demand a richer client interface, one this would provide gridlike data entry, recalculation, u Pdates to charts showing the impact of the value, and. To keep the deployment benefits, a IT group would need to use a active component in the page; However, they often lack the resources to develop such components.



The subtler Side of buzzwords

To is precise, the terms "decision support systems," "Executive information Systems," and "OLAP" are not quite synonymous- Each has a slant that makes it a little unique. The term "Executive information systems" is hardly used today since information systems the aren ' t used More However, once upon a time the phrase described information systems that delivered critical, high-level business informatio N to executives who were monitoring the health of the. The term "decision support systems" is more encompassing and applies to systems of that aid in decision making, often focusin G on delivering the ad hoc data analysis. "OLAP" is a hot buzzword today, and it's more often used to describe a class of technologies than the solutions built nd them. Alas, our friends in the trade press often with all these terms interchangeably.



So how does you deliver a interactive experience on the corporate intranet? How do you make a spreadsheet or database come to the Web browser? How can you develop and deploy solutions, provide rich data analysis and data visualization capabilities? How can I build transactional solutions with richer client interfaces? The answer is the Office Web components.