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.net repeater ¿Ø¼þÔõô¿ÉÒÔÈ¡µ½×ӿؼþµÄÖµ£¬ÉèÖöϵãÔÚ ItemDataBound ʼþÔõôûÓÐÓõÄ
Request.Form["name"]
Â¥Ö÷ÄãÒªÔÚ°ÑrepeaterÖÐµÄ Ò»¸öÊôÐÔÉèÖÃһϲÅÄܽøÈëitemdataboundʼþ
¿ÉÒÔ ......
ÎÒÒѽ«Windows¿Ø¼þ³É¹¦Ó¦ÓÃÓÚAsp.netÖУ¬µ«Õâ¸ö¿Ø¼þ»¹Òª·ÃÎÊÊý¾Ý¿â¡¢½øÐб¾µØIO²Ù×÷¡¢´òÓ¡µÈ£¬Õâʱ¾Í»á³öÏÖ¡°Ó¦ÓóÌÐòÊÔͼִÐа²È«²ßÂÔ²»ÔÊÐíµÄ²Ù×÷¡±ÕâÑùµÄÌáʾ£¬Ó¦¸ÃÔõÑù¸øËüÊÚȨ£¿
ÔÚ¿Í»§¶ËÒªÅäÖÃ,ÔÊÐí¿Í»§¶ËÈ ......
ÇëÎÊһϣ¬ASP.NETÎÒÓÃÒ»¸ö²ãÖзÅÁËÒ»¸öÈÕÀú¿Ø¼þ£¬ÔÚµãÒ»¸ö°´Å¥Ê±£¬ÏÔʾÕâ¸ö²ã£¿ÏÖÔÚÎÊÌâÊÇÎÒÔڵ㰴ťʱ£¬ÎÒÏë°Ñ²ãÏÔʾÔÚ°´Å¥µÄÏ·½£¿¾ÍÏñÏÂÀÈÕÆÚ¿Ø¼þÒ»Ñù£¬ÎÒÓÃÊǵÄASP.NET C#
ÎÒÓÐÕâôһ¸öÈÕÆÚ¿Ø¼þ£¬£¡µã»÷¿ÉÒÔÑ ......
ÎÒµÄÒ³ÃæÀïÓõÄAJAX¿Ø¼þ µ«Ò³Ãæ¾²Ö¹Ò»¶Îʱ¼ä¾Í»á³öÏÖÉÏÃæµÄÒ»¸ö´íÎóÊÇÔõô»áÊÂѽ Ôõô½â¾ö°¡
¸ßÊÖ°ï°ïæ°¡
½«ÏîÄ¿Éϼ¶Ä¿Â¼ÖеÄÖÐÎÄÃû³ÆÈ«²¿¸Ä³ÉÓ¢ÎÄ
Â¥ÉÏ˵µÄºÜÇå³þÁË¡£°ï¶¥Ò»Ï°É
Õâ¸öÎÊÌâ²»ÊǺܳ£ ......
ÏÖÔÚÏëÒ»¸öʼþÀ´Ö´ÐÐÒ»¸öº¯Êý
Õâ¸öʼþÊÇÔÚÿ¸öÓû§·ÃÎÊÍøÕ¾Ê±¾Í»á´¥·¢,µ«ÊÇÔÚµ±Ç°·ÃÎÊÖ»ÄÜ´¥·¢Ò»´Î
ÎÒ¾ÍÊÇÏë×öÒ»¸öÔÚÏßÈËÊý,µ±·ÃÎÊÕâ¸öվʱ¾Í´¥·¢,ÒÔºó¾Í²»ÔÚ´¥·¢ÁË
³ý·Ç¹Ø±ÕÍøÕ¾ºó,ÔÚ´ò¿ª ......