¹ØÓÚasp.netµ¼³öExcelʱ¹ØÁªÑ¸À×ÏÂÔØ
ÔÚÀûÓÿªÔ´MyXlsµ¼³öExcelʱ£¬¶ÔÓÚ°²×°×ÅѸÀ׵Ŀͻ§¶Ë£¬µ¼³öʱ»á¹ØÁªÑ¸À×£¬Èç¹ûÓÃѸÀ×ÏÂÔØ£¬ÏÂÔØµÄÊÇÕâ¸öÒ³Ãæ¼´aspxÎļþ£¬¶ø·ÇÏëÒªµÄµÄ±¨±í
ΪÁ˽â¾öÕâ¸öÎÊÌâ·Ñ¾¡ÐÄ˼£¬bd£¬Google£¬Ã»ÕÒµ½´ð°¸£¬ºóÀ´×Ô¼º¿´¿´Ô´Â룬ϸϸÑо¿ÁËһϽâ¾öÁË
ѸÀ×ÏÂÔØÊ±ÖØ¶¨Î»ÁË×ÊÔ´£¬ËùÒÔÏÂÔØµÃµ½µÄÊÇÍøÒ³µÄ¡£ÕâÑùÎÒÃÇ¿ÉÒÔÿ´Îµã»÷µ¼³öʱתµ½ÁíÒ»¸öеÄÒ³Ãæ£¬ÔÚÐÂÒ³ÃæµÄpage_loadÖд¦Àí
µ¼³ö£¬µ¼³öʱÓÃѸÀ׾ͻáµÃµ½ÐèÒªµÄ±¨±í¶ø²»ÊÇaspxÎļþ¡£µ«ÊÇ»¹ÓÐÎÊÌ⣬¾ÍÊÇÓÃѸÀ×ÏÂÔØµÄ±¨±í¿ÉÄÜ´ò²»¿ª»ò³öÎÊÌ⣬ÕâÑùÓÖ·ÑÁËЩÁ¦Æø£¬ÔÚ
´úÂëÖмÓÈëÁËÁ½ÐдúÂ룬²ÅµÃÒÔ½â¾ö¡£¼´£ºÏȰÑÒªµ¼³öµÄ±¨±íÔÚ·þÎñÆ÷±£´æÒ»·Ý£¬ÔÙsend()
ÏÂÃæÊÇÒ»´úÂëʾÀý£º
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);
ColumnInfo colInfo5 = new ColumnInfo(xls, sheet);
colInfo5.C
Ïà¹ØÎĵµ£º
AtlasÊÇʲô£¿
atlas 2006-12-12 09:48 ÔĶÁ69 ÆÀÂÛ0
×ֺţº ´ó´ó ÖÐÖРСС
AtlasÊÇʲô£¿
ASP.NET”Atlas”ÊÇÒ»¸öеÄWeb¼¼Êõ¿ª·¢°ü£¬Ëü¼¯³ÉÁËÒ»Ì׷dz£´óµÄ¿Í»§¶Ë½Å±¾¿âʹµÃÓ빦ÄܷḻµÄ¡¢»ùÓÚ·þÎñÆ÷¿ª·¢Æ½Ì¨µÄASP.NET2.0½áºÏÔÚÒ»Æð£¬&rdq ......
Ò»¡¢ÈçºÎ£ºÊ¹Óà ASP.NET Óï·¨½«·þÎñÆ÷¿Ø¼þÌí¼Óµ½ ASP.NET ÍøÒ³
¿ÉÒÔͨ¹ýÔÚ .aspx ÎļþÖÐÖ±½ÓÉùÃ÷ Web ·þÎñÆ÷¿Ø¼þ½«ËüÌí¼Óµ½Ò³ÖС£
ÒÔÉùÃ÷·½Ê½Ìí¼Ó¿Ø¼þ
A¡¢Èç¹ûÄúλÓÚ¿ÉÊÓ»¯Éè¼ÆÆ÷ÖУ¬ÇëÇл»µ½Ô´±à¼ÊÓͼ¡£
B¡¢½«±íʾ¸Ã¿Ø¼þµÄÔªËØ¼üÈë .aspx Îļþ¡£ÄúʹÓõľßÌåÓ﷨ȡ¾öÓÚÒªÌí¼ÓµÄ¿Ø¼þ£¬ ......
Îå¡¢ASP.NET Web ·þÎñÆ÷¿Ø¼þºÍä¯ÀÀÆ÷¹¦ÄÜ
²»Í¬µÄä¯ÀÀÆ÷ºÍÏàͬä¯ÀÀÆ÷µÄ²»Í¬°æ±¾Ö§³Ö²»Í¬µÄ¹¦ÄÜ¡£ASP.NET ·þÎñÆ÷¿Ø¼þ»á×Ô¶¯È·¶¨·¢³öÒ³ÃæÇëÇóµÄä¯ÀÀÆ÷£¬²¢Îª¸Ãä¯ÀÀÆ÷³ÊÏÖÊʵ±µÄ±ê¼Ç¡£µ«ÊÇ£¬²¿·Ö¿Ø¼þ¹¦ÄÜÎÞ·¨ÔڽϵͰ汾µÄä¯ÀÀÆ÷ÉϳÊÏÖ£¬Òò´ËÐèÒªÔÚ¾¡¿ÉÄܶàµÄä¯ÀÀÆ÷ÀàÐÍÉϲ鿴ҳµÄÊä³ö£¬ÒÔÈ·±£Ò ......
Áù¡¢ASP.NET Web ·þÎñÆ÷¿Ø¼þÖÐµÄ Tab ¼ü˳Ðò¡¢½¹µãºÍ·ÃÎʼü
ÈôÒªÔöÇ¿ÔÚ ASP.NET ÍøÒ³ÖÐʹÓÿؼþµÄÓû§ÌåÑ飬¿ÉÒÔÖ¸¶¨Óû§Í¨¹ý°´ Tab ¼üÏÔʾ ASP.NET Web ·þÎñÆ÷¿Ø¼þµÄ˳Ðò£¬²¢¿ÉÒÔÖ¸¶¨×î³õ´ò¿ªÒ³Ê±Ò³ÉϵÄÄĸö¿Ø¼þ¾ßÓн¹µã¡£
1¡¢Tab ¼ü˳Ðò
µ±ÔÚä¯ÀÀÆ÷ÖÐÏÔʾҳʱ£¬Óû§¿ÉÒÔʹÓà ......
1.ÎļþÏÂÔØ
HTTP ÎļþÏÂÔØÖ÷ÒªÓÐÁ½ÖÖ·½Ê½£º
URL·½Ê½Ö±½ÓÏÂÔØ£¬ÓŵãÊÇ£ºÕ¼Ó÷þÎñÆ÷×ÊÔ´ÉÙ£¬Ëٶȿ죻ȱµãÊÇ£º ²»ÄÜ׼ȷ¼ÆÁ¿ÏÂÔØ´ÎÊý£¬ÎÞ·¨·ÀÖ¹µÁÁ´£¬±£´æÔÚÊý¾Ý¿âÖеÄÎļþÎÞ·¨ÏÂÔØ£¬³£¼û¸ñʽµÄÎļþÈç.html Ö±½ÓÔÚä¯ÀÀÆ÷Öдò¿ª£¬²»ÄÜÖ±½ÓÏÂÔØ¡£
¶þ½øÖÆÊý¾ÝÁ÷Êä³ö·½Ê½£¬ÓŵãÊÇ£º×¼È·¼ÆÁ¿ÏÂÔØ´ÎÊý¡¢ÄÜ·ÀµÁÁ´¡¢ËùÓÐÎļ ......