To move an Excel form to the Web

Fruit in an advertising company as a network administrator, Human Resources Department of Raspberry There's one thing I'd like to ask for a favor. The company is adjusting endowment insurance savings for its employees, the data in the approval list involves several departments, and the Vice-President in charge of finance is traveling abroad, how to let each department to fill out the report quickly through the LAN, Then let the vice president through the network to carry out the review?

Fruit is not particularly familiar with the Office software, after listening to the specific description of the raspberry, it is difficult to refuse, the first promise down. A free time to go online to the teacher for advice, the teacher told Fruit, Excel 2003 added a called "list" function, with the support of the SharePoint site powerful, users use IE browser can edit the data in the "list" to achieve the real meaning of the online Excel. Hearing this fruit exultation, immediately set up online "desk".

Set up an online "desk"　　

The so-called "desk" on the Web is the "Web site" in the SharePoint site. The company LAN server is installed with Windows 2003, which is the ideal environment for running Windows SharePoint Services 2.0.

First step: Remove FrontPage Server Extensions

When you install Windows SharePoint Services 2.0, there is a special requirement that the virtual server must not have FrontPage Server Extensions. Fruit Check your Windows 2003 and discover that IIS has the FrontPage Server Extensions installed. According to the information provided by Microsoft, you can delete this task by clicking "Start → run" and enter the "cmd" command. At the command Prompt window, perform the "CD" command, return to the C-packing directory, and then perform the "CD C:Program FilesCommon filesmicrosoft sharedweb server extensions50bin" DOS command. Enter the FrontPage Server Extensions installation directory. Then enter the Owsadm.exe-o fulluninstall-p dos command, where 80 represents the port number used by the virtual server that is running the FrontPage Server Extensions, enter complete the delete task.

Fruit tip: If Windows 2003 IIS does not have FrontPage Server Extensions installed, you can install Windows SharePoint Services 2.0 as long as you have ASP.net installed.

Step two: Run Windows SharePoint Services 2.0

Run the Windows SharePoint Services 2.0 installer and choose Typical installation. When the installer displays "Please wait while Setup is configuring the SharePoint site", the installation process is about to end and the fruit is ready for you to have a "desk".

Step three: Create an online "desk" for Excel 2003 "list"

Users who have site Creation permissions log on to the SharePoint site, click the Create button on the home page, and in Create Web page, select sites and workspaces to open the new SharePoint Site page. In the Title box, enter the name of the site you are about to create, such as Excel list, and then enter the URL name for the Web site in the URL name box. Since this site is a virtual site that is built on a SharePoint site, the contents of the "URL name" (such as "http://192.168.0.1") cannot be modified, and you can enter a name (such as "Excel") in the box after the SharePoint site URL. , which together with the URL of a SharePoint site constitutes a "desk" url (such as "Http://192.168.0.1/Excel").

Create a list

When the online "desk" is built, the fruit comes to the BlackBerry's office. Open the Excel 2003 worksheet that contains the old-age insurance savings data, and then select the data area that you want to publish as a list. The menu "data → list → create List" command pops up (as shown in Figure 1) In the Create List dialog box, which displays the list area of the absolute reference. If you want to use the list header to perform a filter, select the title of list check box. If you cancel this check box, the list you create automatically adds column headings such as column 1, column 2.

Figure 1 Creating a list

When you click the OK button in the dialog box, the selected area becomes the case as shown in Figure 2. The end line of the area displays a blank row with an asterisk, as long as the data is entered in the row, and the blank line with the asterisk and the data underneath it is automatically moved down to allow the user to insert any number of rows of data.

　

Click to view larger image　

Figure 2 Inserting data

Publish List

Now everything is ready, fruit can be published in the Excel 2003 list to the online "desk", the company's various departments of users can be edited through IE browser.

Step One: Execute menu "data → list → publish list" command, pop-up "publish List to SharePoint site" dialog box. First, enter the site URL (such as "Http://192.168.0.1/Excel") that holds the list in the Address field. To link a list to a list that is about to be created on a SharePoint site, select the link to new SharePoint list check box if users who publish the list, such as raspberries, refresh the data in Excel 2003.

Step two: In the Name field, enter the name of the list you will create (for example, "New retirement savings"), and in the Description field, enter a description of the list, and then click Next to continue.