| 网站首页 | 业界新闻 | 小组 | 威客 | 人才 | 下载频道 | 博客 | 代码贴 | 在线编程 | 编程论坛
欢迎加入我们,一同切磋技术
用户名:   
 
密 码:  
共有 502 人关注过本帖
标题:vb中如何将datagrid和mschart的图表以电子文档的形式保存下来
只看楼主 加入收藏
gumengyin
Rank: 1
等 级:新手上路
帖 子:21
专家分:7
注 册:2014-3-19
结帖率:66.67%
收藏
 问题点数:0 回复次数:3 
vb中如何将datagrid和mschart的图表以电子文档的形式保存下来
vb中如何将datagrid和mschart的图表以电子文档的形式保存下来
搜索更多相关主题的帖子: 电子 如何 
2014-03-21 17:33
psu366
Rank: 2
等 级:论坛游民
帖 子:8
专家分:18
注 册:2013-11-25
收藏
得分:0 
    Picture2.AutoRedraw = True
    Picture1.AutoRedraw = True
   
     Picture2.Refresh
     Picture1.Refresh
     
    Picture2.AutoRedraw = True
    Picture1.AutoRedraw = True
   
    Picture1.Picture = Picture1.Image
   
    Picture2.Picture = Picture1.Picture
   
    Picture2.PaintPicture CaptureWindow(Picture1.hwnd, False, 0, 0, _
     Picture1.ScaleX(Picture1.Width, vbTwips, vbPixels), _
     Picture1.ScaleY(Picture1.Height, vbTwips, vbPixels)), 0, 0
     
     Picture2.Refresh
     Picture1.Refresh
     
    SavePicture Picture2.Image, "c:\test.bmp"
  把mschart放在picture1上
2014-05-20 06:18
psu366
Rank: 2
等 级:论坛游民
帖 子:8
专家分:18
注 册:2013-11-25
收藏
得分:0 
对了,另加一个模块
 Private Type PALETTEENTRY
     peRed As Byte
     peGreen As Byte
     peBlue As Byte
     peFlags As Byte
    End Type
     
    Private Type LOGPALETTE
     palVersion As Integer
     palNumEntries As Integer
     palPalEntry(255) As PALETTEENTRY ' Enough for 256 colors.
    End Type
     
    Private Type GUID
     Data1 As Long
     Data2 As Integer
     Data3 As Integer
     Data4(7) As Byte
    End Type
     
    #If Win32 Then
     
     Private Const RASTERCAPS As Long = 38
     Private Const RC_PALETTE As Long = &H100
     Private Const SIZEPALETTE As Long = 104
     
     Private Type RECT
     Left As Long
     Top As Long
     Right As Long
     Bottom As Long
     End Type
     
     Private Declare Function CreateCompatibleDC Lib "gdi32" ( _
     ByVal hDC As Long) As Long
     Private Declare Function CreateCompatibleBitmap Lib "gdi32" ( _
     ByVal hDC As Long, ByVal nWidth As Long, _
     ByVal nHeight As Long) As Long
     Private Declare Function GetDeviceCaps Lib "gdi32" ( _
     ByVal hDC As Long, ByVal iCapabilitiy As Long) As Long
     Private Declare Function GetSystemPaletteEntries Lib "gdi32" ( _
     ByVal hDC As Long, ByVal wStartIndex As Long, _
     ByVal wNumEntries As Long, lpPaletteEntries As PALETTEENTRY) _
     As Long
     Private Declare Function CreatePalette Lib "gdi32" ( _
     lpLogPalette As LOGPALETTE) As Long
     Private Declare Function SelectObject Lib "gdi32" ( _
     ByVal hDC As Long, ByVal hObject As Long) As Long
     Private Declare Function BitBlt Lib "gdi32" ( _
     ByVal hDCDest As Long, ByVal XDest As Long, _
     ByVal YDest As Long, ByVal nWidth As Long, _
     ByVal nHeight As Long, ByVal hDCSrc As Long, _
     ByVal xSrc As Long, ByVal ySrc As Long, ByVal dwRop As Long) _
     As Long
     Private Declare Function DeleteDC Lib "gdi32" ( _
     ByVal hDC As Long) As Long
     Private Declare Function GetForegroundWindow Lib "USER32" () _
     As Long
     Private Declare Function SelectPalette Lib "gdi32" ( _
     ByVal hDC As Long, ByVal hPalette As Long, _
     ByVal bForceBackground As Long) As Long
     Private Declare Function RealizePalette Lib "gdi32" ( _
     ByVal hDC As Long) As Long
     Private Declare Function GetWindowDC Lib "USER32" ( _
     ByVal hwnd As Long) As Long
     Private Declare Function GetDC Lib "USER32" ( _
     ByVal hwnd As Long) As Long
     Private Declare Function GetWindowRect Lib "USER32" ( _
     ByVal hwnd As Long, lpRect As RECT) As Long
     Private Declare Function ReleaseDC Lib "USER32" ( _
     ByVal hwnd As Long, ByVal hDC As Long) As Long
     Private Declare Function GetDesktopWindow Lib "USER32" () As Long
     
     Private Type PicBmp
     Size As Long
     Type As Long
     hBmp As Long
     hPal As Long
     Reserved As Long
     End Type
     
     Private Declare Function OleCreatePictureIndirect _
     Lib "olepro32.dll" (PicDesc As PicBmp, RefIID As GUID, _
     ByVal fPictureOwnsHandle As Long, IPic As IPicture) As Long
     
    #ElseIf Win16 Then
     
     Private Const RASTERCAPS As Integer = 38
     Private Const RC_PALETTE As Integer = &H100
     Private Const SIZEPALETTE As Integer = 104
     
     Private Type RECT
     Left As Integer
     Top As Integer
     Right As Integer
     Bottom As Integer
     End Type
     
     Private Declare Function CreateCompatibleDC Lib "GDI" ( _
     ByVal hDC As Integer) As Integer
     Private Declare Function CreateCompatibleBitmap Lib "GDI" ( _
     ByVal hDC As Integer, ByVal nWidth As Integer, _
     ByVal nHeight As Integer) As Integer
     Private Declare Function GetDeviceCaps Lib "GDI" ( _
     ByVal hDC As Integer, ByVal iCapabilitiy As Integer) As Integer
     Private Declare Function GetSystemPaletteEntries Lib "GDI" ( _
     ByVal hDC As Integer, ByVal wStartIndex As Integer, _
     ByVal wNumEntries As Integer, _
     lpPaletteEntries As PALETTEENTRY) As Integer
     Private Declare Function CreatePalette Lib "GDI" ( _
     lpLogPalette As LOGPALETTE) As Integer
     Private Declare Function SelectObject Lib "GDI" ( _
     ByVal hDC As Integer, ByVal hObject As Integer) As Integer
     Private Declare Function BitBlt Lib "GDI" ( _
     ByVal hDCDest As Integer, ByVal XDest As Integer, _
     ByVal YDest As Integer, ByVal nWidth As Integer, _
     ByVal nHeight As Integer, ByVal hDCSrc As Integer, _
     ByVal xSrc As Integer, ByVal ySrc As Integer, _
     ByVal dwRop As Long) As Integer
     Private Declare Function DeleteDC Lib "GDI" ( _
     ByVal hDC As Integer) As Integer
     Private Declare Function GetForegroundWindow Lib "USER" _
     Alias "GetActiveWindow" () As Integer
     Private Declare Function SelectPalette Lib "USER" ( _
     ByVal hDC As Integer, ByVal hPalette As Integer, ByVal _
     bForceBackground As Integer) As Integer
     Private Declare Function RealizePalette Lib "USER" ( _
     ByVal hDC As Integer) As Integer
     Private Declare Function GetWindowDC Lib "USER" ( _
     ByVal hwnd As Integer) As Integer
     Private Declare Function GetDC Lib "USER" ( _
     ByVal hwnd As Integer) As Integer
     Private Declare Function GetWindowRect Lib "USER" ( _
     ByVal hwnd As Integer, lpRect As RECT) As Integer
     Private Declare Function ReleaseDC Lib "USER" ( _
     ByVal hwnd As Integer, ByVal hDC As Integer) As Integer
     Private Declare Function GetDesktopWindow Lib "USER" () As Integer
     
     Private Type PicBmp
     Size As Integer
     Type As Integer
     hBmp As Integer
     hPal As Integer
     Reserved As Integer
     End Type
     
     Private Declare Function OleCreatePictureIndirect _
     Lib "oc25.dll" (PictDesc As PicBmp, RefIID As GUID, _
     ByVal fPictureOwnsHandle As Integer, IPic As IPicture) _
     As Integer
    #End If
    #If Win32 Then
     Public Function CaptureWindow(ByVal hWndSrc As Long, _
     ByVal Client As Boolean, ByVal LeftSrc As Long, _
     ByVal TopSrc As Long, ByVal WidthSrc As Long, _
     ByVal HeightSrc As Long) As Picture
     
     Dim hDCMemory As Long
     Dim hBmp As Long
     Dim hBmpPrev As Long
     Dim r As Long
     Dim hDCSrc As Long
     Dim hPal As Long
     Dim hPalPrev As Long
     Dim RasterCapsScrn As Long
     Dim HasPaletteScrn As Long
     Dim PaletteSizeScrn As Long
    #ElseIf Win16 Then
     Public Function CaptureWindow(ByVal hWndSrc As Integer, _
     ByVal Client As Boolean, ByVal LeftSrc As Integer, _
     ByVal TopSrc As Integer, ByVal WidthSrc As Long, _
     ByVal HeightSrc As Long) As Picture
     
     Dim hDCMemory As Integer
     Dim hBmp As Integer
     Dim hBmpPrev As Integer
     Dim r As Integer
     Dim hDCSrc As Integer
     Dim hPal As Integer
     Dim hPalPrev As Integer
     Dim RasterCapsScrn As Integer
     Dim HasPaletteScrn As Integer
     Dim PaletteSizeScrn As Integer
    #End If
     Dim LogPal As LOGPALETTE
     
     ' Depending on the value of Client get the proper device context.
     If Client Then
     hDCSrc = GetDC(hWndSrc) ' Get device context for client area.
     Else
     hDCSrc = GetWindowDC(hWndSrc) ' Get device context for entire
     ' window.
     End If
     
     ' Create a memory device context for the copy process.
     hDCMemory = CreateCompatibleDC(hDCSrc)
     ' Create a bitmap and place it in the memory DC.
     hBmp = CreateCompatibleBitmap(hDCSrc, WidthSrc, HeightSrc)
     hBmpPrev = SelectObject(hDCMemory, hBmp)
     
     ' Get screen properties.
     RasterCapsScrn = GetDeviceCaps(hDCSrc, RASTERCAPS) ' Raster
     ' capabilities.
     HasPaletteScrn = RasterCapsScrn And RC_PALETTE ' Palette
     ' support.
     PaletteSizeScrn = GetDeviceCaps(hDCSrc, SIZEPALETTE) ' Size of
     ' palette.
     
     ' If the screen has a palette make a copy and realize it.
     If HasPaletteScrn And (PaletteSizeScrn = 256) Then
     ' Create a copy of the system palette.
     LogPal.palVersion = &H300
     LogPal.palNumEntries = 256
     r = GetSystemPaletteEntries(hDCSrc, 0, 256, _
     LogPal.palPalEntry(0))
     hPal = CreatePalette(LogPal)
     ' Select the new palette into the memory DC and realize it.
     hPalPrev = SelectPalette(hDCMemory, hPal, 0)
     r = RealizePalette(hDCMemory)
     End If
     
     ' Copy the on-screen image into the memory DC.
     r = BitBlt(hDCMemory, 0, 0, WidthSrc, HeightSrc, hDCSrc, _
     LeftSrc, TopSrc, vbSrcCopy)
     
    ' Remove the new copy of the on-screen image.
     hBmp = SelectObject(hDCMemory, hBmpPrev)
     
     ' If the screen has a palette get back the palette that was
     ' selected in previously.
     If HasPaletteScrn And (PaletteSizeScrn = 256) Then
     hPal = SelectPalette(hDCMemory, hPalPrev, 0)
     End If
     
     ' Release the device context resources back to the system.
     r = DeleteDC(hDCMemory)
     r = ReleaseDC(hWndSrc, hDCSrc)
     
     ' Call CreateBitmapPicture to create a picture object from the
     ' bitmap and palette handles. Then return the resulting picture
     ' object.
     Set CaptureWindow = CreateBitmapPicture(hBmp, hPal)
    End Function
     
    #If Win32 Then
     Public Function CreateBitmapPicture(ByVal hBmp As Long, _
     ByVal hPal As Long) As Picture
     
     Dim r As Long
    #ElseIf Win16 Then
     Public Function CreateBitmapPicture(ByVal hBmp As Integer, _
     ByVal hPal As Integer) As Picture
     
     Dim r As Integer
    #End If
     Dim Pic As PicBmp
     ' IPicture requires a reference to "Standard OLE Types."
     Dim IPic As IPicture
     Dim IID_IDispatch As GUID
     
     ' Fill in with IDispatch Interface ID.
     With IID_IDispatch
     .Data1 = &H20400
     .Data4(0) = &HC0
     .Data4(7) = &H46
     End With
     
     ' Fill Pic with necessary parts.
     With Pic
     .Size = Len(Pic) ' Length of structure.
     .Type = vbPicTypeBitmap ' Type of Picture (bitmap).
     .hBmp = hBmp ' Handle to bitmap.
     .hPal = hPal ' Handle to palette (may be null).
     End With
     
     ' Create Picture object.
     r = OleCreatePictureIndirect(Pic, IID_IDispatch, 1, IPic)
     
     ' Return the new Picture object.
     Set CreateBitmapPicture = IPic
    End Function

2014-05-20 06:19
lowxiong
Rank: 12Rank: 12Rank: 12
等 级:贵宾
威 望:27
帖 子:652
专家分:3402
注 册:2008-5-7
收藏
得分:0 
二楼答非所问,文不对题。没具体看CaptureWindow功能,大致不过是返回一个picture对象而已,和datagrid、mschart、excel八竿子打不着。
混分贴,鉴定完毕!
2014-05-20 07:37
快速回复:vb中如何将datagrid和mschart的图表以电子文档的形式保存下来
数据加载中...
 
   



关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.012250 second(s), 7 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved