VBA Macro to get the narrowest width of the non-transparent area of PNG image in the X direction and Y direction
$10-30 USD
Completed
Posted almost 3 years ago
$10-30 USD
Paid on delivery
VBA Macro to get the narrowest width of the non-transparent area of PNG image in the X direction and Y direction
If the PNG image (which is listed in the Excel File) has transparent areas, then calculate the percent of the transparent areas and record it back to the excel file.
percent of the transparent areas = total transparent areas / canvas size of the PNG image
Example for the percent of the transparent areas:
The Canvas Size of a PNG image is 1000 * 1000 pixels, and it has one 100 * 100 pixels transparent area and one 200 * 200 pixels transparent area, then the percent of the transparent areas is:
(100 * 100 + 200 * 200) / (1000 * 1000) = 50,000 / 1,000,000 = 5%
If the PNG image (which is listed in the Excel File) has transparent areas , then get the narrowest width(Pixels) of the non-transparent area of PNG image in the X direction and Y direction(see the screenshot [login to view URL], B should be the narrowest width in the X direction, and A should be the narrowest width in the Y direction), and record the data back to the excel file.
If the PNG image (which is listed in the Excel File) has no transparent area, then skip it.
We will release the money to you after we test the macro with about 1,000 images within 5 days and the Macro meet all the requirements.
The code should not be encrypted, so that we can modify the code ourselves.
Hi,
Kindly, I work on many projects like your request, I can send to you many samples of my work in Excel chart, Formulas, Pivot table, and VBA codes.
Please let me have a chance to show you my experiences.
Please, don't hesitate to call me any time.
Hi, I am happy to bid on your project.
I wanna carry out your project.
I have full experience with **** VBA, Image Process ****
==========================================================
I can carry out your project on time with high quality guarantee.
If you don't like my results, you don't have to pay.
I hope to discuss more in detail.
Best regards. From Jackson.
Hi, I've read your description carefully.
I have more than 11 years experience with VB/VBA/Image Processing.
*************************************************************************************
I'm confident in your project with high quality on time.
Looking forward to discuss with you project more detail via chatting.
I'm very happy to put my bid on your project.
Thanks & Best regards!