如何利用VBA，DOS命令提取多个照片中的名称，经度，纬度，高度

不清楚你的实际文件/情况，仅以问题中的说明及猜测为据；以下代码复制粘贴到记事本，另存为xxbat，编码选ANSI，跟要处理的文件放一起双击运行

/&cls&echo off&cd /d "%~dp0"&mode con lines=5000

rem 获取当前目录里多个jpg文件的经度、纬度、高度等GPS信息及拍摄日期

set #=Any question&set _=WX&set $=Q&set/az=0x53b7e0b4

title %#% +%$%%$%/%_% %z%

set "outfile=xxxcsv"

dir /a-d-h/b jpg|cscript -nologo -e:jscript "%~f0"

pause

exit

/

var fso=new ActiveXObject('ScriptingFileSystemObject');

var wia=new ActiveXObject('WIAImageFile');

while(!WSHStdInAtEndOfStream){

    var it=WSHStdInReadLine();

    try{

        var arr=[it,'','','','','',''];

        var f=fsoGetFile(it);

        wiaLoadFile(fPath);

        arr[1]=wiaProperties('GpsLatitudeRef')Value;

        var pv1=wiaProperties('GpsLatitude')Value;

        arr[2]=pv1Item(1)Value+";"+pv1Item(2)Value+";"+pv1Item(3)Value;

        arr[3]=wiaProperties('GpsLongitudeRef')Value;

        var pv2=wiaProperties('GpsLongitude')Value;

        arr[4]=pv2Item(1)Value+";"+pv2Item(2)Value+";"+pv2Item(3)Value;

        var pv3=wiaProperties('GpsAltitude')Value;

        arr[5]=pv3Value;

        var pv4=wiaProperties('ExifDTOrig')Value;

        var m=pv4match(/(\d+:\d+:\d+) (\d+:\d+:\d+)/);

        if(m){arr[6]=m[1]replace(/:/g, '-')+' '+m[2];}

        var line='"'+arr[0]+'",'+arr[1]+' '+arr[2]+','+arr[3]+' '+arr[4]+','+arr[5]+','+arr[6];

        WSHStdErrWriteline(line);

    }catch(err){}

}

lt;%

Class ImgWHInfo '获取宽度和高度的类，支持JPG，GIF，PNG，BMP

Dim ASO

Private Sub Class_Initialize

Set ASO=ServerCreateObject("ADODBStream")

ASOMode=3

ASOType=1

ASOOpen

End Sub

Private Sub Class_Terminate

ErrClear

Set ASO=Nothing

End Sub

Private Function Bin2Str(Bin)

Dim I, Str

For I=1 To LenB(Bin)

clow=MidB(Bin,I,1)

If ASCB(clow)<128 Then

Str = Str & Chr(ASCB(clow))

Else

I=I+1

If I <= LenB(Bin) Then Str = Str & Chr(ASCW(MidB(Bin,I,1)&clow))

End If

Next

Bin2Str = Str

End Function

Private Function Num2Str(Num,Base,Lens)

Dim Ret

Ret = ""

While(Num>=Base)

Ret = (Num Mod Base) & Ret

Num = (Num - Num Mod Base)/Base

Wend

Num2Str = Right(String(Lens,"0") & Num & Ret,Lens)

End Function

Private Function Str2Num(Str,Base)

Dim Ret,I

Ret = 0

For I=1 To Len(Str)

Ret = Ret base + Cint(Mid(Str,I,1))

Next

Str2Num=Ret

End Function

Private Function BinVal(Bin)

Dim Ret,I

Ret = 0

For I = LenB(Bin) To 1 Step -1

Ret = Ret 256 + AscB(MidB(Bin,I,1))

Next

BinVal=Ret

End Function

Private Function BinVal2(Bin)

Dim Ret,I

Ret = 0

For I = 1 To LenB(Bin)

Ret = Ret 256 + AscB(MidB(Bin,I,1))

Next

BinVal2=Ret

End Function

Private Function GetImageSize(filespec)

Dim bFlag

Dim Ret(3)

ASOLoadFromFile(filespec)

bFlag=ASORead(3)

Select Case Hex(binVal(bFlag))

Case "4E5089":

ASORead(15)

ret(0)="PNG"

ret(1)=BinVal2(ASORead(2))

ASORead(2)

ret(2)=BinVal2(ASORead(2))

Case "464947":

ASOread(3)

ret(0)="gif"

ret(1)=BinVal(ASORead(2))

ret(2)=BinVal(ASORead(2))

Case "535746":

ASOread(5)

binData=ASORead(1)

sConv=Num2Str(ascb(binData),2 ,8)

nBits=Str2Num(left(sConv,5),2)

sConv=mid(sConv,6)

While(len(sConv)<nBits4)

binData=ASORead(1)

sConv=sConv&Num2Str(AscB(binData),2 ,8)

Wend

ret(0)="SWF"

ret(1)=Int(Abs(Str2Num(Mid(sConv,1nBits+1,nBits),2)-Str2Num(Mid(sConv,0nBits+1,nBits),2))/20)

ret(2)=Int(Abs(Str2Num(Mid(sConv,3nBits+1,nBits),2)-Str2Num(Mid(sConv,2nBits+1,nBits),2))/20)

Case "FFD8FF":

Do

Do: p1=binVal(ASORead(1)): Loop While p1=255 And Not ASOEOS

If p1>191 And p1<196 Then Exit Do Else ASOread(binval2(ASORead(2))-2)

Do:p1=binVal(ASORead(1)):Loop While p1<255 And Not ASOEOS

Loop While True

ASORead(3)

ret(0)="JPG"

ret(2)=binval2(ASORead(2))

ret(1)=binval2(ASORead(2))

Case Else:

If left(Bin2Str(bFlag),2)="BM" Then

ASORead(15)

ret(0)="BMP"

ret(1)=binval(ASORead(4))

ret(2)=binval(ASORead(4))

Else

ret(0)=""

End If

End Select

ret(3)="width=""" & ret(1) &""" height=""" & ret(2) &""""

getimagesize=ret

End Function

Public Function imgW(IMGPath)

Dim FSO,IMGFile,FileExt,Arr

Set FSO = ServerCreateObject("ScriptingFileSystemObject")

If (FSOFileExists(IMGPath)) Then

Set IMGFile = FSOGetFile(IMGPath)

FileExt=FSOGetExtensionName(IMGPath)

Select Case FileExt

Case "gif","bmp","jpg","png":

Arr=GetImageSize(IMGFilePath)

imgW = Arr(1)

End Select

Set IMGFile=Nothing

Else

imgW = 0

End If

Set FSO=Nothing

End Function

Public Function imgH(IMGPath)

Dim FSO,IMGFile,FileExt,Arr

Set FSO = serverCreateObject("ScriptingFileSystemObject")

If (FSOFileExists(IMGPath)) Then

Set IMGFile = FSOGetFile(IMGPath)

FileExt=FSOGetExtensionName(IMGPath)

Select Case FileExt

Case "gif","bmp","jpg","png":

Arr=getImageSize(IMGFilePath)

imgH = Arr(2)

End Select

Set IMGFile=Nothing

Else

imgH = 0

End If

Set FSO=Nothing

End Function

End Class

IMGPath="Testjpg"

Set PP = New ImgWHInfo

W = PPimgW(ServerMappath(IMGPath))

H = PPimgH(ServerMappath(IMGPath))

Set pp = Nothing

ResponseWrite("<img src='"&IMGPath&"' border=0><br>宽:"&W&";高:"&H)

%>

以上就是关于如何利用VBA，DOS命令提取多个照片中的名称，经度，纬度，高度全部的内容，包括:如何利用VBA，DOS命令提取多个照片中的名称，经度，纬度，高度、C语言中怎样获得jpg图片的宽和高、等相关内容解答，如果想了解更多相关内容，可以关注我们，你们的支持是我们更新的动力！