ÔÚASP.NETÖжÁдExcelÎļþÓÐËÄÖÖ½â¾ö·½°¸¡£
ÔÚASP.NETÓ¦ÓóÌÐò³£³£»áÓöµ½ÐèÒª´ÓExcelÎļþÖжÁÈ¡Êý¾Ý»ò½«Êý¾ÝдÈëExcelµÄÐèÇó¡£Ò»°ãÀ´½²£¬ÔÚASP.NETÖжÁдExcelÎļþÓÐËÄÖÖ½â¾ö·½°¸¡£
1.1.1 ʹÓÃOLE DB
ʹÓÃOLE DB¿ÉÒÔÒÔ²éѯÊý¾Ý¿âµÄ·½Ê½À´¶ÁÈ¡ExcelÎļþ£¬ÒòΪÔÚijÖ̶ֳÈÉÏExcel±í¸ñ¿ÉÒÔ¿´³ÉÊÇÒ»ÕÅÒ»ÕŵÄÊý¾Ý±í¡£Æä¶þÕßµÄÖ÷񻂿±ðÔÚÓÚËùʹÓõÄÊý¾ÝÒýÇæ²»Ò»Ñù¡£Ê¹ÓÃOLE DB·ÃÎÊExcelµÄÒªµãÊǼÆËã»úÉϱØÐë¾ßÓÐMicrosoft Access Data Component 2.6(MADC2.6)ÒÔÉϰ汾£¬Í¬Ê±ÔÚÁ¬½Ó×Ö·û´®ÉϱØÐëÉùÃ÷“Extended Properties=Excel 8.0”£¬ÕâÀïµÄÖ¸¶¨Excel °æ±¾ºÅÈç¹û¸ßÓÚ8.0¿ÉÄÜ»á³ö´í£¬ËùÒÔÒ»°ãÀ´½²±ØÐëʹÓÃExcel 8.0¡£
È»ºóÆäËüµÄд·¨¾ÍºÍÒ»°ãµÄ·ÃÎÊÊý¾Ý¿âÒ»ÑùÁË£¬´ò¿ªÁ¬½Ó£¬Ìî³äÊý¾Ý¼¯£¬ÔٹرÕÁ¬½Ó¼´¿É¡£ÀýÈçÏÂÃæµÄʵÏÖ´úÂ룺
//´´½¨Ò»¸öÊý¾ÝÁ´½Ó
string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = c:\\sample.xls;Extended Properties=Excel 8.0" ;
OleDbConnection myConn = new OleDbConnection ( strCon ) ;
string strCom = " SELECT * from [Sheet1$] " ;
myConn.Open ( ) ;
//´ò¿ªÊý¾ÝÁ´½Ó£¬µÃµ½Ò»¸öÊý¾Ý¼¯
OleDbDataAdapter myCommand = new OleDbDataAdapter ( strCom , myConn ) ;
//´´½¨Ò»¸ö DataSet¶ÔÏó
myDataSet = new DataSet ( ) ;
//µÃµ½×Ô¼ºµÄDataSet¶ÔÏó
myCommand.Fill ( myDataSet , "[Sheet1$]" ) ;
//¹Ø±Õ´ËÊý¾ÝÁ´½Ó
myConn.Close ( ) ;
´úÂë 7-1
ʹÓÃÕâÖÖ½â¾ö·½°¸µÄÓŵãÊDz»ÐèÒªÆäËûµÄ·þÎñÆ÷×é¼þ£¬²¿Êð·Ç³£·½±ã£¬µ«ÊÇÆäȱµãÒ²ÊÇÃ÷ÏԵģ¬ÓÃËüÀ´¶ÁÈ¡Excel 2003¸ñʽÒÔÉϵÄÎļþ»á´æÔÚÊý¾Ý¶ªÊ§µÄÇé¿ö£¬¶øÇÒÒ²ÎÞ·¨Éú³ÉExcelÎļþ¡£
1.1.2 ʹÓÃOfficeÖ÷»¥²Ù×÷³ÌÐò¼¯
ÁíÍâÒ»ÖÖ½â¾ö·½°¸ÊÇʹÓÃOfficeÖ÷»¥²Ù×÷³ÌÐò¼¯£¬²ÉÓÃÕâÖÖ·½Ê½ÐèÒªÔÚ·þÎñÆ÷Éϰ²×°Office 2003¡£µ«ÊÇÄܹ»±È½Ï¾«Ï¸µÄ¿ØÖÆExcelÎļþµÄ·½·½ÃæÃ棬°üÀ¨¸ñʽ¡¢×ÖÌå¡¢ÑÕÉ«µÈµÈ¡£
ÏÂÃæµÄ´úÂëÑÝʾÁËÈçºÎ¶ÁÈ¡ExcelÎļþÖÐij¸öµ¥Ôª¸ñµÄÖµ£º
string excelFilePath=@"D:\Book1.xls";
Excel.Application myExcel=new Excel.ApplicationClass( ) ;
object oMissing = System.Reflection.Missing.Value ;
myExcel.Application.Workbooks.Open(excelFilePath,oMissing,oMissing,oMissing,oMissing,oMissing, oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oM
Ïà¹ØÎĵµ£º
c#£¨»òvb.net£©³ÌÐò¸Ä½ø
1¡¢Ê¹ÓÃÖµÀàÐ͵ÄToString·½·¨
¡¡¡¡ÔÚÁ¬½Ó×Ö·û´®Ê±£¬¾³£Ê¹ÓÃ"+"ºÅÖ±½Ó½«Êý×ÖÌí¼Óµ½×Ö·û´®ÖС£ÕâÖÖ·½·¨ËäÈ»¼òµ¥£¬Ò²¿ÉÒԵõ½ÕýÈ·½á¹û£¬µ«ÊÇÓÉÓÚÉæ¼°µ½²»Í¬µÄÊý¾ÝÀàÐÍ£¬Êý×ÖÐèҪͨ¹ý×°Ïä²Ù×÷ת»¯ÎªÒýÓÃÀàÐͲſÉÒÔÌí¼Óµ½×Ö·û´®ÖС£µ«ÊÇ×°Ïä²Ù×÷¶ÔÐÔÄÜÓ°Ïì½Ï´ó£¬ÒòΪÔÚ½øÐÐÕâÀà´¦Àíʱ£¬½«ÔÚÍйܶÑÖÐ ......
ÕâÀïÎÒÃǽ«½éÉÜASP.NET»º´æµÄ¹¤×÷ÔÀí£¬°üÀ¨¼òµ¥µÄ¶¨Ò壬Êý¾Ý»º´æÒÔ¼°»º´æµÄÉèÖõȵÈÄÚÈÝ¡£Ï£Íû±¾ÎÄÄܶԴó¼Ò½ñºóµÄ¹¤×÷ÓÐËù°ïÖú¡£
ÈçºÎ±ÜÃâASP.NET»º´æÕ¼ÓÃϵͳ×ÊÔ´
ÔÙ̸ASP.NET»º´æ»úÖÆ£º¿ª·¢Ð§ÂÊÓëÓÅ»¯µÄ..
ASP.NET»º´æ»úÖÆ»ù´¡¸ÅÄî
ASP.NET»º´æÊý¾ÝÌí¼Ó·½·¨Ò»ÀÀ
ASP.NET»º´æÊý¾Ý¼¼ÇÉÈýÔò
½éÉÜ
»º´æÊÇÔÚÄÚ´æ´ ......
¿ª·¢Æ½Ì¨£º
WinXP SP3+IIS5.1+IE7+Visual Studio 2005+Visual Studio 6.0+ MS SOAP Toolkit 3.0
Ò»£®´´½¨ASP.NET WebService
Visual Studio 2005àÎļþàн¨àÍøÕ¾àASP.NET Web·þÎñÏîÄ¿WebServiceDemo¡£
ÒÔÏÂΪService.cs´úÂëÇåµ¥£º
// WebService.cs
using System;
using System ......
ASP.NET 2.0·þÎñÆ÷¿Ø¼þ¿ª·¢----¿Ø¼þÉúÃüÖÜÆÚ
·þÎñÆ÷¿Ø¼þÉúÃüÖÜÆÚ¼ò½é
¡¡¡¡·þÎñÆ÷¿Ø¼þµÄÉúÃüÖÜÆÚÊÇ´´½¨·þÎñÆ÷¿Ø¼þ×îÖØÒªµÄ¸ÅÄî¡£×÷Ϊ¿ª·¢ÈËÔ±£¬±ØÐë¶Ô·þÎñÆ÷¿Ø¼þÉúÃüÖÜÆÚÉî¿ÌÀí½â¡£µ±È»£¬Õâ²»ÊÇÒ»³¯Ò»Ï¦¾Í¿ÉÒÔ×öµ½µÄ¡£¶ÔÓÚѧϰ¿Ø¼þ¿ª·¢¼¼ÊõµÄ³õѧÕߣ¬¿ÉÒÔ²»±ØÕÆÎյ÷dz£ÏêϸÉîÈ룬ֻÐè¶Ô·þÎñÆ÷¿Ø¼þµÄÉúÃüÖÜÆÚÖеIJ»Í¬ ......