Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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;




Ïà¹ØÎÊ´ð£º

ºǫ́µ÷ÓÃJavaScriptÎÊÌâ - .NET¼¼Êõ / ASP.NET

ÎÒÔÚºǫ́µ÷ÓÃJavaScriptµÄʱºò£¬ËûÊÇÔÚºǫ́°ÑʼþµÄ´úÂëÖ´ÐÐÒ»´ÎºóÔÚÖ´ÐÐJavaScript·½·¨
 ÓÐʲô°ì·¨ ÔÚÖ´ÐÐJavaScript·½·¨µÄʱºòͣס£¬ÔÚÖ´ÐкóÃæµÄ´úÂë
²»Ì«Ã÷°×°¡£¬ËµÇå³þµã°É

¾ÍÊÇÖ´Ðкǫ́´úÂëµÄʱºò ......

asp.net¿ØÖÆword~~~~¼± - .NET¼¼Êõ / ASP.NET

ÎÒÖ÷ÒªÏë¿ØÖÆÏÂword±£´æµÄµØÖ·£¬µ«ÊDZàÒë²»¹ýÈ¥£¬×ܾõµÃÊÇȱÁËusing¡£¡£¡£
лл
´úÂëÈçÏ£º
using System;
using System.IO;
using System.Collections;
using System.ComponentModel;
using System.Data;
u ......

asp.net¶à±íÊäÈëÓÐʲôºÃ°ì·¨£¡

ÎÒÓÃMULTIVIEW£«VIEW£«FORMVIEW×öÊäÈëÍøÒ³£¬
ÎÒÊäÈëµÄÊý¾ÝÒª²åÈëËĸö±í¡£
ÒªÔõô×öÄØ£¿
sf

ÊÂÎñ°¡
È»ºóдsqlÓï¾ä¿©

ÄãµÄÎÊÌâÊÇUI·½ÃæµÄÄÚÈÝ£¬Õâ¸öºÍÄã²åÈë¶àÉÙÕűíûÓÐʲô¹ØÏµµÄ£»

Transaction ¿ØÖÆÕû ......

asp.net»ñÈ¡Îļþ¼Ð·¾¶ - .NET¼¼Êõ / ASP.NET

ASP.NETÈçºÎÓÃÒ»¸ö°´Å¥ÊµÏÖÑ¡ÔñÎļþ¼Ð·¾¶µ½Îı¾¿òÖУ¿£¨×¢ÒâÊÇÎļþ¼Ð·¾¶£¬²»ÊÇÎļþ·¾¶£©
http://blog.csdn.net/xianfajushi/archive/2008/10/18/3094474.aspx

Õâ²»ÊÇÎÒÒªµÄЧ¹û£¬ÎÒÒªÓõÄÊÇÀàËÆÓÚÎļþÉÏ´«¿ÉÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ