asp.net µ¼³öExcel
public bool SaveExcel(GridView paramGridView)
{
if (paramGridView.Rows.Count == 0)
{
return false;
}
//´´½¨Excel¶ÔÏó
Microsoft.Office.Interop.Excel.Application myExcel = new Microsoft.Office.Interop.Excel.Application();
myExcel.Application.Workbooks.Add(true);
myExcel.Visible = true;
//Éú³É×Ö¶ÎÃû³ÆÁÐÃû
for (int i = 0; i < paramGridView.Columns.Count; i++)
{
//µÚ¶þÐеڶþÁпªÊ¼Â¼Èë
myExcel.Cells[2, i + 2] = paramGridView.Columns[i].HeaderText;
}
//Ìî³äÊý¾Ý
for (int i = 0; i < paramGridView.Rows.Count; i++)
{
for (int j = 0; j < paramGridView.Columns.Count; j++)
{
if (paramGridView.Rows[i].Cells[j].Text != null)
{
myExcel.Cells[i + 3, j + 2] = "'" + paramGridView.Rows[i].Cells[j].Text.ToString();
}
}
}
return true;
}
protected void btnPrint_Click(object sender, EventArgs e)
{
SaveExcel(grdvMessage);
}
Ïà¹ØÎĵµ£º
¸ÃÎÄÕÂתÓ룺http://dotnet.chinaitlab.com/ASPNET/806622.html
Êý¾Ý¿â·ÃÎÊÐÔÄÜÓÅ»¯
¡¡¡¡Êý¾Ý¿âµÄÁ¬½ÓºÍ¹Ø±Õ
¡¡¡¡·ÃÎÊÊý¾Ý¿â×ÊÔ´ÐèÒª´´½¨Á¬½Ó¡¢´ò¿ªÁ¬½ÓºÍ¹Ø±ÕÁ¬½Ó¼¸¸ö²Ù×÷¡£ÕâЩ¹ý³ÌÐèÒª¶à´ÎÓëÊý¾Ý¿â½»»»ÐÅÏ¢ÒÔͨ¹ýÉí·ÝÑéÖ¤£¬±È½ÏºÄ·Ñ·þÎñÆ÷×ÊÔ´¡£ ASP.NETÖÐÌṩÁËÁ¬½Ó³Ø(Connection Pool)¸ÄÉÆ´ò¿ªºÍ¹Ø±ÕÊý¾Ý¿â¶ÔÐÔÄÜµÄ ......
Accordion¿Ø¼þʱµÄ³£ÓÃÊôÐÔ±êÇ©
ÊôÐÔ±êÇ©Ãû Ãè¡¡¡¡Êö
SelectedIndex ¸Ã¿Ø¼þ³õ´Î¼ÓÔØÊ±Õ¹¿ªµÄAccordionPaneÃæ°åµÄË÷ÒýÖµ
HeaderCssClass ¸ÃAccordionÖаüº¬µÄËùÓÐAccordionPaneÃæ°åµÄ±êÌâÇøÓòËùÓ¦ÓõÄCSS Class
ContentCssClass ¸ÃAccordionÖаüº¬µÄËùÓÐAccordionPaneÃæ°åµÄÄÚÈÝÇøÓòËùÓ¦ÓõÄCSS Class
AutoSize Ô ......
ǰǰºóºóÊÕµ½¹ýһЩѧÉúµÄÀ´ÐÅ£¬Ñ¯ÎÊASP.NETµÄѧϰ˳ÐòÎÊÌ⣬Ôڴ˾ÍÏò´òËãϵͳѧϰASP.NET¼¼ÊõµÄ³õѧÕß̸̸ÎҵĽ¨Òé¡£
Èç¹ûÄãÒѾÓн϶àµÄÃæÏò¶ÔÏ󿪷¢¾Ñé£¬Ìø¹ýÒÔÏÂÕâÁ½²½£º
µÚÒ»²½¡¡ÕÆÎÕÒ»ÃÅ.NETÃæÏò¶ÔÏóÓïÑÔ£¬C££»òVB.NET¡£
ÎÒÇ¿ÁÒ·´¶ÔÔÚûϵͳѧ¹ýÒ»ÃÅÃæÏò¶ÔÏó£¨OO£© ......
WebÀï¼ÓÈë<sessionState cookieless="false" mode="StateServer" timeout="60" stateNetworkTimeout="3600" sqlCommandTimeout="3600"/>ºó±ØÐ루cmdÀïÔËÐÐ:Net Start aspnet_state£©²Å¿ÉÒÔÉèÖÃsessionÖµ¡£
ÕâÒ»¶Î¾ÍÊÇÅäÖÃÓ¦ÓóÌÐòÊÇÈçºÎ´æ´¢SessionÐÅÏ¢µÄÁË¡£ÎÒÃÇÒÔϵĸ÷ÖÖ²Ù×÷Ö÷ÒªÊÇÕë¶ÔÕâÒ»¶ÎÅäÖÃÕ¹ ......