asp.net¶ÁÈ¡EXcelµÄСÌÖÂÛ
ÔÚCSÎļþÖУ¬Ê×ÏÈÔÚ¶¥²¿ÒýÈë²Ù×÷ExcelÊý¾ÝµÄÃüÃû¿Õ¼ä
using System.Data.OleDb;
Õýʽ´úÂëÈçÏ£º
private void Button_Click(object sender, System.EventArgs e)
{
string thefullname = this.uploadFile.PostedFile.FileName;//»ñÈ¡ÍêÕû·¾¶
ClientScriptManager csm = Page.ClientScript;
if (thefullname == "")
{
csm.RegisterStartupScript(GetType, "Error", "alert('ÇëÑ¡ÔñÒªÉÏ´«µÃExcelÎļþ');", true);
return;
}
int fileLength = this.uploadFile.PostedFile.ContentLength;
if (fileLength > 512000)
{
csm.RegisterStartupScript(GetType, "Error", "alert('ÎļþÒѳ¬¹ý500K£¬ÎÞ·¨ÉÏ´«£¡');", true);
return;
}
FileInfo info = new FileInfo(thefullname);
string fileExt = info.Extension;
if (fileExt.ToLower() != ".xls")
{
csm.RegisterStartupScript(GetType, "Error", "alert('²»ÊÇExcelÎļþ£¬ÇëʹÓÃÕýÈ·µÄÎļþ¸ñʽ£¡');", true);
return;
}
string uploadPath = Page.MapPath(@"uploadfile\report.xls");
 
Ïà¹ØÎĵµ£º
¡¡¡¡
¡¡¡¡ÄÚÈݼò½é
¡¡¡¡±¾ÊéÊÇASP.NETµÄÈëÃŽ̡̳£ASP.NET 3.5ÊÇ΢Èí¾«ÐÄ´òÔìµÄÐÂÐ͵ÄÈí¼þ¿ª·¢Æ½Ì¨¡£¸Ãƽ̨ÊÇÔÚ.NET2.0µÄ»ù´¡ÉÏ·¢Õ¹¶øÀ´£¬ÔÚʵ¼Ê¿ª·¢ÖÐÓй㷺ӦÓᣱ¾ÊéÒ»¹²·ÖΪËÄÆª£¬µÚһƪÖ÷Òª½²½âÁËASP.NEµÄÈëÃÅ»ù´¡ÖªÊ¶£¬ÄÚÈݰüÀ¨´î½¨ASP.NET¿ª·¢»·¾³¡¢C#ÓïÑÔ»ù´¡¡¢ÃæÏò¶ÔÏóµÄ³ÌÐòÉè¼Æ¡¢ASP.NETÄÚÖöÔÏó¡¢ASP.NETҳà ......
1£®Ê÷ÐνṹµÄÉè¼Æ
ÔÚ¿ª·¢ASP.NETµÄÏîÄ¿ÖУ¬ÓÐÐí¶àÏîÄ¿Óõ½µÄÊ÷Ðνṹ£¬ÆäÖÐÓÐЩÊ÷ÐνṹÏà¶Ô¸´ÔÓ£¬Ò²Óмòµ¥µÄ£¬µ«ÎÞÂÛÊǼòµ¥µÄÊ÷Ðνṹ»¹ÊǸ´ÔÓµÄÊ÷Ðνṹ£¬ÓÐןõĽṹ¶ÔÓÚÐÔÄܺÍÎȶ¨ÐÔ¶¼ÓÐןܴóµÄ×÷ÓᣱÈÈçÄãµÄÊ÷½á¹¹µÄÊý¾ÝºÜ´ó£¬Èç¹ûÊDzÉÓñȽÏËÀµÄ·½Ê½Ò»´ÎÐÔ¼ÓÔØ½øÀ´ÄÇôÄãÔÚ¼ÓÔØÕâ¿ÃÊ÷µÄʱºò¾ÍÊÇÏ൱µÄºÄ ......
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
  ......