Pasting bitmaps to Excel

[SummerGirl]

Dear all,

        I need to check multiple bitmaps outputted by the system,

whether they are same as the original.

Now I have all the bitmaps saved in a local folder(Original & system generated image..

I want them(Original & system saved png files) to be pasted to Excel side by side

so that I can manually check whether they are same.

Since I have about 100 bitmaps want them to be automated...

Kindly let me know whether the same could be done in Auto IT.

If any sample scripts could be provided, would be thankful.

Thanks in advance.

[water]

You could use my Rewrite of the Excel UDF.

It has a function to add a picture to a worksheet (_Excel_PictureAdd).

Check the example script _Excel_PictureAdd.au3 to see how it works.

[SummerGirl]

Thanks for the quick response.

Sorry...being a newbie...please let me know that I should

download the ExcelEx and include...and try the function...

When I tried to unzip but could not read the same as it was garbled..

Check the example script _Excel_PictureAdd.au3..
Please let me know where I can check this.

[water]

The download (link can be found in my siganture) is a simple ZIP file.

You extract everything into a single directory and run the example script _Excel_PictureAdd.au3.

If it doesn't work can you please post any error message and the size of the file?

BTW: This scripts need to be run with on eof the beta versions of AutoIt > 3.3.9.2

[SummerGirl]

I downloaded from the below link and on extracting
the file created was Excel Rewrite Beta 2 (No extension)
The file size is 518KB

and when I rename as au3...its garbled...
Am I wrong some where?

Kindly let me know..

[water]

Looks like the extracted file is still a ZIP archive (I take it from the size).

Can you please rename this file to "Excel Rewrite Beta 2.zip" and try to extract it again?

[SummerGirl]

Yes..On renaming to zip and re-extracting I can find the  _Excel_PictureAdd.au3
Will try and update you tomorrow!!
Thanks for your help!!

[water]

[SummerGirl]

Thanks a lot and I am able to copy the bitmaps with your example.

[water]

[SummerGirl]

Thanks a lot and it works with my file.

Well have a few clarifications:
1.Can you explain about it or let me where I can find details about it.
   #AutoIt3Wrapper_AU3Check_Stop_OnWarning=Y
   #AutoIt3Wrapper_AU3Check_Parameters=-d -w 1 -w 2 -w 3 -w 4 -w 5 -w 6

2. If I need to add some text(comment) to the Excel in between copying the bitmaps

    is there any way?
    Example: Test 1 Result
                    Copy bitmap
                    Test 2 Result
                     Copy bitmap..

[water]

Sure. I will do my very best

1. This are directives for the AutoIt Wrapper. Details can be found in the help fille. In Scite click: Help -> SciTE Help. On the Content tab click: Extra utilities -> AutoItWrapper
2. If you want to write some text to a cell use function _Excel_RangeWrite. _Excel_RangeWrite.au3 gives you a few examples. Calculating the cell where to write the text might be a bit complex.