1200字范文,内容丰富有趣,写作的好帮手!
1200字范文 > 如何用VBA代码来提取word中的图片 – CSS – 前端 iphone6屏幕高度css

如何用VBA代码来提取word中的图片 – CSS – 前端 iphone6屏幕高度css

时间:2020-02-08 01:21:39

相关推荐

如何用VBA代码来提取word中的图片 – CSS – 前端 iphone6屏幕高度css

使用Range.EnhMetaFileBits

来获取图片的EMF格式数组

然后用一系列API,转换成常规的jpg/png/gif/bmp格式

本方法不占用剪贴板

GDI+ 保存图片的函数改自这里:

/Imageshop/archive//03/02/2377871.html

略作调整如下:

‘*************************************************************************

‘** 作 者 : laviewpbt

‘** 函 数 名 : SavehBitmapToFile

‘** 输 入 : Stdpic(StdPicture) – 图象句柄

‘** : FileName(String) – 保存路径

‘** : FileFormat(ImageFileFormat) – 保存格式,默认jpg

‘** : JpgQuality(Long)– JPG图象质量

‘** : Resolution(Single) – 设置分辨率

‘** 输 出 : 无

‘** 功能描述 : 把图象保存为JPG、PNG、GIF、BMP格式

‘** 修 改 人 : laviewpbt

‘** 日 期 : -03-02 22:56

‘** 版 本 : 终结版

‘** 修 改 人 :loquat 0401

‘*************************************************************************

Option Explicit

Private Const UnitPixel As Long = 2

Private Const EncoderQuality As String = “{1D5BE4B5-FA4A-452D-9CDD-5DB35105E7EB}”

Private Type GdiplusStartupInput

GdiplusVersion As Long

DebugEventCallback As Long

SuppressBackgroundThread As Long

SuppressExternalCodecs As Long

End Type

Private Enum EncoderParameterValueType

EncoderParameterValueTypeByte = 1

EncoderParameterValueTypeASCII = 2

EncoderParameterValueTypeShort = 3

EncoderParameterValueTypeLong = 4

EncoderParameterValueTypeRational = 5

EncoderParameterValueTypeLongRange = 6

EncoderParameterValueTypeUndefined = 7

EncoderParameterValueTypeRationalRange = 8

End Enum

Private Type EncoderParameter

GUID(0 To 3) As Long

NumberOfValuesAs Long

typeAs EncoderParameterValueType

ValueAs Long

End Type

Private Type EncoderParameters

countAs Long

Parameter As EncoderParameter

End Type

Private Type ImageCodecInfo

ClassID(0 To 3)As Long

FormatID(0 To 3) As Long

CodecName As Long

DllName As Long

FormatDescription As Long

FilenameExtension As Long

MimeType As Long

FlagsAs Long

Version As Long

SigCount As Long

SigSize As Long

SigPatternAs Long

SigMask As Long

End Type

Private Declare Function GdiplusStartup Lib “gdiplus” (token As Long, inputbuf As GdiplusStartupInput, Optional ByVal outputbuf As Long = 0) As Long

Private Declare Sub GdiplusShutdown Lib “gdiplus” (ByVal token As Long)

Private Declare Function GdipSaveImageToFile Lib “gdiplus” (ByVal hImage As Long, ByVal sFilename As Long, clsidEncoder As Any, encoderParams As Any) As Long

Private Declare Function GdipDisposeImage Lib “gdiplus” (ByVal Image As Long) As Long

Private Declare Function GdipCreateBitmapFromHBITMAP Lib “gdiplus” (ByVal hbm As Long, ByVal hPal As Long, bitmap As Long) As GpStatus

Private Declare Function GdipGetImageEncodersSize Lib “gdiplus” (numEncoders As Long, Size As Long) As Long

Private Declare Function GdipGetImageEncoders Lib “gdiplus” (ByVal numEncoders As Long, ByVal Size As Long, Encoders As Any) As Long

Private Declare Sub CopyMemory Lib “kernel32” Alias “RtlMoveMemory” (Destination As Any, Source As Any, ByVal Length As Long)

Private Declare Function lstrlenW Lib “kernel32” (ByVal psString As Any) As Long

Private Declare Function CLSIDFromString Lib “ole32” (ByVal lpszProgID As Long, pclsid As Any) As Long

Private Declare Function GdipBitmapSetResolution Lib “gdiplus” (ByVal bitmap As Long, ByVal xdpi As Single, ByVal ydpi As Single) As Long

Public Enum GpStatus

Ok = 0

GenericError = 1

InvalidParameter = 2

OutOfMemory = 3

ObjectBusy = 4

InsufficientBuffer = 5

NotImplemented = 6

Win32Error = 7

WrongState = 8

Aborted = 9

FileNotFound = 10

ValueOverflow = 11

AccessDenied = 12

UnknownImageFormat = 13

FontFamilyNotFound = 14

FontStyleNotFound = 15

NotTrueTypeFont = 16

UnsupportedGdiplusVersion = 17

GdiplusNotInitialized = 18

PropertyNotFound = 19

PropertyNotSupported = 20

ProfileNotFound = 21

End Enum

Public Enum ImageFileFormat

bmp = 1

jpg = 2

png = 3

gif = 4

End Enum

Public Function SavehBitmapToFile(hBitmap As Long, ByVal FileName As String, _

Optional ByVal FileFormat As ImageFileFormat = jpg, _

Optional ByVal JpgQuality As Long = 80, _

Optional Resolution As Single) As Boolean

Dim CLSID(3) As Long

Dim bitmapAs Long

Dim token As Long

Dim Gsp As GdiplusStartupInput

Gsp.GdiplusVersion = 1 ‘GDI+ 1.0版本

GdiplusStartup token, Gsp ‘初始化GDI+

Debug.Print GdipCreateBitmapFromHBITMAP(hBitmap, 0, bitmap)

If bitmap <> 0 Then‘如果成功的将hBitmap句柄代表的stdPic对象转换为GDI+的Bitmap对象了

GdipBitmapSetResolution bitmap, Resolution, Resolution

Select Case FileFormat

Case ImageFileFormat.bmp

If Not GetEncoderCLSID(“Image/bmp”, CLSID) = -1 Then

SavehBitmapToFile = (GdipSaveImageToFile(bitmap, StrPtr(FileName), CLSID(0), ByVal 0) = 0)

End If

Case ImageFileFormat.jpg‘JPG格式可以设置保存的质量

Dim aEncParams() As Byte

Dim uEncParamsAs EncoderParameters

If GetEncoderCLSID(“Image/jpeg”, CLSID) <> -1 Then

uEncParams.count = 1‘ 设置自定义的编码参数,这里为1个参数

If JpgQuality < 0 Then

JpgQuality = 0

ElseIf JpgQuality > 100 Then

JpgQuality = 100

End If

ReDim aEncParams(1 To Len(uEncParams))

With uEncParams.Parameter

.NumberOfValues = 1

.type = EncoderParameterValueTypeLong ‘ 设置参数值的数据类型为长整型

Call CLSIDFromString(StrPtr(EncoderQuality), .GUID(0)) ‘ 设置参数唯一标志的GUID,这里为编码品质

.Value = VarPtr(JpgQuality) ‘ 设置参数的值:品质等级,最高为100,图像文件大小与品质成正比

End With

CopyMemory aEncParams(1), uEncParams, Len(uEncParams)

SavehBitmapToFile = (GdipSaveImageToFile(bitmap, StrPtr(FileName), CLSID(0), aEncParams(1)) = 0)

End If

Case ImageFileFormat.png

If Not GetEncoderCLSID(“Image/png”, CLSID) = -1 Then

SavehBitmapToFile = (GdipSaveImageToFile(bitmap, StrPtr(FileName), CLSID(0), ByVal 0) = 0)

End If

Case ImageFileFormat.gif

If Not GetEncoderCLSID(“Image/gif”, CLSID) = -1 Then‘如果原始的图像是24位,则这个函数会调用系统的调色板来将图像转换为8位,转换的效果会不尽人意,但也有可能系统不自动转换,保存失败

SavehBitmapToFile = (GdipSaveImageToFile(bitmap, StrPtr(FileName), CLSID(0), ByVal 0) = 0)

End If

End Select

End If

GdipDisposeImage bitmap‘注意释放资源

GdiplusShutdown token ‘关闭GDI+。

End Function

Private Function GetEncoderCLSID(strMimeType As String, ClassID() As Long) As Long

Dim num As Long

Dim Size As Long

Dim i As Long

Dim Info()As ImageCodecInfo

Dim Buffer() As Byte

GetEncoderCLSID = -1

GdipGetImageEncodersSize num, Size‘得到解码器数组的大小

If Size <> 0 Then

ReDim Info(1 To num) As ImageCodecInfo ‘给数组动态分配内存

ReDim Buffer(1 To Size) As Byte

GdipGetImageEncoders num, Size, Buffer(1) ‘得到数组和字符数据

CopyMemory Info(1), Buffer(1), (Len(Info(1)) * num)‘复制类头

For i = 1 To num ‘循环检测所有解码

If (StrComp(PtrToStrW(Info(i).MimeType), strMimeType, vbTextCompare) = 0) Then ‘必须把指针转换成可用的字符

CopyMemory ClassID(0), Info(i).ClassID(0), 16 ‘保存类的ID

GetEncoderCLSID = i‘返回成功的索引值

Exit For

End If

Next

End If

End Function

Private Function PtrToStrW(ByVal lpsz As Long) As String

Dim Out As String

Dim LengthAs Long

Length = lstrlenW(lpsz)

If Length > 0 Then

Out = StrConv(String$(Length, vbNullChar), vbUnicode)

CopyMemory ByVal Out, ByVal lpsz, Length * 2

PtrToStrW = StrConv(Out, vbFromUnicode)

End If

End Function

以下是偶封装的代码:

当然偶偷懒,没有使用GDI+,又选用了GDI,实际可以都用GDI+

Private Declare Function GetDC Lib “user32.dll” (ByVal hWnd As Long) As Long

Private Declare Function CreateCompatibleDC Lib “gdi32.dll” (ByVal hdc As Long) As Long

Private Declare Function CreateCompatibleBitmap Lib “gdi32.dll” (ByVal hdc As Long, ByVal nWidth As Long, ByVal nHeight As Long) As Long

Private Declare Function SelectObject Lib “gdi32.dll” (ByVal hdc As Long, ByVal hObject As Long) As Long

Private Declare Function SetEnhMetaFileBits& Lib “gdi32.dll” (ByVal DataLen&, pData As Any)

Private Declare Function PlayEnhMetaFile& Lib “gdi32” (ByVal hdc&, ByVal hEMF&, pRect As Any)

Private Declare Function DeleteEnhMetaFile& Lib “gdi32.dll” (ByVal hEMF As Long)

Private Declare Function DeleteObject Lib “gdi32.dll” (ByVal hObject As Long) As Long

Private Declare Function DeleteDC Lib “gdi32.dll” (ByVal hdc As Long) As Long

Private Declare Function ReleaseDC Lib “user32” (ByVal hWnd As Long, ByVal hdc As Long) As Long

Private Declare Function BitBlt Lib “gdi32” (ByVal hDestDC As Long, ByVal x As Long, ByVal y As Long, ByVal nWidth As Long, ByVal nHeight As Long, ByVal hSrcDC As Long, ByVal xSrc As Long, ByVal ySrc As Long, ByVal dwRop As Long) As Long

Private Declare Function FillRect Lib “user32.dll” (ByVal hdc As Long, ByRef lpRect As Any, ByVal hBrush As Long) As Long

Private Declare Function InvertRect Lib “user32.dll” (ByVal hdc As Long, ByRef lpRect As Any) As Long

Function ImageExtract(obj As Object, ByVal FileName As String, _

Optional ByVal FileFormat As ImageFileFormat = jpg, _

Optional ByVal JpgQuality As Long = 80, _

Optional Resolution As Single) As Boolean

Dim n! ‘放大倍数

Dim aRECT(0 To 3) As Long

Dim hScreenDC&

Dim hMemDC&

Dim hBitmap&, hBitTemp&

Dim arr() As Byte, hEMF&

n = 4

Select Case TypeName(obj) ‘获取图像数组

Case “InlineShape”

arr = obj.Range.EnhMetaFileBits

aRECT(2) = PointsToPixels(obj.Width, False) ‘宽度

aRECT(3) = PointsToPixels(obj.Height, True) ‘高度

Case “Shape”

arr = obj.Anchor.EnhMetaFileBits

aRECT(2) = PointsToPixels(obj.Width, False) ‘宽度

aRECT(3) = PointsToPixels(obj.Height, True) ‘高度

End Select

hEMF = SetEnhMetaFileBits(UBound(arr) + 1, arr(0))

hScreenDC = GetDC(0&)

hMemDC = CreateCompatibleDC(hScreenDC)

hBitmap = CreateCompatibleBitmap(hScreenDC, aRECT(2), aRECT(3))

hBitTemp = SelectObject(hMemDC, hBitmap)

InvertRect hMemDC, aRECT(0)

If hEMF Then

PlayEnhMetaFile hMemDC, hEMF, aRECT(0)

DeleteEnhMetaFile hEMF ‘销毁EMF

End If

hBitmap = SelectObject(hMemDC, hBitTemp)

ImageExtract = SavehBitmapToFile(hBitmap, FileName, FileFormat, JpgQuality, Resolution)

DeleteObject hBitmap

DeleteDC hMemDC

DeleteDC hScreenDC

End Function

调用示例:

Dim oInlineShape As InlineShapeDim oShape As ShapeSet oInlineShape = oDocument.InlineShapes(1)Set oShape = oDocument.Shapes(2)If ImageExtract(oInlineShape, “c:\1.jpg”,jpg, 100,600) thenmsgbox “保存成功”End IfIf ImageExtract(oShape, “c:\2.jpg”,jpg, 100,600) thenmsgbox “保存成功”End If

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。