Asp.Net ¶ÁÈ¡Excel
±¾ÈËÏë×öÒ»¸öÍøÒ³£¬µ«¾ßÓжÁȡҲ¾ÍÊǵ¼ÈëExcel¹¦ÄÜ,¶øÇÒÊǶÁÈ¡¼¸ÕÅExcelÎĵµµ¥»÷¶Áȡ֮ºóÔÙ¶ÁÈ¡£¬È»ºó½«Õ⼸ÕÅÎĵµºÏ²¢²¢ÏÔʾÔÚÍøÒ³ÉÏ£¬¶øÇÒÏàͬµÄÕ⼸ÕÅÎĵµÖеÄÊý¾ÝÍêÈ«ÏàͬÔÙÔÚÊýÁ¿ÉϼÓ1£¬£¨È磺CPU Èç¹ûÓÐÁ½¸öÇÒ¶¼intelµÄ ¶¼ÊÇ¿áî£i7µÄ¾ÍÖ»½²ÊýÁ¿¼Ó1£¬Ö»ÒªÓÐÒ»µã²»Í¬¾Í¿ÉÒÔ²»ÓüÓÊýÁ¿ excel ¸ñʽ¿ÉÒԹ̶¨£©
Ï£Íû¸÷λ¸ßÊÖ°ï°ï棡£¡£¡£¡ лл¡¡
Èç¹û¸ñʽ¿ÉÒԹ̶¨£¬¿ÉÒÔʹÓÃÊý¾Ý¿âÁ¬½ÓµÄ·½Ê½Á¬½Óexcel
string strConnection = "Provider=Microsoft.ACE.OLEDB.12.0;";
strConnection += @"Data Source=C:\Documents and Settings\v-changl\My Documents\couse.xlsx;";
strConnection += "Extended Properties=\"Excel 12.0 Xml;HDR=YES\";";
OleDbConnection objConnection = new OleDbConnection(strConnection);
objConnection.Open();
OleDbDataAdapter myCommandd = new OleDbDataAdapter("select * from [Sheet1$]", objConnection);
DataSet ds = new DataSet();
myCommandd.Fill(ds, "[Sheet1$]");
System.Data.DataTable dt = ds.Tables["[Sheet1$]"];
Console.WriteLine(dt.Columns[0].ToString());
Console.WriteLine(dt.Columns[1].ToString());
»ñÈ¡sheetsÊý±éÀú
string strConn = "Provider=Microsoft.Jet.OLED
Ïà¹ØÎÊ´ð£º
µ÷ÕûÁËÕâÀÄÇÀï³öÎÊÌâ¡£
ÓÐûÓÐʲôºÃµÄ·½·¨£¬Ïñµ÷Õû¶Ô»°¿òÒ»Ñù£¿£¿£¿£¿
ÕÒ¸öרÃÅ×öÒ³ÃæµÄ
ÔÚdreamweaverÀïµ÷¡£¡£¡£Ò²¿ÉÒÔÖ±½Ó¿ØÖÆHTML´úÂë
ȷʵʹ¿à ¸ÐͬÉíÊÜѽ
¹þ¹þ ¼á¾ö·¹ý¡£
ÓÃDW°É£¬VS¸ãÉè¼Æ ......
ÀàËÆÓÚcsdn ÓÒ±ßÓÃʲô¿Ø¼þÏÔʾÌù×Ó±êÌâ ÒÔ¼°ÔõÑù·ÖÒ³£¿¹òÇó¸ßÊÖ´ð¸´
Ðø£º¾ÍÏñµãµ½asp°æ È»ºóÏÔʾÌù×Ó
Ëæ±ãÄ㣡£¡
·ÖÒ³¿Ø¼þÕâ¸ö¾Í¶àÁË£¡
aspnetpager
http://www.webdiyer.com/AspNetPager
ÕâÀïÏÔʾÌù× ......
ÎÒÓÃasp.net¿ª·¢wapÕ¾µã£¬Íê³ÉºóÈ¥http://validator.w3.org/ÕâÀïÑéÖ¤ÎÒµÄWapÒ³ÃæÊÇ·ñ±ê×¼£¬ÆäËüÎÊÌâ¶¼¸ÄºÃÁË£¬
¾ÍÊ£ÕâÒ»¸ö´íÎóÁË£¬°´×ÖÃæÒâ˼Àí½âÊÇ˵nameÊôÐÔÒÑ´æÔÚ£¬ÀàËÆÕâÑùµÄ´íÎó»¹Óв»ÄÜÓÃborder ,align,sizeµ ......
ÎÒÅóÓѵÄÒ»¸öASP.NETÒýÓÃÁËajax¼¼Êõ£¬binĿ¼ÏÂÃæÒ²ÓÐajaxpro.dll£¬ÎªÊ²Ã´·þÎñÆ÷²»ÐèÒª°²×°ajax²å¼þÒ²¿ÉÒÔÔËÐÐÄØ£¬ÕÕÀí˵Ӧ¸ÃÒª°²×°ASPAJAXExtSetup.msi
ÓÐ ajaxpro.dll¾Í¿ÉÒÔÁË
²»Í¬µÄaajx×é¼þ
AjaxPro¾ÍÊÇ¿ò¼ ......
asp.netÅúÁ¿ÉÏ´«Í¼Æ¬×îºÃÓÐÔ´Â룬ÔÚÏߵȣ¡£¡£¡£¡£¡£¡£¡
Ô´ÂëºÜ³¤µÄ¡£
²Î¿¼
C# code:
HttpFileCollection files = HttpContext.Current.Request.Files;
if (files.Count <= 1)
{
......