L�m th? n�o �? hi?n th? ASP k?t qu? b?ng c�ch s? d?ng Excel trong IE v?i MIME Types

ID c?a b�i: 199841 - Xem s?n ph?m m� b�i n�y �p d?ng v�o.

Th�ng b�o: b�i vi?t n�y l� b�i ��?c d?ch b?i M�y d?ch

Nh?p chu?t v�o ��y �? hi?n th? b?n g?c Ti?ng anh v� b?n d?ch m�y theo ch? �? so s�nh.

Bung t?t c? | Thu g?n t?t c?

Thay v? c?a hi?n th? d? li?u trang Web c?a b?n trong b?ng HTML, b?n c� th? cung c?p cho ng�?i s? d?ng t�y ch?n hi?n th? c�c d? li?u trong Microsoft Excel. �i?u n�y b�i vi?t ch?ng t? l�m th? n�o �? t?o m?t trang Web v?i b?ng d? li?u thu ��?c t? Microsoft SQL Server, v� ��a ra n� trong Excel b�n trong tr?nh duy?t c?a li�n k?t m� n?i dung trang Web v?i ki?u MIME trong Excel.

Quay l?i �?u trang | Cung c��p Pha�n h��i

TH�NG TIN TH�M

L�m theo c�ng v?i c�c b�?c v� �? ki?m tra k?t qu?, b?n c?n nh?ng �i?u sau ��y:

Microsoft Windows NT Server 4.0, SP3
Microsoft Internet Information Server (IIS), phi�n b?n 4.0 ho?c sau n�y
Microsoft SQL Server 6,5 ho?c m?i h�n
Microsoft Excel 97, Excel 2000 v� Excel 2002

T?ng b�?c th? t?c

T?o m?t DSN h? th?ng ��?c g?i l� "qu�n r�?u" b?ng c�ch s? d?ng ODBC Ti?u d?ng b?ng �i?u khi?n. Thi?t l?p DSN �? tham kh?o c?a b?n m�y ch? SQL �?a ph��ng, s? d?ng SQL Server x�c th?c, v� s? d?ng "qu�n r�?u" nh� l� c� s? d? li?u m?c �?nh. M?c �?nh ��ng nh?p ID �? c� s? d? li?u qu�n r�?u l� sa, v?i kh�ng c� m?t kh?u.

S? d?ng Notepad.exe �? t?o ra m?t t?p tin g?i l� XlTest.asp c?a b?n IIS Trang ch? th� m?c (v� d?, inetpub\wwwroot), v� th�m sau ��y �? n�:

<%@ Language=VBScript %>
<%
   'Change HTML header to specify Excel's MIME content type
   Response.Buffer = TRUE
   Response.ContentType = "application/vnd.ms-excel"
%>
<HTML>
<BODY>
Here is the info you requested.<p>
<%
   ' Create ADO Connection object
   dim myConnection
   set myConnection = CreateObject("ADODB.Connection")
   
   ' Open SQL Server Pubs database...
   ' myConnection.Open "DSN=pubs;UID=sa"
   
   ' Get a recordset of info from Authors table...
   sqlStr = "SELECT au_fname,au_lname,phone FROM authors"
   set rsAuthors =  myConnection.Execute(sqlStr)
%>

<!-- Our table which will be translated into an Excel spreadsheet -->
<TABLE WIDTH=75% BORDER=1 CELLSPACING=1 CELLPADDING=1>
<TR>
   <TD><font size=+2>First Name</font></TD>
   <TD><font size=+2>Last Name</font></TD>
   <TD><font size=+2>Phone</font></TD>
</TR>
<!-- server-side loop adding Table entries -->
<% do while not rsAuthors.EOF %>
<TR>
   <TD><%=rsAuthors("au_fname")%></TD>
   <TD><%=rsAuthors("au_lname")%></TD>
   <TD><%=rsAuthors("phone")%></TD>
</TR>
<% rsAuthors.MoveNext
   loop
   ' Clean up
   rsAuthors.Close
   set rsAuthors = Nothing
   myConnection.Close
   set myConnection = Nothing
%>
</TABLE>
</BODY>
</HTML>

L�u XlTest.asp, v� sau �� xem n� t? m?t tr?nh duy?t c?a kh�ch h�ng. V� d?, http://MyServer/XlTest.asp (thay th? MyServer v?i t�n c?a m�y ch? c?a b?n.)

N?u Microsoft Excel 97 ��?c c�i �?t tr�n m�y kh�ch, Microsoft Excel s? hi?n th? c�c d? li?u b�n trong tr?nh duy?t.

Quay l?i �?u trang | Cung c��p Pha�n h��i

Thu?c t�nh

ID c?a b�i: 199841 - L?n xem x�t sau c�ng: 20 Tha�ng Ta�m 2011 - Xem x�t l?i: 2.0

�p d?ng

Microsoft Visual InterDev 6.0 Standard Edition
Microsoft Internet Information Services 5.0
Microsoft Excel 97 Standard Edition
Microsoft Excel 2000 Standard Edition
Microsoft Excel 2002 Standard Edition

kbhowto kbmt KB199841 KbMtvi

M�y d?ch

QUAN TRO�NG: B�i vi?t n�y ��?c d?ch b?ng ph?n m?m d?ch m�y c?a Microsoft ch? kh�ng ph?i do con ng�?i d?ch. Microsoft cung c?p c�c b�i vi?t do con ng�?i d?ch v� c? c�c b�i vi?t do m�y d?ch �? b?n c� th? truy c?p v�o t?t c? c�c b�i vi?t trong C� s? Ki?n th?c c?a ch�ng t�i b?ng ng�n ng? c?a b?n. Tuy nhi�n, b�i vi?t do m�y d?ch kh�ng ph?i l�c n�o c?ng ho�n h?o. Lo?i b�i vi?t n�y c� th? ch?a c�c sai s�t v? t? v?ng, c� ph�p ho?c ng? ph�p, gi?ng nh� m?t ng�?i n�?c ngo�i c� th? m?c sai s�t khi n�i ng�n ng? c?a b?n. Microsoft kh�ng ch?u tr�ch nhi?m v? b?t k? s? thi?u ch�nh x�c, sai s�t ho?c thi?t h?i n�o do vi?c d?ch sai n?i dung ho?c do ho?t �?ng s? d?ng c?a kh�ch h�ng g�y ra. Microsoft c?ng th�?ng xuy�n c?p nh?t ph?n m?m d?ch m�y n�y.

Nh?p chu?t v�o ��y �? xem b?n ti?ng Anh c?a b�i vi?t n�y:199841

(http://support.microsoft.com/kb/199841/en-us/ )

Quay l?i �?u trang | Cung c��p Pha�n h��i