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);
}
Ïà¹ØÎĵµ£º
ÔÚ¿ª·¢¹ý³ÌÖУ¬Í¨¹ýÃþË÷²é×ÊÁÏ£¬ÊÕ¼¯ÁËһЩֵµÃÌá³öÀ´µÄ¾Ñ飺
1¡¢ Ïà¶ÔÓÚÔÀ´µÄforÓï¾äforeach¾ßÓиüºÃµÄÖ´ÐÐЧÂÊ£¬foreachµÄƽ¾ù»¨·Ñʱ¼äÖ»ÓÐforµÄ30%¡£Í¨¹ý²âÊÔ½á¹ûÔÚforºÍforeach¶¼¿ÉÒÔʹÓõÄÇé¿öÏ£¬ÎÒÃÇÍÆ¼öʹÓÃЧÂʸü¸ßµÄforeach¡£ÁíÍ⣬ÓÃforдÈëÊý¾Ýʱ¼ä´óÔ¼ÊǶÁÈ¡Êý¾Ýʱ¼äµÄ10±¶×óÓÒ£»
2¡¢ ÔÚasp.net³ÌÐòÖУ¬ ......
Ò»¡¢´´½¨Îļþ¼Ð
#region ´´½¨Îļþ¼Ð
/// <summary>
/// Self_Function:´´½¨Îļþ¼Ð
/// </summary>
/// <param name="path">´´½¨Îļþ¼ÐµÄ·¾¶</param>
/// <param name="noyes">Òþ²ØÎ ......
Èç¹ûÄã²»×ÜÊÇÓà Windows
É쵀 Internet
Explorer
À´ÉÏÍøµÄ»°£¬Äã¿ÉÄÜ»á×¢Òâµ½£¬Ðí¶àÍøÕ¾ÉϵÄÊÓÆµµã²¥Ö®ÀàµÄ¶àýÌåÄÚÈÝ£¬ÄãÎÞ·¨Ö±½ÓÔÚ Internet Explorer
ÒÔÍâµÄÆäËüä¯ÀÀÆ÷Öйۿ´£¬±ÈÈçÃ÷Ã÷ÒѾ°²×°
Á˲å¼þÈ´ÌáʾȱÉÙ²å¼þ£¬»òÕßʲô¶¼²»Ìáʾ³öÏֿյĿò¿ò£¬»òÕßÏÔ
ʾÁ˲¥·ÅÆ÷²å¼þȴʼÖÕÁ¬²»ÉÏ´ò²»¿ªÖ®ÀàµÄÎÊÌ⣠......
C# ASP.NETÀï@µÄÃîÓÃ
ASP.NET C# string ×Ö·û´®µÄÇ°Ãæ¿ÉÒÔ¼Ó @ ¿ÉÒÔ½«×ªÒå×Ö·û£¨\£©µ±×÷ÆÕͨ×Ö·û¶Ô´ý¡£
±ÈÈ磺string str = @"C:\Windows";
Èç¹ûÎÒÃDz»Óà @ µÄ»°£¬Ó¦¸ÃÊÇ£ºstring str = "C:\\Windows";
@ ×Ö·û´®ÖУ¬ÎÒÃÇÓÃÁ½¸öÁ¬ÐøÓ¢ÎÄË«ÒýºÅ±íʾһ¸öÓ¢ÎÄË«ÒýºÅ£¬ÈçÏÂ×Ö·û´®µÄʵ¼ÊÄÚÈÝΪ£º="=£¬×Ö·û´®³¤¶ÈΪ 3 ......
/// <summary>
/// дCookies
/// </summary>
/// <param name="response"></param>
/// <param name="request"></param>
&n ......