Using ASP to transfer HTML format to Excel (1)

Learn how to build an ASP page to spread HTML data to Execl spreadsheets and display execl spreadsheets in IE
。

So far, there are several ways to use ASP technology to create Excel data tables, and you can also use server-side Excel 8.0 VBA components to build spreadsheets. However, in some cases the server may not be able to handle the amount of information involved or be unable to assume the resulting workload, so you have to sacrifice some of the processing performance provided to the client. This article will focus on the client-side data table processing issues. Excel 97 has some special properties that can handle HTML-formatted data streams just as you do with spreadsheets, and this particular ability is only available in Excel 97 or later, and users need to build similar Excel spreadsheet data streams to handle them more effectively.

So does the browser have a similar function? Internet Explorer (IE) 3.0 or later can display Microsoft Excel worksheets like Excel, provided the client needs to load Excel. If the user opens the IE browser and enters the Excel worksheet file name as Url,ie, the worksheet opens. IE uses the file name extension to identify whether it is a MIME format file and launches the appropriate application, IE converts the file to Application/vnd.ms-excel and starts Excel for the user to view the relevant tabular data when IE processes the Excel MIME format file.

This article discusses how to build an ASP home page that spreads HTML data to an Excel spreadsheet. With this technology, IE browsers can display HTML data tables like Excel. In the following example, the ASP home page launches a component that processes the employee table records stored in Nwind sqlsever 6.5 and displays the table as an HTML table.