¡¾Çë½Ì¡¿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;
Ïà¹ØÎÊ´ð£º
ÎÒÔÚºǫ́µ÷ÓÃJavaScriptµÄʱºò£¬ËûÊÇÔÚºǫ́°ÑʼþµÄ´úÂëÖ´ÐÐÒ»´ÎºóÔÚÖ´ÐÐJavaScript·½·¨
ÓÐʲô°ì·¨ ÔÚÖ´ÐÐJavaScript·½·¨µÄʱºòͣס£¬ÔÚÖ´ÐкóÃæµÄ´úÂë
²»Ì«Ã÷°×°¡£¬ËµÇå³þµã°É
¾ÍÊÇÖ´Ðкǫ́´úÂëµÄʱºò ......
ÎÒÖ÷ÒªÏë¿ØÖÆÏÂword±£´æµÄµØÖ·£¬µ«ÊDZàÒë²»¹ýÈ¥£¬×ܾõµÃÊÇȱÁËusing¡£¡£¡£
лл
´úÂëÈçÏ£º
using System;
using System.IO;
using System.Collections;
using System.ComponentModel;
using System.Data;
u ......
ÎÒÓÃMULTIVIEW£«VIEW£«FORMVIEW×öÊäÈëÍøÒ³£¬
ÎÒÊäÈëµÄÊý¾ÝÒª²åÈëËĸö±í¡£
ÒªÔõô×öÄØ£¿
sf
ÊÂÎñ°¡
È»ºóдsqlÓï¾ä¿©
ÄãµÄÎÊÌâÊÇUI·½ÃæµÄÄÚÈÝ£¬Õâ¸öºÍÄã²åÈë¶àÉÙÕűíûÓÐʲô¹ØÏµµÄ£»
Transaction ¿ØÖÆÕû ......
ASP.NETÈçºÎÓÃÒ»¸ö°´Å¥ÊµÏÖÑ¡ÔñÎļþ¼Ð·¾¶µ½Îı¾¿òÖУ¿£¨×¢ÒâÊÇÎļþ¼Ð·¾¶£¬²»ÊÇÎļþ·¾¶£©
http://blog.csdn.net/xianfajushi/archive/2008/10/18/3094474.aspx
Õâ²»ÊÇÎÒÒªµÄЧ¹û£¬ÎÒÒªÓõÄÊÇÀàËÆÓÚÎļþÉÏ´«¿ÉÒ ......