¡¾Çë½Ì¡¿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;
Ïà¹ØÎÊ´ð£º
°ÑÒµÎñ²ãµÄ¶¼Ð´ÔÚdllÎļþÖÐÁË£¬ÏÖÔÚÏëÒªÐ޸쬴ó¼Ò¶¼ÓÃʲô¹¤¾ß´ò¿ª£¿
ÓÃvisual studio×Ô´øµÄ ildasm¿ÉÒÔÂð£¿
ÆÚ´ý¸ßÊÖ
LZºÃÀ÷º¦
Ó÷´±àÒëÈí¼þ
ÎÒÓÃReflectorÖ»ÄÜ¿´£¬²»Äܸİ¡£¿
ÓÐÃ ......
ÎÒÓг§¼Ò×öµÄASPµÄ¼à¿ØÂ¼Ïñ£¨DVR£©µÄ¾ÖÓòÍø²¥·ÅµÄÔ´³ÌÐòÓë¿Ø¼þ£¬ÏëÒªÓÃASP.net×öÒ»¸öÊÓÆµ»Ø·ÅµÄ³ÌÐò£¨ÀûÓÃËûµÄ¿Ø¼þ£©µ«²»ÖªÈçÏÂÈ¥×ö£¬Íû¸÷λָµã¡£
ÏȸãÇå³þËûÃǵĿؼþÊÇÔõôÓõÄ,
È»ºó¾ÍÖ±½ÓÓúÃÁË.
²»¹ý,Èç ......
ÇëÎÊһϣ¬ASP.NETÎÒÓÃÒ»¸ö²ãÖзÅÁËÒ»¸öÈÕÀú¿Ø¼þ£¬ÔÚµãÒ»¸ö°´Å¥Ê±£¬ÏÔʾÕâ¸ö²ã£¿ÏÖÔÚÎÊÌâÊÇÎÒÔڵ㰴ťʱ£¬ÎÒÏë°Ñ²ãÏÔʾÔÚ°´Å¥µÄÏ·½£¿¾ÍÏñÏÂÀÈÕÆÚ¿Ø¼þÒ»Ñù£¬ÎÒÓÃÊǵÄASP.NET C#
ÎÒÓÐÕâôһ¸öÈÕÆÚ¿Ø¼þ£¬£¡µã»÷¿ÉÒÔÑ ......
ÎÒÖ÷ÒªÏë¿ØÖÆÏÂword±£´æµÄµØÖ·£¬µ«ÊDZàÒë²»¹ýÈ¥£¬×ܾõµÃÊÇȱÁËusing¡£¡£¡£
лл
´úÂëÈçÏ£º
using System;
using System.IO;
using System.Collections;
using System.ComponentModel;
using System.Data;
u ......
ASP.NETÈçºÎÓÃÒ»¸ö°´Å¥ÊµÏÖÑ¡ÔñÎļþ¼Ð·¾¶µ½Îı¾¿òÖУ¿£¨×¢ÒâÊÇÎļþ¼Ð·¾¶£¬²»ÊÇÎļþ·¾¶£©
http://blog.csdn.net/xianfajushi/archive/2008/10/18/3094474.aspx
Õâ²»ÊÇÎÒÒªµÄЧ¹û£¬ÎÒÒªÓõÄÊÇÀàËÆÓÚÎļþÉÏ´«¿ÉÒ ......