Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¡¾Çë½Ì¡¿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ÈçºÎʵÏÖ×Ô¶¯µÇ¼ - .NET¼¼Êõ / ASP.NET

ÄÄλ´ó¸çÓÐûÓÐASP.NETÖÐÀûÓÃCookiesʵÏÖÓû§×Ô¶¯µÇ¼µÄ´úÂë...ллÁË...Ô½ÏêϸԽºÃ....
ʲôÒâ˼£¿×Ô¶¯µÇ¼£¿

mark òÊÓÊÇ´æ´¢cookies ÎÒÒ²¶Ôcook±È½ÏÃÔºý ¹Ø×¢ÏÂ

¼ÈÈ»ÄãÖªµÀÓÃcookies×Ô¼º¶¯¶¯´óÄÔ¶àºÃ£¡ ......

ʲôÊÇasp.net

ÓÃDWдµÄaspxºÍvs C#дµÄÍøÕ¾ÏµÍ³(Ö÷ÒªÒ³ÃæÎļþÒ²ÊÇaspxµÄÎļþ)ÓÐÊ²Ã´Çø±ð,VSдµÄÍøÕ¾·¢²¼ºó,ËùÓеĴúÂ벿·ÖºÏ³ÉÒ»¸öDLLÎļþ,¶øDW¾ÍûÓа취,ÕâÁ½¸ö¹¤¾ßд³öÀ´µÄÍøÕ¾Í¬ÑùÊÇaspxµÄÎļþ,µ«Çø±ðºÜ´ó°¡.
°ïÄã¶¥ÏÂ~£¬Çó ......

asp.netµ¯³ö¿òÎÊÌâ

ÔÚµ¯³ö¿òÖеã»÷Ò»¸ö°´Å¥£¬Ôõôµ÷תµ½ÁíÒ»¸öä¯ÀÀÆ÷£¬²¢ÇÒÔÚ¸Ãä¯ÀÀÆ÷´ò¿ªÁ½¸öÒ³Ãæ
ÄãµÄÒâ˼Ӧ¸ÃÊÇ
response.write("<script>alert('È·ÈÏ'); window.location.href('xxxx.aspx'); </script>"); ......

ASP.NETÈÕÆÚÊäÈëÎÊÌ⣿

ÇëÎÊһϣ¬ASP.NETÎÒÓÃÒ»¸ö²ãÖзÅÁËÒ»¸öÈÕÀú¿Ø¼þ£¬ÔÚµãÒ»¸ö°´Å¥Ê±£¬ÏÔʾÕâ¸ö²ã£¿ÏÖÔÚÎÊÌâÊÇÎÒÔڵ㰴ťʱ£¬ÎÒÏë°Ñ²ãÏÔʾÔÚ°´Å¥µÄÏ·½£¿¾ÍÏñÏÂÀ­ÈÕÆÚ¿Ø¼þÒ»Ñù£¬ÎÒÓÃÊǵÄASP.NET C#
ÎÒÓÐÕâôһ¸öÈÕÆÚ¿Ø¼þ£¬£¡µã»÷¿ÉÒÔÑ ......

¹ØÓÚASP.NET¶¨Ê±Æ÷µÄÎÊÌâ

ÎÒÏëÿÌì°ëÒ¹×Ô¶¯Éú³É¾²Ì¬Ò³Ãæ¡£
ÔõôʵÏÖÕâ¸ö·½·¨¡£
ÄÇλ¸ßÊÖÖªµÀ£¬Çë´Í½ÌÏ¡£
д·þÎñ!

Ôõôд

д·þÎñ ¿ªÏß³Ì Ð´Îļþ ÈëÊý¾Ý¿â

д·þÎñ»òÕßÓÿªÔ´µÄµ÷¶È¿ò¼ÜQuartz.net
½¨ÒéÓúóÕߣ¬ºóÕßÌṩ±È½ÏÁé»îµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ