asp.net¶ÁÈ¡EXcelµÄСÌÖÂÛ
ÔÚCSÎļþÖУ¬Ê×ÏÈÔÚ¶¥²¿ÒýÈë²Ù×÷ExcelÊý¾ÝµÄÃüÃû¿Õ¼ä
using System.Data.OleDb;
Õýʽ´úÂëÈçÏ£º
private void Button_Click(object sender, System.EventArgs e)
{
string thefullname = this.uploadFile.PostedFile.FileName;//»ñÈ¡ÍêÕû·¾¶
ClientScriptManager csm = Page.ClientScript;
if (thefullname == "")
{
csm.RegisterStartupScript(GetType, "Error", "alert('ÇëÑ¡ÔñÒªÉÏ´«µÃExcelÎļþ');", true);
return;
}
int fileLength = this.uploadFile.PostedFile.ContentLength;
if (fileLength > 512000)
{
csm.RegisterStartupScript(GetType, "Error", "alert('ÎļþÒѳ¬¹ý500K£¬ÎÞ·¨ÉÏ´«£¡');", true);
return;
}
FileInfo info = new FileInfo(thefullname);
string fileExt = info.Extension;
if (fileExt.ToLower() != ".xls")
{
csm.RegisterStartupScript(GetType, "Error", "alert('²»ÊÇExcelÎļþ£¬ÇëʹÓÃÕýÈ·µÄÎļþ¸ñʽ£¡');", true);
return;
}
string uploadPath = Page.MapPath(@"uploadfile\report.xls");
 
Ïà¹ØÎĵµ£º
//2007Äê4ÔÂ24ÈÕ
this.TextBox6.Text = System.DateTime.Now.ToString("D");
//2007-4-24
this.TextBox7.Text = System.DateTime.Now.ToString("d");
//2007Äê4ÔÂ24ÈÕ 16:30:15
this. ......
±¨´íÐÅÏ¢ÈçÏ£º
¼ìË÷ COM À๤³§ÖÐ CLSID Ϊ {00024500-0000-0000-C000-000000000046} µÄ×é¼þʱʧ°Ü£¬ÔÒòÊdzöÏÖÒÔÏ´íÎó: 80070005¡£
ÍøÉÏÕÒÌù½â¾öÈçÏ£¬×ªÌù×÷¼Ç~~
ת×Ô£ºhttp://blog.csdn.net/happy_ddm/archive/2007/07/09/1683207.aspx
½â¾ö·½·¨£º
ÔÚDCOM×é¼þ·þÎñÖиøMICROSOFT.EXCEL×é¼þ¸³ÓèASP.NETµÄ²Ù×÷ȨÏÞ£¬ ......
¡¡¡¡
¡¡¡¡ÄÚÈݼò½é
¡¡¡¡±¾ÊéÊÇASP.NETµÄÈëÃŽ̡̳£ASP.NET 3.5ÊÇ΢Èí¾«ÐÄ´òÔìµÄÐÂÐ͵ÄÈí¼þ¿ª·¢Æ½Ì¨¡£¸Ãƽ̨ÊÇÔÚ.NET2.0µÄ»ù´¡ÉÏ·¢Õ¹¶øÀ´£¬ÔÚʵ¼Ê¿ª·¢ÖÐÓй㷺ӦÓᣱ¾ÊéÒ»¹²·ÖΪËÄÆª£¬µÚһƪÖ÷Òª½²½âÁËASP.NEµÄÈëÃÅ»ù´¡ÖªÊ¶£¬ÄÚÈݰüÀ¨´î½¨ASP.NET¿ª·¢»·¾³¡¢C#ÓïÑÔ»ù´¡¡¢ÃæÏò¶ÔÏóµÄ³ÌÐòÉè¼Æ¡¢ASP.NETÄÚÖöÔÏó¡¢ASP.NETҳà ......
using System;
using System.Collections.Generic;
using System.Text;
namespace ConsoleApplication2
{
class Program
{
static void Main(string[] args)
{
Console.WriteLine("/*\n------Êä³ö½á¹û------------");
getSplit("ABCDEFG"); ......
ÕâÊÇÎÒ´Ó±ð´¦Õª³µÄһƪÎÄÕ£¬ÏàÐÅ´ó¼Ò¶¼ºÜÊìϤµÄ£¬½²µÄºÜÃ÷°×£¬µ«ÊÇÎÒ¶ÔÆäÖÐÒ»µã´æÓÐÒÉ»ó£¬Ðí¾ÃҲûÓÐÕÒµ½´ð°¸¡£
µ÷ÓÃwebserviceʱ¿ÉÒÔ·µ»ØdatatableµÈ¸´ÔÓÊý¾ÝÀàÐÍ£¬ÏÂÃæÀý×ÓÖÐÒ²Óеģ¬ÔÚǰ̨µ÷ÓÃʱ£¬ÆäʵÕâЩÊý¾ÝÀàÐ;¹ýÁËת»»Æ÷´¦Àí¡£ÏÂÃæµÄÀý×ÓÖУ¬·µ»ØµÄdatatable±»Ò»ÏîÒ»ÏîÌí¼Óµ½selectÉÏÈ¥ÁË£¬ÆäʵÎÒ¿´Á˾ÍÊÇÒ»¸ö ......