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.
Ïà¹ØÎĵµ£º
ÔÚWeb±à³Ì¹ý³ÌÖУ¬´æÔÚןܶలȫÒþ»¼¡£±ÈÈçÔÚÒÔÇ°µÄASP°æ±¾ÖУ¬CookieΪ·ÃÎÊÕߺͱà³ÌÕ߶¼ÌṩÁË·½±ã£¬²¢Ã»ÓÐÌṩ¼ÓÃܵŦÄÜ¡£´ò¿ªIEä¯ÀÀÆ÷£¬Ñ¡Ôñ“¹¤¾ß”²Ëµ¥ÀïµÄ“InternetÑ¡Ï¬È»ºóÔÚµ¯³öµÄ¶Ô»°¿òÀïµ¥»÷“ÉèÖÔ°´Å¥£¬Ñ¡Ôñ“²é¿´Îļþ”°´Å¥£¬ÔÚµ¯³öµÄ´°¿ÚÖУ¬¾Í»áÏÔʾӲÅÌÀï ......
1¡¢Ê×ÏÈÏÂÔØowc11£ºowc11(http://www.svnhost.cn/Download/Detail-60.shtml)
2¡¢ÒýÓÃOWC£º´ò¿ª"½â¾ö·½°¸×ÊÔ´¹ÜÀíÆ÷"Ãæ°å£¬Êó±êÓÒ¼üµ¥»÷"ÒýÓÃ"£¬Ñ¡Ôñ"Ìí¼ÓÒýÓÃ"²Ëµ¥£¬ÔÚµ¯³öµÄ"Ìí¼ÓÒýÓÃ"¶Ô»°¿òÖе¥»÷"COM"¿¨Æ¬£¬ÕÒµ½"Microsoft Office Web Components 10.0(office 2003ÊÇ11.0)"£¬µ¥»÷"Ñ¡Ôñ"ºÍ"È·¶¨"°´Å¥£¬OWC¾Í±»Ìí¼Óµ½ÁËÒý ......
Cache ¼´¸ßËÙ»º´æ £¬ÎÒÏëºÜ¶àÈ˶ÔËûµÄµÚÒ»Ó¡ÏóÒ»¶¨ÏñÎÒÒ»Ñù£¬¸Ð¾õËûÒ»¶¨ÄÜÌá¸ßϵͳµÃÐÔÄܺÍÔËÐÐËٶȡ£µÄÈ·¡£NetÍƳöcacheµÄ³õÖÔȷʵÊÇÕâÑùµÄ¡£ÄÇôcacheÊÇÈçºÎÌá¸ßϵͳÐÔÄÜÓëÔËÐÐËÙ¶ÈÄØ£¿ÊDz»ÊÇÔÚÈκÎÇé¿öÏÂÓÃcache¶¼ÄÜÌá¸ßÐÔÄÜ£¿ÊDz»ÊÇcacheÓõÄÔ½¶à¾ÍÔ½ºÃÄØ£¿ÎÒÔÚ½üÆÚ¿ª·¢µÄÏîÄ¿ÖÐÓÐËùÌå»á£¬Ð´ÏÂÀ´µ±×÷×ܽáҲϣÍûÄܸú´ó¼Ò ......
1£® ¸úÒÔÇ°Ò»Ñù×ö½çÃ棬ֻÊÇ×¢Ò⣬°ÑËùÓÐÐèÒªÓжàÓïÑÔ½çÃæµÄÎÄ×Ö¶¼ÓÃlabelÀ´×ö
¡¡¡¡2£® ×öÍêÒÔºó£¬ÔÚSolution ExplorerÀïÑ¡ÖÐÕâ¸öÎļþ£¬Ñ¡Tools-£¾Generate Local Resource
¡¡¡¡3£® Äã»á·¢ÏÖÉú³ÉÁËÒ»¸öĿ¼£¬App_LocalResources£»Õâ¸öĿ¼Àï¶àÁËÒ»¸öresxµÄÎļþ¡£±ÈÈçÄãµÄaspxÎļþÊÇdefault.aspx£¬Ëü¾Í»áÉú³ÉÒ»¸ö½Ð×ödefa ......
JavaScriptµ÷ÓÃdataTable²¢»ñÈ¡ÆäÖµ(ASP.Net,VS2005)
±¾¹¦ÄÜÖ÷ÒªÓõ½http://www.cnblogs.com/Hdsome/archive/2008/06/26/1230177.htmlÕâ¸öÐֵܵĴúÂ룬ÎÒÖ÷ÒªÊÇ×öÕûÀíºÍÀ©Õ¹¡£
Ê×ÏÈÔÚhttp://www.codeplex.com/AjaxPro/Release/ProjectReleases.aspx?ReleaseId=713ÍøÖ ......