瑞鲁手机APP下载网_专注推荐好用的手机APP和游戏APP

ASP操作Excel技术总结 ASP

ASP之对象总结

查看人次:0摘自:手机游戏APP网

如果你使用过大部分,那么你的ASP功力应该是非常高的了

ADO对象(太常用了):ConnectionCommandRecordSetRecordStream

ASP支持的对象太多了,你可以自己写COM组件,下面是我们经常使用的:Server.CreateObject("Scripting.FileSystemObject")Server.CreateObject("Scripting.Dictionary")  HashTableServer.CreateXObject("Word.Application")   //ServerActiveXObject("Word.Application")   //ClientServer.CreateObject("Excel.Application")  //ServerActiveXObject("Excel.Application")   //ClientCreateObject("PowerPoint.Application")Server.CreateObject("Microsoft.XMLHTTP")Server.CreateObject("Microsoft.XMLDOM")Server.CreateObject("MSXML2.XMLHTTP.4.0")Server.CreateObject("WScript.Shell")Server.CreateObject("wscript.network") //网络地址的Server.CreateObject("MSWC.AdRotator")CreateObject("Excel.Sheet")MS FrontPage: oFP = CreateObject("FrontPage.Application")MS Access: oAccess = CreateObject("Access.Application")MS Graph: oGraph = CreateObject("MSGraph.Application")

下面是我们应该知道的:

CreateObject("PhotoShop.Application")

//关于SQL Server的CreateObject("SQLDMO.SQLServer")CreateObject("SQLDMO.Login")CreateObject("SQLDMO.Backup")CreateObject("SQLDMO.User")Server.CreateObject("SQLDMO.BackupDevice")Server.CreateObject("SQLDMO.Database")Server.CreateObject("SQLDMO.Restore")具体的例子请看下面的连接http://www.asp101.com/articles/carvin/sqldmobackup/default.asp

//MSMQ的Server.CreateObject("MSMQ.MSMQQueueInfo")CreateObject("MSMQ.MSMQQuery")//全文索引的Server.CreateObject("ixsso.Query")Server.CreateObject("ixsso.Util")邮件发送的组件我没有总结,请热心的朋友总结出来:CDO,Jmail,Imail等。

下面一些是不太常见的对象:AccPac Advantage Corporate: oAccPac=CreateObject("ACCPAC.xapiSession")

AccPac Report Master for Windows: oImpApp=CreateObject("Impromptu.Application.30")

BarTender: oBarTender = CreateObject("BarTender.Application")

CrystalReports: oCRApplication = createobject ("CrystalRuntime.Application") This doesn't invoke an IDE actually.

EUDORA: oEud = CreateObject("Eudora.EuApplication.1")

FaxMaker: oFax = CREATEOBJECT("fmfaxapi.application")

GroupWise:oGroupWise = CreateObject("NovellGroupWareSession")

LotusNotes: oNotes = CreateObject("Notes.NotesSession")oNotes = CreateObject("Notes.NotesUIWorkspace")oNotes = CreateObject("Lotus.Notessession") (Domino 5.0.3)

MS Common Dialog: oCommmonDialog = CreateObject("MSComDlg.CommonDialog") && !!! You can't directly create this object without a development licence, so for dynamically doing it on another machine, see below. -- PeterCrabtree

MS Internet Explorer: oIE = CreateObject("InternetExplorer.Application") IEAutomationExample

MS MapPoint:oMapPoint = CreateObject("MapPoint.Application")

MSN Messenger:oMessenger = CREATEOBJECT("MSNMessenger.MessengerApp")

MS NetMeeting:oNetMeeting=CREATEOBJECT("netmeeting.app.1")

MS Outlook: oOutlook = CreateObject("Outlook.Application")

MS Outlook Express: None - It is not a COM server!

MS PowerPoint: oPP = CreateObject("PowerPoint.Application")

MS Project: oProj = CreateObject("msProject.Application")

MS SourceSafe: oVSS = CreateObject("SourceSafe.0")

MS Word: oWord = CreateObject("Word.Application")

MS Visio: oVisio = CreateObject("Visio.Application")

MS VisualBasic: 不知道,网站也没有登记出来。

MS VisualCPlusPlus: (VC++)oCpp = CreateObject("MSDev.Application")

MS VisualFoxpro: oVFP = CreateObject("VisualFoxPro.Application")

MS WindowsScriptingHost: oWSH = CreateObject("WScript.Shell")

Novell GroupWise: oGroupWise = CreateObject("NovellGroupWareSession")

PCAnywhere (host): oPCAHost = CreateObject("WinAWSvr.BeHostDataManager")

PCAnywhere (remote): oPCARem = CreateObject("WinAWSvr.RemoteDataManager")

QuickBooks: QBSessionManager = CreateObject("QBFC2.QBSessionManager")

RationalRose: oRose = CreateObject("Rose.Application")

TAPIFax: oTAPIFax = CreateObject('FaxServer.FaxServer')

WindowsShell: oWSH = CreateObject("Shell.Application")

Windows Media Player:

oWMP = CREATEOBJECT("WMPlayer.OCX")oPlayList = oWmp.PlaylistCollection.GetAll()oWmp.currentPlaylist = oPlayList.Item(0) && Zero based array*!* Music starts!

Windows Messenger: oMessenger = CREATEOBJECT("Messenger.MessengerApp")

WinFax: oWinFax = CreateObject("WinFax.SDKSend")

WinPrint : oWinPrint = CreateObject("WinPrint.WinPrintX")

SQL-DMO object: loSQL = CREATEOBJECT("SQLDMO.Application")

Others:

Scripting Shell: oShell = CreateObject("WScript.Shell")

Scripting Network Object: oNet = CreateObject("WScript.Network")

Scripting Regular Expression Parser: oReg = CreateObject("VBScript.RegExp")

SQL DMO SQL Server: CreateObject("SQLDMO.SQLServer")

相关文摘:ASP教程 windows
标题名称:《ASP操作Excel技术总结 ASP》
本文网址:https://www.sdruilu.cn/news/tpart-30146.html