¡¾Çë½Ì¡¿asp.netµ¼³öexcelÒÔÖÁÓÚOFFICEÈí¼þ³öÒì³£!
ÓÉÓÚexcel¸ñʽ±È½Ï¸´ÔÓ£¬ËùÒÔÓõ½ÁËÄ£°å£¬Ã¿´Îµ¼³öµÄʱºòÏȰÑÄ£°å¸´ÖÆÒ»·Ýµ½Ò»¸öеÄĿ¼Ï£¬È»ºó½øÐÐÌî³ä£¬ÔÙÏÂÔØ¡£
C# code:
_Worksheet sheet1 = null;//sheet1
//ÅжÏÊÇ·ñ¸´ÖƳɹ¦£º¶ÔÄ£°å½øÐи´ÖÆ£¬È»ºó±£´æµ½Ò»¸öеÄĿ¼Ï£¬ÔÙÏÂÔØ
string m_newPath = change(System.Configuration.ConfigurationManager.AppSettings["oldPath"] + "customer2.xls", filename);
if (string.IsNullOrEmpty(m_newPath))
{
return;
}
object missing = Missing.Value;
Microsoft.Office.Interop.Excel.Application myExcel = new Microsoft.Office.Interop.Excel.Application();
//´ò¿ªÐÂÎļþ
myExcel.Application.Workbooks.Open(m_newPath, missing, missing, missing, missing,
missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
//½«ExcelÏÔʾ³öÀ´
myExcel.Visible = true;
//½«ÁбêÌâºÍʵ¼ÊÄÚÈÝÑ¡ÖÐ
Microsoft.Office.Interop.Excel.Workbook myBook = myExcel.Workbooks[1];
sheet1 = (_Worksheet)myExcel.Worksheets[1];
sheet1.Cells[1, 1] = ¡°¡±£»
¡£¡£¡£¡£¡£¡£
myBook.Save();
myBook.Close(missing, missing, missing);
myExcel.Quit();
myExcel = null;
myBook = null;
sheet1 = null;
Ïà¹ØÎÊ´ð£º
ÄÄλ´ó¸çÓÐûÓÐASP.NETÖÐÀûÓÃCookiesʵÏÖÓû§×Ô¶¯µÇ¼µÄ´úÂë...ллÁË...Ô½ÏêϸԽºÃ....
ʲôÒâ˼£¿×Ô¶¯µÇ¼£¿
mark òÊÓÊÇ´æ´¢cookies ÎÒÒ²¶Ôcook±È½ÏÃÔºý ¹Ø×¢ÏÂ
¼ÈÈ»ÄãÖªµÀÓÃcookies×Ô¼º¶¯¶¯´óÄÔ¶àºÃ£¡ ......
ÓÃDWдµÄaspxºÍvs C#дµÄÍøÕ¾ÏµÍ³(Ö÷ÒªÒ³ÃæÎļþÒ²ÊÇaspxµÄÎļþ)ÓÐÊ²Ã´Çø±ð,VSдµÄÍøÕ¾·¢²¼ºó,ËùÓеĴúÂ벿·ÖºÏ³ÉÒ»¸öDLLÎļþ,¶øDW¾ÍûÓа취,ÕâÁ½¸ö¹¤¾ßд³öÀ´µÄÍøÕ¾Í¬ÑùÊÇaspxµÄÎļþ,µ«Çø±ðºÜ´ó°¡.
°ïÄã¶¥ÏÂ~£¬Çó ......
ÔÚµ¯³ö¿òÖеã»÷Ò»¸ö°´Å¥£¬Ôõôµ÷תµ½ÁíÒ»¸öä¯ÀÀÆ÷£¬²¢ÇÒÔÚ¸Ãä¯ÀÀÆ÷´ò¿ªÁ½¸öÒ³Ãæ
ÄãµÄÒâ˼Ӧ¸ÃÊÇ
response.write("<script>alert('È·ÈÏ'); window.location.href('xxxx.aspx'); </script>"); ......
ÇëÎÊһϣ¬ASP.NETÎÒÓÃÒ»¸ö²ãÖзÅÁËÒ»¸öÈÕÀú¿Ø¼þ£¬ÔÚµãÒ»¸ö°´Å¥Ê±£¬ÏÔʾÕâ¸ö²ã£¿ÏÖÔÚÎÊÌâÊÇÎÒÔڵ㰴ťʱ£¬ÎÒÏë°Ñ²ãÏÔʾÔÚ°´Å¥µÄÏ·½£¿¾ÍÏñÏÂÀÈÕÆÚ¿Ø¼þÒ»Ñù£¬ÎÒÓÃÊǵÄASP.NET C#
ÎÒÓÐÕâôһ¸öÈÕÆÚ¿Ø¼þ£¬£¡µã»÷¿ÉÒÔÑ ......
ÎÒÏëÿÌì°ëÒ¹×Ô¶¯Éú³É¾²Ì¬Ò³Ãæ¡£
ÔõôʵÏÖÕâ¸ö·½·¨¡£
ÄÇλ¸ßÊÖÖªµÀ£¬Çë´Í½ÌÏ¡£
д·þÎñ!
Ôõôд
д·þÎñ ¿ªÏß³Ì Ð´Îļþ ÈëÊý¾Ý¿â
д·þÎñ»òÕßÓÿªÔ´µÄµ÷¶È¿ò¼ÜQuartz.net
½¨ÒéÓúóÕߣ¬ºóÕßÌṩ±È½ÏÁé»îµ ......