¹ØÓÚ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
Ïà¹ØÎĵµ£º
ÔÚWeb±à³Ì¹ý³ÌÖУ¬´æÔÚןܶలȫÒþ»¼¡£±ÈÈçÔÚÒÔǰµÄASP°æ±¾ÖУ¬CookieΪ·ÃÎÊÕߺͱà³ÌÕß¶¼ÌṩÁË·½±ã£¬²¢Ã»ÓÐÌṩ¼ÓÃܵŦÄÜ¡£´ò¿ªIEä¯ÀÀÆ÷£¬Ñ¡Ôñ“¹¤¾ß”²Ëµ¥ÀïµÄ“InternetÑ¡Ï¬È»ºóÔÚµ¯³öµÄ¶Ô»°¿òÀïµ¥»÷“ÉèÖÔ°´Å¥£¬Ñ¡Ôñ“²é¿´Îļþ”°´Å¥£¬ÔÚµ¯³öµÄ´°¿ÚÖУ¬¾Í»áÏÔʾӲÅÌÀï ......
Default.aspx CSÎļþ´úÂë
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class _De ......
Asp.NetÖм¸ÖÖÏàËÆµÄ±ê¼Ç·ûºÅ: < %=...%>< %#... %>< % %>< %@ %>½âÊͼ°Ó÷¨
´ð: < %#... %>: ÊÇÔڰ󶨿ؼþDataBind()·½·¨Ö´ÐÐʱ±»Ö´ÐУ¬ÓÃÓÚÊý¾Ý°ó¶¨
Èç: < %# Container.DataItem("tit") %>
< %= %>: ÔÚ³ÌÐòÖ´ÐÐʱ±»µ÷Ó㬿ÉÒÔÏÔʾºǫ́±äÁ¿Öµ
Èç:
*.aspx ......
°Ë¡¢ASP.NET Web ·þÎñÆ÷¿Ø¼þÄ£°å
´ó¶àÊý Web ·þÎñÆ÷¿Ø¼þ¾ßÓÐĬÈϵIJ¼¾ÖºÍÍâ¹Û£¬µ«ÊÇÄú¿ÉÒÔͨ¹ýÉèÖÃÊôÐÔ»òʹÓÃÑùʽÀ´²Ù×ÝËüÃÇ¡£²¿·Ö Web ·þÎñÆ÷¿Ø¼þ»¹ÔÊÐíÄúʹÓÃÄ£°åÀ´×Ô¶¨ÒåÆäÍâ¹Û¡£
Ä£°åÊÇÒ»×é HTML ÔªËØºÍ¿Ø¼þ£¬ËüÃǹ¹³É¿Ø¼þÌØ¶¨²¿·ÖµÄ²¼¾Ö¡£ÀýÈ磬ÔÚ DataList Web ·þÎñÆ÷¿Ø¼þÖУ¬Äú¿ÉÒ ......
ÈçºÎͨ¹ýASP.NETÀ´ÏÂÔØÎļþ£¬Õâ¸öÎÊÌâÎÒÃǾ³£Óöµ½£¬°Ñ³£Óõķ½·¨×ܽᵽһÆð£¬Ñ§Ï°Ñ§Ï°¡£µ±ÎÒÃÇÒªÈÃÓû§ÏÂÔØÒ»¸öÎļþ£¬×î¼òµ¥µÄ·½Ê½ÊÇͨ¹ýResponse.RedirectÖ¸Á
Response.Redirect("test.doc")
Äú¿ÉÒÔ°ÑÉÏÃæÕâÐÐÖ¸Áî·ÅÔÚButtonµÄClickʼþµ±ÖУ¬µ±Óû§µã»÷°´Å¥Ö®ºó£¬ÍøÒ³¾Í»á±»×ªÖ·µ½¸Ãwordµµ£¬Ôì³ÉÏÂÔØµÄЧ¹û¡ ......