让excel与ie携手——在web上发布你的excel数据（Let excel join hands with IE - publish your Excel data on Web）.docVIP

让excel与ie携手——在web上发布你的excel数据（Let excel join hands with IE - publish your Excel data on Web） Ying Xin Zhang With the development of informatization construction, more and more units have office network. And how data will be posted online, browse and analysis and query for users? Many units use a lot of programming tools to write the appropriate procedures to complete this work. But the Excel can easily complete the work, and very easy to meet the needs of the simple transaction management database. Firstly, establish the Excel database The database is Excel three functions (tables, charts, database), use this function to establish the data list. 1. data list The list is a specific form of Excel sheet. It will work as the first cell table column markers (equivalent to the database field), and then in the cell input data column is marked below (equivalent to the data in the field). Note: a complete database, including the ranks of items. 2. to establish the data list note The list is based on Excel database, a data list has some special requirements: first, each list should occupy a sheet, do not create multiple data list in a list. Because some of the Excel database management functions (such as screening), only on a data list entry. Secondly, dont put blank rows or columns in the data list, it will hinder the Excel database operation and detection. Finally, after the data list data do not enter spaces, otherwise it may lead to error Excel operation data. Two, save and publish database When all the data were input into the work table, you can save it as an interactive Web page, and then link to the homepage of the lan. 1. save Web pages First open the database containing the Excel workbook, click the file menu, click Save as on the Web page command, you can open the Save As dialog box. If the whole Workbook Web page, select the storage path file in the save, enter the file name and click the save button. Tip: if you want to save the current sheet for interactive Web