Asp.netÖÐExcelµ¼³ö
¶ÔÓÚasp.net µÄExcelµ¼³ö£¬ÓжàÖÖ·½·¨£¬µ½Ä¿Ç°£¬¸öÈËÈÏΪ£¬ÀûÓÃmyxlsµ¼³öExcel»¹ÊDZȽϺÃÓõģ¬¿ÉÒԺܺõÄÉèÖÃExcelµÄ¸ñʽ¡£¡£¡£
ʹÓúܷ½±ã£¬ÏÂÔØorg.in2bits.MyXls.dll£¬ÒýÈëÃüÃû¿Õ¼ä¼´¿É
ÏÂÃæÊÇÒ»¸öʹÓôúÂëʾÀý£º
private void ExcelExport(IList< LineLossInfo > lossListExcel)
{
XlsDocument xls = new XlsDocument();
xls.FileName = "LineLossMonthDetail.xls";//Ö¸¶¨ÎļþÃû
Worksheet sheet = xls.Workbook.Worksheets.Add("LineLossMonthDetail");
#region ÉèÖø÷Êý¾ÝÁеĴóС
ColumnInfo colInfo1 = new ColumnInfo(xls, sheet);
colInfo1.ColumnIndexStart = 0;
colInfo1.ColumnIndexEnd = 1;
colInfo1.Width = 15 * 256;
sheet.AddColumnInfo(colInfo1);
ColumnInfo colInfo2 = new ColumnInfo(xls, sheet);
colInfo2.ColumnIndexStart = 2;
colInfo2.ColumnIndexEnd = 2;
colInfo2.Width = 15 * 256;
sheet.AddColumnInfo(colInfo2);
ColumnInfo colInfo3 = new ColumnInfo(xls, sheet);
colInfo3.ColumnIndexStart = 3;
colInfo3.ColumnIndexEnd = 3;
colInfo3.Width = 15 * 256;
sheet.AddColumnInfo(colInfo3);
ColumnInfo colInfo4 = new ColumnInfo(xls, sheet);
colInfo4.ColumnIndexStart = 4;
colInfo4.ColumnIndexEnd = 4;
colInfo4.Width = 15 * 256;
sheet.AddColumnInfo(colInfo4);
 
Ïà¹ØÎĵµ£º
½ñÌìΪÁË×ö²åÈëÊý¾ÝÕÒÁ˲»ÉÙ¶«Î÷£¬ÒòΪ´ÓÀ´Ã»ÓÐд¹ý¶ÁдExcel£¬Ò²²»ÖªµÀ¸ÃÔõôд¡£ÏÂÃæµÄÊǽñÌìͨ¹ý²é¿´ÂÛ̳×Ô¼ºÐ´³öÀ´ÁË¡£
¹¦ÄÜÊǶÁÈ¡Excel È»ºó°ÑÊý¾Ý²åÈëÊý¾Ý¿â¡£Õâ¸ö¹¦ÄÜÔÚÆóÒµÀïÊǷdz£³£¼ûµÄÒ²Êdz£Óõģ¬Ï£Íû¶ÔÅóÓÑÃÇÓаïÖú£¡
/// <summary>
/// µ¼Èëexcel
/// </ ......
Èý¡¢ÈçºÎ£ºÉèÖà ASP.NET Web ·þÎñÆ÷¿Ø¼þÊôÐÔ
ÔÚ ASP.NET ÍøÒ³ÖУ¬¸ù¾ÝËùÐèµÄÊôÐÔ (Property) ÉèÖÿؼþÉùÃ÷µÄÊôÐÔ (Attribute)¡£
ÄúËùÉèÖõÄÈ·ÇÐÊôÐÔÈ¡¾öÓڿؼþºÍÊôÐÔ¡£ÓйØÌض¨¿Ø¼þµÄÊôÐÔµÄÐÅÏ¢£¬ÇëÔÚ“°ïÖú”Ë÷ÒýÖÐËÑË÷¸Ã¿Ø¼þÀàµÄÃû³Æ£¨ÀýÈ磬“Button Àà (System.Web.UI ......
Ê®¡¢ÒÔ±à³Ì·½Ê½·ÃÎÊ ASP.NET ¿Ø¼þ
1¡¢Web ´°Ìå¿Ø¼þ±êʶ
ASP.NETÍøÒ³ÉϵÄÿһ¸ö¿Ø¼þ¶¼±ØÐëÊÇ¿ÉΨһ±êʶµÄ¡£Í¨³££¬Îª¿Ø¼þµÄ ID ÊôÐÔ·ÖÅäÒ»¸öÖµÀ´Î¨Ò»±êʶ¸Ã¿Ø¼þ¡£¸ÃÖµ½«³ÉΪ¿Ø¼þµÄʵÀýÃû³Æ£¨¼´£¬ÔÚ´úÂëÖÐÒýÓÿؼþËùÒÀ¾ÝµÄÃû³Æ£©¡£ÀýÈ磬Èç¹û½« TextBox ¿Ø¼þµÄ ID ÊôÐÔÉèÖÃΪ Text1£¬Ôò¿ÉÒÔÔ ......
ÔÚASP.NET ÖÐʵÏÖµ¥µãµÇ¼
³ö×Ô£º¡¾ÃÏÏÜ»áÖ®¾«²ÊÊÀ½ç¡¿ ·¢²¼ÈÕÆÚ£º2005Äê1ÔÂ27ÈÕ 8µã48·Ö0Ãë
ÓÉÓÚijЩÔÒò£¬ÔÚÎÒÃǵÄÓ¦ÓÃÖлáÓöµ½Ò»¸öÓû§Ö»ÄÜÔÚÒ»¸öµØ·½µÇ¼µÄÇé¿ö£¬Ò²¾ÍÊÇÎÒÃÇͨ³£Ëù˵µÄµ¥µãµÇ¼¡£ÔÚASP.NETÖÐʵÏÖµ¥µãµÇ¼ÆäʵºÜ¼òµ¥£¬ÏÂÃæ¾Í°ÑÖ÷ÒªµÄ·½·¨ºÍÈ«²¿´úÂë½øÐзÖÎö¡£
ʵÏÖ˼·
ÀûÓÃCacheµÄ¹¦ÄÜ ......