Office Development History

I have been using office to develop applications for quite some time. I always want to write something about this and summarize my learning and growth processes. Take "Office Development History" as the title of this blog I. Definition What is office development 

Office development refers to function mining and development on an existing office-based platform. It mainly includes two forms: application of a single component and functional expansion design (for example, a small relational database with access for inventory management, for example, develop some macros or custom functions for Excel to achieve some specific functional requirements.) coordinate various office components, office can even be developed in concert with an enterprise information portal website built on Windows SharePoint Services or SharePoint Portal Server Platform to achieve maximum Enterprise Information Sharing and fundamental improvement in office efficiency.
People who have a certain understanding of the evolution of the office and have a certain understanding of the development trend of the office can feel that the application prospects of the Office are also very attractive from a purely technical perspective.

II. Applicability When Will office development be required? 

I remember that when I was learning Excel VBA for development, a fundamental starting point was that I wanted to simplify my work at that time. For example, I had a job like this: Every month I had some data in a fixed format, summarize, analyze, and output some charts and reports according to certain rules. Of course, I may do it manually every time, as long as I don't bother. But I obviously don't want to waste too much energy on this kind of work, so I just want to write one or two macros, and then change it to the desired effect a little bit. Therefore, from the above perspective, although some individuals will learn and study office applications and development purely for the sake of interest and fun, they can understand in most cases, enterprise acceptance of office is not out of interest, but more often due to the need to improve the existing work efficiency. There is no substantial difference between office development and development in other languages. Although in most cases, this type of application requires the client to install the corresponding version of office software, however, this is not a fundamental technical difference. Office Development is also object-oriented programming. At this stage, the main VBA technology is in the same line with VB technology. In a rough summary, office development can help enterprises or individuals complete the following three types of work, even more repetitive work, regular work, and creative work. repetitive work: this is one of the values of office development. Who will write a program for an application? Regular work: This is one of the conditions for office development. Users can certainly require as much flexibility as possible, but always remember that there are always some rules that are fixed, and the process must be basically fixed. Creative Work: this is a more valuable embodiment of office development. Today, we have to sigh for Sharepoint technology. Office itself is very good, and there is no doubt that it will bring us more surprises. Template Development and loading tool development are coming step by step to achieve system integration and collaborative development.

3. Technology Development History (using Excel as an example, other components may be slightly different due to their own characteristics)

First-generation technology: Before the XLM era office97, Excel used an XLM macro language. Although it sounds so strange and far away, we can still see a bit of XLM macro language from some places. When we insert a new worksheet, we will find that We can insert the "MS Excel 4.0 macro table", which is the historical XLM macro. Of course, there are not many people using this relatively original macro table, but Microsoft still keeps this option in the latest office version, microsoft has created a brand new language (VBA: Visual Basic for Application) to realize the most possible compatibility with the second generation technology: office97 and later in the VBA era, and even in the future) and the development environment (independent VBE: Visual Basic Editor ). VBA is a refreshing innovation. With VBA, Microsoft also integrates the "script" concept in office development. We can use Microsoft Script Editor to edit scripts that control office programs and documents. Third-generation technology: What is XML in the XML era? XML is a text file containing HTML tags. It defines a tree structure to describe the data it stores. The biggest advantage of XML is that you can store both structured data and unstructured data in this text file-that is, it can contain and describe "rough" document data, just as it describes "table data of a rule. Microsoft has highlighted XML support since Office XP, especially office2003. Office's next-generation product: office12 is a document based entirely on the XML architecture. If we do not know anything about XML, or do not know much about it, this is a terrible thing. net wind swept across the world, we are very happy to see that the office development tools have also been supplemented. That is based on.. Net vsto (Visual Studio Tools for office. NET 2003 is vsto 2003, and the latest version is vsto 2005 (Beta 2 of course). Please note that when I introduce vsto, I carefully use the word "Supplement, it is not because I like VBA development very much. It is a bit uncomfortable to say that vsto will replace VBA, but at least the current vsto function is still very limited and can only be used for excel, word does some document development, and it is indeed more complex than VBA. However, I believe that vsto will continue to grow and become more suitable for use.

4. Office development practices

Office Development has great potential, because office development is highly reliable and efficient, and office itself is approachable. Technology is constantly evolving. We have reason to believe that we can do better.

5. Other fantasies

I heard that Kingsoft's WPS also provides secondary development tools and environments. However, based on the C language, it is estimated that it is hard for me to spend time learning the C language. However, if you have any experience in this area, you can take a look and introduce it to me.

Comment

I did not think carefully about your point of view.
As for how I feel about office development, I think the potential (or prospects) is as follows:
1. At present, the enterprise's internal resources and office documents account for a large proportion. Currently, the sharing and storage of these resources are based on the verbal or standalone layer. The purpose of office development or solutions is to manage these resources.
2. Office is the most familiar Business Operation client for enterprises. The office-based front-end business system will bring us low-cost system implementation.
3. The office system built on Microsoft Enterprise Solutions will become a collaboration platform for enterprises.

Some opinions.

# View the duiker reply reference on the 2nd floor

My use of office may be the opposite of yours. I mainly use office for system R & D in evaluation. Therefore, the main use of office is not generation, but recognition.

Maybe 1000 people have 1000 ideas for secondary office development ^_^.

 

# View the Spring Fish reply reference on the first floor