用PB6.5如何在原有的Excel文件中追加记录或填写数据呀?急,急,急!!!!!
大家用PB6.5做过原有的Excel文件中追加记录或填写数据吗?如果有的话,请大家帮帮忙啦,
我参照帮忙的例子,写出不行,程序可以运行,但是Excel文件打开来什么也看不见啦,什么也没有显示,大家帮帮忙看看是怎么回事。谢谢。
integer result
OLEObject myoleobject
myoleobject = CREATE OLEObject
result = myoleobject.ConnectToObject( &"c:\excel\expense.xls")
IF result = 0 THEN
myoleobject.application.workbooks(1).&
worksheets(1).cells(1,1).value = 14
myoleobject.application.workbooks(1).save()
myoleobject.DisConnectObject()
END IF
DESTROY myoleobject