让Excel与IE携手——在Web上发布你的Excel数据（Let Excel work with IE - publish your Excel data on the Web）.docVIP

让Excel与IE携手——在Web上发布你的Excel数据（Let Excel work with IE - publish your Excel data on the Web） Zhang Yingxin With the development of information construction, more and more units have office network. How do you post the data to the web for user browsing and analysis and query? Many organizations use a lot of programming tools to write appropriate programs to do this. But it is easy to do this with Excel and easily manage the need for a database with simple transaction management. First, build an Excel database The database is one of the three main functions of Excel (table, chart, database), which must be used to create a data list. Data list A data list is an Excel worksheet in a particular format. It lists the cells in the first row of the worksheet as a column marker (equivalent to the database field), and then input the data (equivalent to the data in the field) below the column tag. Tip: a complete database needs to include columns. 2. Establish a list of data points Data sheet is the basis of the Excel database, the establishment of data list have some special requirements: first, each data listing shall take up a job list, do not create multiple data in a table list. Because some of the database management features of Excel, such as filtering, can only take effect on a data list. Second, do not place blank lines or columns in the data list, which prevents Excel from testing and manipulating the database. Finally, dont enter a space before and after the data in the data list, or you might get an error in the Excel operation data. Second, save and publish the database When the data is all entered into the worksheet, you can save it as an interactive Web page and then link to the LAN home page. 1. Save the Web page First, open an Excel workbook with the database, and click the save as Web page command under the file menu to open the save as dialog box. To save the entire workbook as a Web page, select the files storage path in the save location and click save after