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.
Ïà¹ØÎĵµ£º
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µÄÐéÄâĿ¼Ï½¨Á¢Îļþ¼Ð¡¢Îļþ¡¢ÐÞ¸ÄÎļþ¼Ð¡¢Îļþ¡¢É¾³ýÎļþ¼Ð¡¢ÎļþµÈ¡£½¨Á¢Îļþ¼Ð¡¢ÎļþºÜ˳Àû£¬Ã»ÓÐÓöµ½ÈκÎÎÊÌ⣬ֱ½ÓÓÃDirectory¾²Ì¬Àà¾Í¿ÉÒÔ×öÁË¡£
µ«ÊÇ£¬ÔÚɾ³ý¡¢ÐÞ¸ÄÎļþ¼Ð¼°ÎļþµÄʱºòÓöµ½ÁËÆæ¹ÖµÄÎÊÌ⣺ÿ´ ......
ÕâÀïÖ¸µÄµ¥µã£¬·ºÖ¸ÔÚWEB·þÎñ¶Ë£¬Ò»¸öÕË»§Í¬Ò»Ê±¿ÌÖ»ÄÜ´æÔÚÒ»¸öƱ¾Ý£¡
´ó¼Ò¿ª·¢ÖпÉÄܶ¼Åöµ½µÄÒ»¸öÎÊÌ⣬Ôõôʹͬһ¸öÓû§£¬ÔÚͬһʱ¼äÄÚÖ»ÔÊÐíµÇ¼һ´Î¡£
ºÜ¶àÈ˶¼»áÏëµ½ÔÚÊý¾Ý¿âÖÐÓÃÒ»¸ö±êʶ×ֶΣ¬µÇ¼½øÈ¥ÖÃ1,Í˳öÖÃ0,µÇ¼ʱÅжÏÕâ¸ö×ֶΣ¬Èç¹ûÊÇ1¾Í˵Ã÷´ËÓû§ÔÚÏߣ¬²»ÔÊÐíµÇ¼£¬Õâ¸ö·½°¸¿´ËÆÓÐЧ£¬µ«ÔÚʵ¼ÊʹÓÃÖз¢ ......