字典和數(shù)組的區(qū)別 ExcelVBA求助,如何把字典轉(zhuǎn)換成數(shù)組存出來?
ExcelVBA求助,如何把字典轉(zhuǎn)換成數(shù)組存出來?將字典D放入A列:B:[A1]。尺寸(d.count)=應(yīng)用程序。轉(zhuǎn)置(d.keys)[b1]。調(diào)整大小(d.Count)=應(yīng)用程序。轉(zhuǎn)置(d.ite
ExcelVBA求助,如何把字典轉(zhuǎn)換成數(shù)組存出來?
將字典D放入A列:B:[A1]。尺寸(d.count)=應(yīng)用程序。轉(zhuǎn)置(d.keys)[b1]。調(diào)整大?。╠.Count)=應(yīng)用程序。轉(zhuǎn)置(d.items)d.keys是一個數(shù)組,d.items是一個數(shù)組,并將數(shù)組轉(zhuǎn)換為a:B列如果dictionary對象變量是d,數(shù)組變量是arr,則可以將d的鍵分配給arrarr=d.keys或arr=d.keys()