PoshCode Archive  Artifact Content

Artifact ea2cd97cd5dbd6888b2f7d2b362f38c119c329a87ce40630e7d2417a4fb0a28a:

  • File image2excel.ps1 — part of check-in [e587c2ffb2] at 2018-06-10 13:35:23 on branch trunk — Just for fun script for converting image files to excel. Very slow, try 50×50 images first (user: AxCoder size: 1374)

# encoding: ascii
# api: powershell
# title: image2excel
# description: Just for fun script for converting image files to excel. Very slow,  try 50×50 images first
# version: 2.5
# type: script
# author: AxCoder
# license: CC0
# x-poshcode-id: 4047
# x-archived: 2013-03-30T05:09:28
# x-published: 2013-03-27T12:32:00
#
#
<#
    .Description
    image2excel converts image to excel file
#>
param (
    [parameter(Mandatory=$true,
               ValueFromPipeline=$true,
               HelpMessage="Image file path"               
               )]
    [ValidateScript({Test-Path $_})]
    [String]
    $filename
)
[System.Reflection.Assembly]::LoadWithPartialName("System.Drawing") | Out-Null
function color2excel($color)
{
    $color.R * 256*256 + $color.G * 256 + $color.B
}
$image = New-Object System.Drawing.Bitmap $filename
$o = New-Object -ComObject Excel.Application

$wb = $o.Workbooks.Add()
$sh = $wb.ActiveSheet
$sh.Cells.ColumnWidth =0.25;
$sh.Cells.RowHeight = 2.5;
$o.Visible = $true
$total = $image.Width * $image.Height
foreach($x in 0..($image.Width-1))
{
    foreach($y in 0..($image.Height-1))
    {
        Write-Progress "Exporting..." "$x,$y" -PercentComplete  ((($x * $image.Height + $y) / $total ) * 100)
        $sh.Cells.Item($y+1, $x+1).Interior.Color = color2excel($image.GetPixel($x, $y))
    }
}