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µÄ´°ÌåÉí·ÝÑéÖ¤£¬ÕâÖÖÉí·ÝÑéÖ¤·½Ê½¿ÉÒÔÈÃͨ¹ýÑéÖ¤µÄÓû§·ÃÎÊÖ¸¶¨µÄĿ¼£¬¶øÃ»ÓÐͨ¹ýÑéÖ¤µÄÓû§²»ÄÜ·ÃÎʸÃĿ¼ÏµÄÍøÒ³¡£
µ«ÊÇ£¬ÓÐÒ»ÖÖÀýÍ⣬¾ÍÊÇĿ¼ÖеÄhtmlÎļþÀýÍâ¡£ÀýÈ磬ÔÚ¡¶asp.netÖеĴ°ÌåÉí·ÝÑéÖ¤£¨×î¼òµ¥Æª£©¡·ÖнéÉܵ쬳ýÁ˵ÇÂ¼ÍøÒ³Ö®Íâ ......
Ò»¡¢¸ÅÊö
¿¼ÂÇHtml±¾Éí²»´ø¶¨Ê±Ë¢ÐÂÒ³ÃæµÄ¿Ø¼þ£¬ÇÒ²»¿¼ÂÇʹÓõÚÈý·½¿Ø¼þ£»Òò´Ë¿¼ÂÇʹÓÃJavascriptÖеÄsetTimeout+xmlhttpÀ´ÊµÏÖ¶¨Ê±¸üÐÂÒ³ÃæÖв¿·ÖÄÚÈÝ£¬´ËʵÏÖÔÚIE6.0¼°ÒÔÉϰ汾²âÊÔͨ¹ý£¬ÆäËûä¯ÀÀÆ÷ÔÝʱδ²âÊÔ¹ý¡£
¶þ¡¢¹¦Äܼ°Ìصã
1¡¢Javascriptͨ¹ýMicrosoftµÄMSXML¶ÔÏ󣬶¯Ì¬»ñÈ¡ºǫ́Êý¾Ý¿âÊý¾Ý£»
&n ......
½ñÌìµÄÈÎÎñÊÇÄܹ»ÔÚasp.netϽ¨Á¢Îļþϵͳ£¬Ò²¾ÍÊÇÄܹ»ÔÚasp.netµÄÐéÄâĿ¼Ï½¨Á¢Îļþ¼Ð¡¢Îļþ¡¢ÐÞ¸ÄÎļþ¼Ð¡¢Îļþ¡¢É¾³ýÎļþ¼Ð¡¢ÎļþµÈ¡£½¨Á¢Îļþ¼Ð¡¢ÎļþºÜ˳Àû£¬Ã»ÓÐÓöµ½ÈκÎÎÊÌ⣬ֱ½ÓÓÃDirectory¾²Ì¬Àà¾Í¿ÉÒÔ×öÁË¡£
µ«ÊÇ£¬ÔÚɾ³ý¡¢ÐÞ¸ÄÎļþ¼Ð¼°ÎļþµÄʱºòÓöµ½ÁËÆæ¹ÖµÄÎÊÌ⣺ÿ´ ......
1£® ¸úÒÔǰһÑù×ö½çÃæ£¬Ö»ÊÇ×¢Ò⣬°ÑËùÓÐÐèÒªÓжàÓïÑÔ½çÃæµÄÎÄ×Ö¶¼ÓÃlabelÀ´×ö
¡¡¡¡2£® ×öÍêÒÔºó£¬ÔÚSolution ExplorerÀïÑ¡ÖÐÕâ¸öÎļþ£¬Ñ¡Tools-£¾Generate Local Resource
¡¡¡¡3£® Äã»á·¢ÏÖÉú³ÉÁËÒ»¸öĿ¼£¬App_LocalResources£»Õâ¸öĿ¼Àï¶àÁËÒ»¸öresxµÄÎļþ¡£±ÈÈçÄãµÄaspxÎļþÊÇdefault.aspx£¬Ëü¾Í»áÉú³ÉÒ»¸ö½Ð×ödefa ......