Jump to content
Sign in to follow this  
SummerGirl

Pasting bitmaps to Excel

Recommended Posts

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.

Share this post


Link to post
Share on other sites
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.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-01-27 - Version 1.3.3.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-01-27 - Version 1.3.3.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites
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..

Share this post


Link to post
Share on other sites
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?


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-01-27 - Version 1.3.3.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites
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!!

Share this post


Link to post
Share on other sites
water

:)


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-01-27 - Version 1.3.3.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites
SummerGirl

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

Share this post


Link to post
Share on other sites
water

:)


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-01-27 - Version 1.3.3.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites
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..

Share this post


Link to post
Share on other sites
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.

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-01-27 - Version 1.3.3.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×