Translator's description: "Programming Microsoft Office 2000 Web Components" is an English e-book that I downloaded from the Internet. It is based on the following ideas: 1. When reading English, often I will not understand, Ignore a lot of details and those who are not easy to read. If you force yourself to translate in your own sentence, you will have more comprehensive, detailed and profound understanding of the original English materials. 2, you can exercise your ability in English. 3. Can provide some help to friends who need information in this area. This is the work of this for the first time. I am very technical and English capabilities, so I hope that friends can make valuable comments and suggestions for mistakes and defects in my article, thank you!
Welcome everyone to visit my blog: http://daidaoke.donews.net/daidaoke/
Chapter 1 Offic Web Components Introduction
Microsoft Office 2000 contains a set of new controls named Office Web Components (OFFEC). Using these components, you can develop many useful data analysis and reporting solutions in a web browser environment and traditional programming environments. In this chapter, I will explain why Office Web Components will be developed, what they are, and where you can use them. I will also provide you with some preliminary comments on using these components in business solutions. The second part of this book will provide some common, practice-based methods of practice, and take you step by step Various techniques used in these solutions. If you don't know these controls at all, please read it because this chapter will provide the basics of the other parts of this book. If you are already familiar with these controls, just want to know how to use them in your business solution, please jump directly to Chapter 6. The first section Why is Office Web Components to be created?
The technology developed by World Wide Web attracts large and small commercial institutions like a storm, and companies now realize that Internet and Web are the key to discovering customers, suppliers, and vendors. Key mechanism. The companies also realize that if the same technique is applied to the company's LAN or WAN (that is, we know intranets), it is possible to share information and development and deployment tools for their business operations and develop and deploy tools to provide telescopic, flexible, easy Mechanism for use.
Not long ago, the work of establishing and managing the content of the Internet is only the magic of the Web site administrator. With the emergence of site management and content creation tools, such as Microsoft FrontPage, ordinary people can also create documents that can be published on the Web, and manage these documents like managing documents on their local computers. Such tools make non-professional technicians to establish a Web site and have something likely to share information between their colleagues.
Pure text documents are well compatible with HTML and web browser technology, but not all documents can effectively play its role when only static text is browsed. The author of creation of spreadsheets, databases, and data reports encounters special issues and opportunities when sharing these things on the Internet. The main value of shared spreadsheets or data reports is to make other users interact and adjust this model based on their own needs. For example, if you have created a spreadsheet that can analyze product profitability based on various inputs, sharing this spreadsheet is to make other users can change or enter new hypothetical values and view recalculated. result.
Similarly, if you create a data perspective of Microsoft Excel (often referred to as a crosstab), then allow others to sort, filter, group, reorganize, or drill more details is one of these documents. Basic purpose. In other words, a spreadsheet or data document is only half the story on the Web. The other half of the story makes other users to interact with these documents, and can store information useful to them, not just publishers. IT company aware of the benefits of Web and Internet technology. Many systems become easy to develop, distribute, use and maintain when using Web technology on the company's internal internet. There are two such types of systems: Decision Support System (DSS), also known as the Supervisor Information System (EIS), and recently more known as online analysis processing system (OLAP); and trading system, this title is rarely Use or is only used by the public. Chapter 7 Sales Analysis and Reporting Solutions provide an example of an OLAP based on a web browser. The Timesheet's solution described in Chapter 8 shows an example of a public common trading tool.
The decision support system is very good to use Web technology and web user experience. Want to know your product sales last month? Open your browser and click on a special link. Need to know the list of customers in your area? This is just another click on your company's internal Internet homepage. Teachers such as CGI and ASP enable IT organizations to provide vivid reports as needed, which can be viewed, printed, or exported into a variety of analytics tools.
However, people who view the report often want to view the report from a slightly different perspective, sort according to a different value, packet data according to a different order, drill and get more detailed information about a number, or View the data through the chart. When any of the above specific situations, IT organizations returned to a similar problem they have to handle, that is: How do they build a need to meet everyone's needs, flexible, and Is it easy to use reporting system?
Second system - trading system - also benefiting from Web technology. Need to change your 401 (k) plan? (A plan related to the US Pension Fund System) As long as you follow the link roaming on the HR home page, enter the new value, and click the Submit button. Do you need someone to help repair your computer? Roam in the hotline support site, fill in the table to describe your problem, and click the Submit button. No need to run any installer, do not need to perform complex applications, and only require small client disk space, even unnecessary.
Sometimes these applications require a fat client interface to provide a data input interface similar to the grid, recalculate the function, update the chart to display the effects generated by the current data, and so on. In order to maintain the advantages of the distribution, an IT organization will need to use such flexible components in the page, however, they often lack resources to develop such components themselves.
Term interpretation
Strictly speaking, the term "decision support system", "competent information system", and "online analysis processing system" are not exactly the same - each term has its own side focus, making it a little unique. Since the information system is no longer used by the executive personnel, the term "competent information system" is now rarely used; System of business information. The term "decision support system" has great general symmetry, which is suitable for systems that focus on decision development and paying attention to special data analysis. "OLAP" is a current hot word, which is often used to describe a class of technologies instead of surrounding their solutions. Hey, friends in our commercial publishing are often mixed with these terms. So, how do I publish an interactive experience experience on the internal Internet? How to make spreadsheets or data reports vivid in a web browser? How to develop and distribute solutions that provide rich data analysis and data visualization capabilities? How to build a transaction solution using a fat client interface? The answer is OFFICE Web Components.
Appendix: English Original: Chapter 1
Introducing the Office Web Components Microsoft Office 2000 includes a new set of controls called the Office Web Components (OWC). Using these components, you can build many useful data analysis and reporting solutions, both in the web browser and in traditional programming environments. In this chapter, I will explain why the Office Web Components were created, what they are, and where you can use them. I will also give you a few initial ideas for their use in business solutions. Part II of the book will provide some common .
If you do not know anything about these controls, read on, as this chapter will serve as the foundation for the rest of the book. If you are already familiar with the components and just want to see how 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 large and small businesses by storm. Companies now see 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 that the 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 businesses.Not so long ago, setting up and managing content on an intranet was a black art relegated to "webmasters." With the advent of site management and content creation tools such as Microsoft FrontPage, ordinary mortals could create web-ready documents and manage them much like they Managed Files on their local computers. Tools Suitechnical Individuals to set up Web Sites and Share Information with the the Ir coworkers.
Documents full of text lend themselves well to HTML and web browser technologies, but not all documents are useful when viewed as static text only. Authors who create spreadsheets, databases, and database reports encounter special problems and opportunities when sharing these on their corporate intranets. Much of the value of sharing a spreadsheet or database report 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, an important aspect of sharing that spreadsheet is enabling other users to change or enter new assumptions and view the recalculated results. Likewise, if you create a Microsoft Excel PivotTable report (more commonly known as a crosstab report), allowing other people to sort, filter, group, reorganize OR Drill Down To more detail is an essential part of sharing these documents, publishing a spreadsheet or database docum Ent ON A Web Is Only Half The Story. The Other Half Is Enabling Others To Interact with The Published Document and Garner Information That's Meaningful 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 corporation's intranet Two such classes of systems exist..: decision support systems (DSS), also known as executive information systems (EIS) or the more recent name online analytical processing (OLAP), and transactional systems, which are used infrequently or by large audiences. The Sales Analysis and Reporting solution in Chapter 7 gives an example of OLAP in a web browser, and the Timesheet solution described in Chapter 8 shows an example of a transactional tool commonly used by a large audience.Decision support systems lend themselves incredibly well to the technologies and user metaphors of the web. Want TO KNOW How Many Units of Your Product WERE SOLST MONTH? Open Your Web Browser, And Click A Particular HyperLink. Need to See a List of Customers in your district? Again, it's just a click away from 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 groups to deliver live reports on demand in a format That Can Be Viewed, Printed, or Imported Into a Variety of Analysis Tools.
However, often the person viewing the report wants to see it in a slightly different way, sort it by a different value, group the data in a different order, drill down and see more detail about a number, or see the data organized into a . chart When any of these scenarios occurs, IT groups return to the same problem they have always had to deal with: how do they build 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 space needed.
Sometimes these applications demand a richer client interface, one that will provide gridlike data entry, recalculation, updates to charts showing the impact of the current value, and so on. To keep the deployment benefits, an IT group would need to use an active component In the page; however, The.
The Subtler Side of Buzzwords To be 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 are not used only by executives anymore;. however, once upon a time the phrase described information systems that delivered critical, high-level business information to executives who were monitoring the health of the company The term " decision support systems "is more encompassing and applies to systems that aid in decision making, often focusing on delivering 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 around them. Alas, our friends in the trade press often use all these terms interchangeably.So how do you deliver an interactive experience on the corporate intranet? How do you make a spreadsheet or database report come to life in the web browser? How can you develop and deploy solutions that provide rich data analysis and data visualization capabilities? How can you build transactional solutions with richer client interfaces? The answer is the Office Web Components.
