国产一级a片免费看高清,亚洲熟女中文字幕在线视频,黄三级高清在线播放,免费黄色视频在线看

以前發(fā)在EHblog的老博文，現在關閉了，準備陸陸續(xù)續(xù)搬遷一點過來。時間久了，有些文章也不一定保值了。

 ————————————————————————————————————————————

以下原文發(fā)表于2010-3-17 

前日在網上閑逛時湊巧看到一個名為ExcelArt的軟件介紹（http://www.cnbeta.com/articles/105787.htm），此軟件可以將圖片轉換為Excel單元格圖像，在Excel單元格中畫圖變得不再那么復雜，可以輕松按鍵搞定。去下載了試用了一下，非注冊版有諸多限制，而且轉換還以失敗告終。去他們的主頁看了一下，專業(yè)版竟然售價10歐元，企業(yè)版50歐元！
看來還是自己動手做一個比較方便！
用VBA制作的思路其實很簡單，應該已經有先人實踐過，只是沒有見過成熟產品，所以發(fā)上來和大家一起分享一下。

附件如下：請使用2007以上版本打開。

http://vdisk.weibo.com/s/3Wdeh 

上述附件中的程序假定分辨率為96DPI，如需適用于其他的分辨率條件下，可以使用下面的附件程序，其中的坐標轉換部分代碼參考Winland大俠的代碼。

http://vdisk.weibo.com/s/3Wdla 

主要部分代碼如下：

'以下代碼位于用戶窗體UesrForm1之中：
     '撰寫:chrisfang
     '網址:http://Club.ExcelHome.net
     '日期:2010-3-16 17:29:39
Private Declare Function GetPixel Lib "gdi32" (ByVal hDC As Long ,ByVal x As Long , ByVal y As Long ) As Long
Private Declare Function FindWindow Lib "user32" Alias"FindWindowA" (ByVal lpClassName As String , ByVal lpWindowName AsString ) As Long
Private Declare Function GetWindowDC Lib "user32" (ByVal hwnd AsLong ) As Long
Public maxx, maxy
--------------------------------------------------------------------------------
Private Sub CommandButton1_Click()
Dim hwnd, hDC As Long
If maxx = 0 Then
MsgBox "請先選擇尺寸規(guī)格！"
Exit Sub
End If
    hwnd =FindWindow(vbNullString, Me.Caption)
    hDC =GetWindowDC(hwnd)
   ThisWorkbook.Sheets(1).Range("A1:OJ300").Interior.Color = -1
    winx =(Me.Width - Me.InsideWidth) / 2
    winy =Me.Height - Me.InsideHeight - winx
    mx = (winx +Me.Image1.Left) * 4 / 3
    my = (winy +Me.Image1.Top) * 4 / 3
      'Application.ScreenUpdating = False
    For x = 1 Tomaxx
       For y = 1 To maxy
           iColor = GetPixel(hDC, mx + x * 4 / 3, my + y * 4 / 3)
           ThisWorkbook.Sheets(1).Cells(y, x).Interior.Color = iColor
       Next y
    Next x
   'Application.ScreenUpdating = True
    MsgBox"繪制完成！"
End Sub
--------------------------------------------------------------------------------
Private Sub CommandButton2_Click()
    filestoOpen= Application.GetOpenFilename _
                 (FileFilter:="Microsoft Image Files (*.jpg;*.jpeg; *.bmp),*.jpg;*.jpeg; *.bmp", _
                  MultiSelect:=False, Title:="選擇圖片文件")
    IfTypeName(filestoOpen) = "Boolean" Then
       MsgBox "沒有選擇文件"
       GoTo ExitHandler
    Else
       Me.Image1.Picture = LoadPicture(filestoOpen)
    End If
ExitHandler:
End Sub
--------------------------------------------------------------------------------
Private Sub OptionButton1_Click()
    IfMe.OptionButton1.Value = True Then
       maxx = 200
       maxy = 150
       Call disparea(maxx, maxy)
    End If
End Sub
--------------------------------------------------------------------------------
Private Sub OptionButton2_Click()
    IfMe.OptionButton2.Value = True Then
       maxx = 300
       maxy = 225
       Call disparea(maxx, maxy)
    End If
End Sub
--------------------------------------------------------------------------------
Private Sub OptionButton3_Click()
    IfMe.OptionButton3.Value = True Then
       maxx = 400
       maxy = 300
       Call disparea(maxx, maxy)
    End If
End Sub
--------------------------------------------------------------------------------
Private Sub disparea(ByVal maxx As Integer , ByVal maxy As Integer)
   Application.ScreenUpdating = False
    Range(Cells(1, 1), Cells(1, maxx)).ColumnWidth = 0.54
    Range(Cells(1, 1), Cells(maxy, 1)).RowHeight = 5
    Range(Cells(1, 1), Cells(1, maxx)).EntireColumn.Hidden = False
    Range(Cells(1, 1), Cells(maxy, 1)).EntireRow.Hidden = False
    Range(Cells(1, maxx + 1), Cells(1, 16384)).EntireColumn.Hidden =True
    Range(Cells(maxy + 1, 1), Cells(1048576, 1)).EntireRow.Hidden =True
   Me.Image1.Left = Me.Image1.Left + (Me.Image1.Width - maxx) /2
   Me.Image1.Top = Me.Image1.Top + (Me.Image1.Height - maxy) / 2
   Me.Image1.Width = maxx
   Me.Image1.Height = maxy
   Application.ScreenUpdating = True
End Sub