尝试去连接一个Decimal值

吴_359007 2021-7-16 1363

尝试去连接一个Decimal值  这个报错是哪里有问题,如何解决   求教!!

Dim dRets = ""
Dim dRet = ""
Dim bRet = ""
Dim dTime = ""
Dim iRets = ""
Dim ddsj = ""
Dim cfsJ = ""
Dim arrayRet = ""
Dim temp = ""
Dim sRet = ""
Dim iRet = ""
Dim objExcelWorkBook = ""
objExcelWorkBook = Excel.OpenExcel('''C:\Users''',True,"Excel","","")
iRet = Excel.GetRowsCount(objExcelWorkBook,"Sheet1")
TracePrint(iRet)
Do While True
    
    sRet = Dialog.InputBox("请输入需要预定的航班序号","航班信息预定","",False)
    iRets = CInt(sRet)
    If iRets=0
        
        iRet = Dialog.MsgBox("您序号输入有误,请重新输入","UiBot","0","1",0)
        Continue
    Else
        
        If iRets<iRet
            
            temp = iRets-1
            TracePrint(temp)
            arrayRet = Excel.ReadRow(objExcelWorkBook,"Sheet1","A"&temp)
            TracePrint(arrayRet)
            dRet = CNumber(arrayRet[2])
            cfsj = Time.Format(dRet,"hh:mm:ss")
            dRets = CNumber(arrayRet[3])
            ddsj = Time.Format(dRets,"hh:mm:ss")
            iRet = Dialog.MsgBox("您预定的航班号为"&arrayRet[1]&"出发时间为"&cfsj&"到达时间为"&ddsj&"价格为"&arrayRet[4],"UiBot","0","1",0)
            Break
        Else
            iRet = Dialog.MsgBox("您序号输入有误,请重新输入","UiBot","0","1",0)

_尝试去连接一个Decimal值

最新回复 (6)
  • 果子哩 2021-7-16
    2
    拼接的值有问题,可以先输出看一下
  • 祖咏 2021-7-29
    3
    arrayData[4]  的数据类型是decimal,读取行在读取的数据出来,数字好像都会隐式转换成decimal,你到达时间不判断下吗,有些抓取的时间有+1天。这好像是以前的考题,现在换远程桌面换题了。
  • 我的天 2021-7-30
    4
    sRet = CStr(varData)
    试试把arrayData[4]  转化成字符,再拼接呢
  • zxh_501552 2021-9-30
    5
    处理了吗??我也遇到同样得问题了
  • rainvale 2021-10-6
    6
    cint转化下整数
  • 郑_487806 2021-10-26
    7
    用  
    基本命令里面的

                转为整数数据
    或者
                转文为文字数据
返回
发新帖