Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Asp.netÀûÓÃExcelLibraryÊä³öEXCEL

 public void DataTable2Excel(string attachName, DataTable tab)
        {
            string file = HttpContext.Current.Server.MapPath("/uploads/export/" + Guid.NewGuid().ToString() + ".xls");
            Workbook workbook = new Workbook();
            Worksheet worksheet = new Worksheet("Sheet1");
            //¹¹½¨±íÍ·
            for (int col = 0; col < tab.Columns.Count; col++)
            {
                worksheet.Cells[0, col] = new Cell(tab.Columns[col].ColumnName);
            }
            for (int rowIndex = 0; rowIndex < tab.Rows.Count; rowIndex++)
            {
                for (int colIndex = 0; colIndex < tab.Columns.Count; colIndex++)
                {
                    worksheet.Cells[rowIndex + 1, colIndex] = new Cell(tab.Rows[rowIndex][colIndex].ToString());
                }
            }
            //ÉèÖÃĬÈÏ¿í¶È
            if (worksheet.


Ïà¹ØÎĵµ£º

asp.net ±¸·Ý»¹Ô­Êý¾Ý¿â


1£º¿Í»§¶Ë
<table border="0" style="width: 60%">
¡¡¡¡<tr><td colspan="2" style="height: 5px">
      Êý¾Ý¿â»¹Ô­ºÍ±¸·Ý:</td></tr>
¡¡¡¡<tr><td style="width: 171px; height: 23px;">
      ÇëÑ¡ÔñÊý¾Ý¿â:</t ......

asp.netÏÂÐÞ¸ÄÎļþϵͳ´øÀ´µÄ¸±×÷Óü°Æä½â¾ö·½·¨

    ½ñÌìµÄÈÎÎñÊÇÄܹ»ÔÚasp.netϽ¨Á¢Îļþϵͳ£¬Ò²¾ÍÊÇÄܹ»ÔÚasp.netµÄÐéÄâĿ¼Ï½¨Á¢Îļþ¼Ð¡¢Îļþ¡¢ÐÞ¸ÄÎļþ¼Ð¡¢Îļþ¡¢É¾³ýÎļþ¼Ð¡¢ÎļþµÈ¡£½¨Á¢Îļþ¼Ð¡¢ÎļþºÜ˳Àû£¬Ã»ÓÐÓöµ½ÈκÎÎÊÌ⣬ֱ½ÓÓÃDirectory¾²Ì¬Àà¾Í¿ÉÒÔ×öÁË¡£
    µ«ÊÇ£¬ÔÚɾ³ý¡¢ÐÞ¸ÄÎļþ¼Ð¼°ÎļþµÄʱºòÓöµ½ÁËÆæ¹ÖµÄÎÊÌ⣺ÿ´ ......

asp.net µ¥Óû§µÇ¼¾­µä½â¾ö·½°¸


ÕâÀïÖ¸µÄµ¥µã£¬·ºÖ¸ÔÚWEB·þÎñ¶Ë£¬Ò»¸öÕË»§Í¬Ò»Ê±¿ÌÖ»ÄÜ´æÔÚÒ»¸öƱ¾Ý£¡
´ó¼Ò¿ª·¢ÖпÉÄܶ¼Åöµ½µÄÒ»¸öÎÊÌ⣬Ôõôʹͬһ¸öÓû§£¬ÔÚͬһʱ¼äÄÚÖ»ÔÊÐíµÇ¼һ´Î¡£
ºÜ¶àÈ˶¼»áÏëµ½ÔÚÊý¾Ý¿âÖÐÓÃÒ»¸ö±êʶ×ֶΣ¬µÇ¼½øÈ¥ÖÃ1,Í˳öÖÃ0,µÇ¼ʱÅжÏÕâ¸ö×ֶΣ¬Èç¹ûÊÇ1¾Í˵Ã÷´ËÓû§ÔÚÏߣ¬²»ÔÊÐíµÇ¼£¬Õâ¸ö·½°¸¿´ËÆÓÐЧ£¬µ«ÔÚʵ¼ÊʹÓÃÖз¢ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ