C#asp.netÉú³É ExcelµÄÎÊÌâ
ÍøÉÏ¿´Á˺ܶ࣬ºÃÏñÕâÑùµ÷ÓúܺãºExcel.Application();
µ«ÊÇÐèÒªÒýÈëʲôÃüÃû¿Õ¼ä»òÕßdll²ÅÄÜÔËÐÐExcelÕâ¸öÀàÄØ£¿
Excel.dll
Excel.dllÔÚExcel°²×°³ÌÐòÏ£¬
using Microsoft.Office.Interop.Excel;
using Microsoft.Office.Interop.Excel;
Ö»ÓÐMicrosoft..CSharp
ÁíÍâExcel.dllÔÚÒѰ²×°µÄofficeÎļþ¼ÐÏ£¿»¹ÊDZðµÄµØ·½ÄØ£¿
¿ÉÒÔÓÃado.net²Ù×÷Êý¾Ý¿âµÄ·½·¨µÄ
ÎÒÔÚÒýÓÃÄÇÀïÕÒµ½Microsoft.Office.Tools.Excel£¬Õâ¸öÔõôÓÃÄØ£¿
Ìí¼Óusing Microsoft.Office.Interop.Excel;Õâ¸öÒýÓü´¿É
¹¤³Ì--Ìí¼ÓÒýÓÃ--com ÏÂÃæÈ¥ÕÒ Ö»ÒªÄã×°ÁËofficeÓ¦¸Ã¾ÍÓÐÕâ¸öÁË~
com ÏÂÃæÈ¥ÓкܶàµÄmicrosort µÄ×é¼þ£¬ÖÁÓÚÄĸö²ÅÄÜÓÐusing Microsoft.Office.Interop.ExcelÕâ¸öÃüÃû¿Õ¼äÄØ
ÕÒµ½ÁËExcel£¬µ«ÎÒÏë´ò¿ªÎª±£´æµÄ£¬ÈÃÓû§×Ô¼ºÑ¡ÔñÊÇ·ñÒѾ±£´æ£¬ÈçºÎ×öÄØ£¿
給ÄãÒ»個類£¬¿ÉÒÔ實現LZ說µÄ¹¦ÄÜ£º
using System;
using System.Data;
using System.Configuration;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;
using System.Text;
using System.Threading;
using System.Web;
public class ExportToExcel
{
public ExportToExcel()
{
}
#region excelHeader
priva
Ïà¹ØÎÊ´ð£º
aspÏÂÃæ£¬µ±Òª¸ù¾Ý²»Í¬µÄȨÏÞÏÔʾһЩ¹¦Äܰ´Å¥µÄ»°»áд³É
<%
if ȨÏÞ=1 then
%>
<input type="submit" name="Submit" value="Ìá½»" />
<%
end i ......
select top 12 * from Product where [id] not in (select top 12 [id] from Product)
ÕâÑù¿ÉÒÔ·ÖÒ³£¬µ«ÊÇÎÒÔÚºóÃæÏë¼Ó¸öÌõ¼þ
select top 12 * from Product where [id] not in (select top 12 [id] from Prod ......
±¾ÈËʹÓÃswfobject.jsÔÚ±¾»ú¿ÉÒÔÕý³£²¥·Å£¬µ«·¢²¼µ½win2003·þÎñÆ÷¾ÍÎÞ·¨²¥·Å£¬ÍøÉÏÕÒÁËÐí¶à¶¼ËµÐèÒªÅäÖÃMIMEÀàÐÍ£¬ÎÒÅäÖÃÁËҲûÓгɹ¦£¬Çë¸ßÊÖÖ¸µãÒ»ÏÂ
·þÎñÆ÷ÊÇ·ñÖ§³Ö£¬Â·¾¶ÊÇ·ñÕýÈ·
ÓеķþÎñÆ÷¿ÉÄܲ»Ö§³Ö
......
°ÑÒµÎñ²ãµÄ¶¼Ð´ÔÚdllÎļþÖÐÁË£¬ÏÖÔÚÏëÒªÐ޸쬴ó¼Ò¶¼ÓÃʲô¹¤¾ß´ò¿ª£¿
ÓÃvisual studio×Ô´øµÄ ildasm¿ÉÒÔÂð£¿
ÆÚ´ý¸ßÊÖ
LZºÃÀ÷º¦
Ó÷´±àÒëÈí¼þ
ÎÒÓÃReflectorÖ»ÄÜ¿´£¬²»Äܸİ¡£¿
ÓÐÃ ......
ÔÚµ¯³ö¿òÖеã»÷Ò»¸ö°´Å¥£¬Ôõôµ÷תµ½ÁíÒ»¸öä¯ÀÀÆ÷£¬²¢ÇÒÔÚ¸Ãä¯ÀÀÆ÷´ò¿ªÁ½¸öÒ³Ãæ
ÄãµÄÒâ˼Ӧ¸ÃÊÇ
response.write("<script>alert('È·ÈÏ'); window.location.href('xxxx.aspx'); </script>"); ......