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);
 
Ïà¹ØÎĵµ£º
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="LeftMenu.aspx.cs" Inherits="_Default" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xht ......
¶þ¡¢Ïò ASP.NET ÍøÒ³Ìí¼Ó HTML ·þÎñÆ÷¿Ø¼þ
HTML ·þÎñÆ÷¿Ø¼þÊÇÄú¿ÉÒÔ¶ÔÆä½øÐÐÅäÖÃÒÔ±ã¿ÉÒÔʹÓ÷þÎñÆ÷´úÂë¶ÔÆä½øÐбà³ÌµÄ HTML ÔªËØ¡£
1¡¢ÈçºÎ£ºÊ¹Óà ASP.NET Óï·¨ÏòÍøÒ³Ìí¼Ó HTML ·þÎñÆ÷¿Ø¼þ
Ìí¼Ó HTML ·þÎñÆ÷¿Ø¼þºÍÌí¼ÓÈÎÒâ HTML ÔªËØÀàËÆ£¬²»Í¬Ö®´¦ÔÚÓÚ ......
°Ë¡¢ASP.NET Web ·þÎñÆ÷¿Ø¼þÄ£°å
´ó¶àÊý Web ·þÎñÆ÷¿Ø¼þ¾ßÓÐĬÈϵIJ¼¾ÖºÍÍâ¹Û£¬µ«ÊÇÄú¿ÉÒÔͨ¹ýÉèÖÃÊôÐÔ»òʹÓÃÑùʽÀ´²Ù×ÝËüÃÇ¡£²¿·Ö Web ·þÎñÆ÷¿Ø¼þ»¹ÔÊÐíÄúʹÓÃÄ£°åÀ´×Ô¶¨ÒåÆäÍâ¹Û¡£
Ä£°åÊÇÒ»×é HTML ÔªËØºÍ¿Ø¼þ£¬ËüÃǹ¹³É¿Ø¼þÌØ¶¨²¿·ÖµÄ²¼¾Ö¡£ÀýÈ磬ÔÚ DataList Web ·þÎñÆ÷¿Ø¼þÖУ¬Äú¿ÉÒ ......
ÈçºÎͨ¹ýASP.NETÀ´ÏÂÔØÎļþ£¬Õâ¸öÎÊÌâÎÒÃǾ³£Óöµ½£¬°Ñ³£Óõķ½·¨×ܽᵽһÆð£¬Ñ§Ï°Ñ§Ï°¡£µ±ÎÒÃÇÒªÈÃÓû§ÏÂÔØÒ»¸öÎļþ£¬×î¼òµ¥µÄ·½Ê½ÊÇͨ¹ýResponse.RedirectÖ¸Á
Response.Redirect("test.doc")
Äú¿ÉÒÔ°ÑÉÏÃæÕâÐÐÖ¸Áî·ÅÔÚButtonµÄClickʼþµ±ÖУ¬µ±Óû§µã»÷°´Å¥Ö®ºó£¬ÍøÒ³¾Í»á±»×ªÖ·µ½¸Ãwordµµ£¬Ôì³ÉÏÂÔØµÄЧ¹û¡ ......