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");
 
Ïà¹ØÎĵµ£º
±¨´íÐÅÏ¢ÈçÏ£º
¼ìË÷ COM À๤³§ÖÐ CLSID Ϊ {00024500-0000-0000-C000-000000000046} µÄ×é¼þʱʧ°Ü£¬ÔÒòÊdzöÏÖÒÔÏ´íÎó: 80070005¡£
ÍøÉÏÕÒÌù½â¾öÈçÏ£¬×ªÌù×÷¼Ç~~
ת×Ô£ºhttp://blog.csdn.net/happy_ddm/archive/2007/07/09/1683207.aspx
½â¾ö·½·¨£º
ÔÚDCOM×é¼þ·þÎñÖиøMICROSOFT.EXCEL×é¼þ¸³ÓèASP.NETµÄ²Ù×÷ȨÏÞ£¬ ......
1£®Ê÷ÐνṹµÄÉè¼Æ
ÔÚ¿ª·¢ASP.NETµÄÏîÄ¿ÖУ¬ÓÐÐí¶àÏîÄ¿Óõ½µÄÊ÷Ðνṹ£¬ÆäÖÐÓÐЩÊ÷ÐνṹÏà¶Ô¸´ÔÓ£¬Ò²Óмòµ¥µÄ£¬µ«ÎÞÂÛÊǼòµ¥µÄÊ÷Ðνṹ»¹ÊǸ´ÔÓµÄÊ÷Ðνṹ£¬ÓÐןõĽṹ¶ÔÓÚÐÔÄܺÍÎȶ¨ÐÔ¶¼ÓÐןܴóµÄ×÷ÓᣱÈÈçÄãµÄÊ÷½á¹¹µÄÊý¾ÝºÜ´ó£¬Èç¹ûÊDzÉÓñȽÏËÀµÄ·½Ê½Ò»´ÎÐÔ¼ÓÔØ½øÀ´ÄÇôÄãÔÚ¼ÓÔØÕâ¿ÃÊ÷µÄʱºò¾ÍÊÇÏ൱µÄºÄ ......
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
  ......
³ö´¦£º¶¯Ì¬ÍøÕ¾ÖÆ×÷Ö¸ÄÏ ×÷Õߣº¶¯Ì¬ÍøÕ¾ÖÆ×÷Ö¸ÄÏ Ê±¼ä£º2006-3-20 12:40:00
Ò»¸öÎüÒýÈ˵ġ¢¹¦ÄÜÍ걸µÄÍøÕ¾ÍùÍù¾ßÓÐÒÔÏÂÌØÕ÷£ºÒ»ÊÇÄÚÈݳäʵ¡¢ÊµÓã¬ÎüÒý¶Ô¸ÃÀàÄÚÈݸÉÐËȤµÄä¯ÀÀÕߣ»¶þÊÇÒ³ÃæÉèÖúÏÀí£¬Ò³ÃæÉè¼Æ¾«ÃÀ£»ÈýÊÇÍøÕ¾»¥¶¯ÐÔÇ¿£¬Óû§ºÍÍøÕ¾»òÕßÓû§ÓëÓû§Ö®¼ä½»Á÷·½±ã¸ßЧ£»ËÄÊÇÍøÕ¾ÄÚÈݸüм°Ê±²¢ÇÒ¿ ......