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 ......
ÎÒÔÚ Page_Load ÀïдÁË
if(!IsPostBack){
GridView1.DataSource=GroupManager.GetGroups();//GetGroups ·µ»ØµÄÊÇ IList<Group>
GridView1.DataBind();
}
¿ÉÎÒÔÚ Submit_Click Àïд´ú ......
RT¡£ºÜ¶àµØÖ·¶¼´ò²»¿ª»ò²»ÄÜÏÂÔØÁË
ÓÐ×ÊÔ´µÄÅóÓѸø¸öµØÖ·¡£¡£Ö»ÒªÏÂÔغóÊÇÎÒÏëÒªµÄÄÚÈÝ 50·ÖÏ×ÉÏ!
лл!
ɳ·¢ÎÒÏÈ×ø!
°ï¶¥
°ï¶¥
ûÌý˵¹ýŶ
JF
ºÃÏñ19ûÓеģ¬²»È«¡£
ºÃ¶à¼¯¶¼²»ÄÜÏ¡£¡£
......
ÎÒÓг§¼Ò×öµÄASPµÄ¼à¿Ø¼Ïñ£¨DVR£©µÄ¾ÖÓòÍø²¥·ÅµÄÔ´³ÌÐòÓë¿Ø¼þ£¬ÏëÒªÓÃASP.net×öÒ»¸öÊÓƵ»Ø·ÅµÄ³ÌÐò£¨ÀûÓÃËûµÄ¿Ø¼þ£©µ«²»ÖªÈçÏÂÈ¥×ö£¬Íû¸÷λָµã¡£
ÏȸãÇå³þËûÃǵĿؼþÊÇÔõôÓõÄ,
È»ºó¾ÍÖ±½ÓÓúÃÁË.
²»¹ý,Èç ......