excel 利用VBA能够做到读取同一个文件夹下所有图片尺寸

2025-03-03 06:17:18

推荐回答（3个）

回答1：

 Sub test()
filepath = ThisWorkbook.Path & "\"
picfile = Dir(filepath & "*.jpg") '读jpg格式文件
i = 2
Do While picfile <> ""
    ActiveSheet.Pictures.Insert(filepath & picfile).Select
    h = Selection.ShapeRange.Height / 28.346
    w = Selection.ShapeRange.Width / 28.346
    Selection.Delete
    Cells(i, 1) = picfile
    Cells(i, 2) = h
    Cells(i, 3) = w
    picfile = Dir
    i = i + 1
Loop
End Sub

回答2：

Public Function GetImageSize(sFileName As String, Optional getWidth As Boolean = True) As Long
On Error Resume Next
Dim iFN As Integer
Dim bTemp(3) As Byte
Dim lFlen As Long
Dim lPos As Long
Dim bHmsb As Byte
Dim bHlsb As Byte
Dim bWmsb As Byte
Dim bWlsb As Byte
Dim bBuf(7) As Byte
Dim bDone As Byte
Dim iCount As Integer

Dim gisWidth As Long
Dim gisHeight As Long

lFlen = FileLen(sFileName)
iFN = FreeFile
Open sFileName For Binary As iFN
Get #iFN, 1, bTemp()
'PNG 文件
If bTemp(0) = &H89 And bTemp(1) = &H50 And bTemp(2) = &H4E _
And bTemp(3) = &H47 Then
Get #iFN, 19, bWmsb
Get #iFN, 20, bWlsb
Get #iFN, 23, bHmsb
Get #iFN, 24, bHlsb
gisWidth = CombineBytes(bWlsb, bWmsb)
gisHeight = CombineBytes(bHlsb, bHmsb)
End If
'GIF 文件
If bTemp(0) = &H47 And bTemp(1) = &H49 And bTemp(2) = &H46 _
And bTemp(3) = &H38 Then
Get #iFN, 7, bWlsb
Get #iFN, 8, bWmsb
Get #iFN, 9, bHlsb
Get #iFN, 10, bHmsb
gisWidth = CombineBytes(bWlsb, bWmsb)
gisHeight = CombineBytes(bHlsb, bHmsb)
End If
'JPEG 文件
If bTemp(0) = &HFF And bTemp(1) = &HD8 And bTemp(2) = &HFF Then
Debug.Print "JPEG "
lPos = 3
Do
Do
Get #iFN, lPos, bBuf(1)
Get #iFN, lPos + 1, bBuf(2)
lPos = lPos + 1
Loop Until (bBuf(1) = &HFF And bBuf(2) <> &HFF) Or lPos > lFlen
For iCount = 0 To 7
Get #iFN, lPos + iCount, bBuf(iCount)
Next iCount
If bBuf(0) >= &HC0 And bBuf(0) <= &HC3 Then
bHmsb = bBuf(4)
bHlsb = bBuf(5)
bWmsb = bBuf(6)
bWlsb = bBuf(7)
bDone = 1
Else
lPos = lPos + (CombineBytes(bBuf(2), bBuf(1))) + 1
End If
Loop While lPos < lFlen And bDone = 0
gisWidth = CombineBytes(bWlsb, bWmsb)
gisHeight = CombineBytes(bHlsb, bHmsb)
End If
'BMP 文件
If bTemp(0) = &H42 And bTemp(1) = &H4D Then
Get #iFN, 19, bWlsb
Get #iFN, 20, bWmsb
Get #iFN, 23, bHlsb
Get #iFN, 24, bHmsb
gisWidth = CombineBytes(bWlsb, bWmsb)
gisHeight = CombineBytes(bHlsb, bHmsb)
End If
Close iFN
GetImageSize = gisWidth
If Not getWidth Then GetImageSize = gisHeight

End Function
Private Function CombineBytes(lsb As Byte, msb As Byte) As Long
CombineBytes = CLng(lsb + (msb * 256)) '把十六进制数换成十进制
End Function

回答3：

即然文件名都可以咋搞的，那图片长宽的话就分别用fil.height和fil.width

请专家授课需要提供增值税发票吗

我不能哭不能哭是哪一部电视剧的歌？？？

智能手机蓝牙传输都存在信息里，从电脑上看在哪个文件夹里？

用:、姹紫嫣红、莞尔一笑、应接不暇、耐人寻味这些词写一段话 100字快啊急用!!

男方是上门女婿,但婚后女方把房产证的名字改为了男方的名字,问现在男方提出离婚那现在这房子应该怎么分配

为什么有些歌不能拖到iPod里？

升值与贬值有什么区别，汇率是怎么回事？

一米八三体重九十公斤,征兵会要吗

梦见一只大老虎,变成一只小老虎,最后变成一只小狗,被我打跑了是啥意思.?