2,722
社区成员
发帖
与我相关
我的任务
分享
Local oExcel
oExcel=Createobject("Excel.Application")
oExcel.WorkBooks.Open(“abc.xls")
oExcel.Activesheet.Evaluate( "{=MIN( IF( a1:a10 = 5, Row( a1:a10)))}" )
oExcel = CREATEOBJECT( 'excel.application')
oExcel.WorkBooks.Open( 'D:\Documents\Visual FoxPro 项目\测试\分类.xls')
oSheet = oExcel.ActiveSheet
lcString = "{=MAX( if( l2:l387 = " + ["房地产业"] + " , row( l2:l387)))}"
nResult = oSheet.Evaluate( lcString )