python openpyxl 사진 추가 하기 소수자리 반올림 방법

 

'''
Created on 2017. 9. 11.

@author: bsyim
'''

import openpyxl
from openpyxl import load_workbook
from openpyxl import Workbook
from openpyxl.drawing.image import Image

if __name__ == '__main__':
    pass

openpyxl_version = openpyxl.__version__
print(openpyxl_version)  #to see what version I'm running

 

#change to the location and name of your image

# 사진은 알아서  구하기
img_name = r'ee.png'

# test.xlsx already exists in my current directory

wb = openpyxl.Workbook()
ws = wb.worksheets[0]

# 사진 크기를 조정하려면  inch 로 계산하여야 한다.

# 소수값을 정수로 변환 한다.  ( round ( 소수값, 자리수)

#여기서는  1 pixcel =  1/100  inch 값이다.

''' unit 1 pixcel is  1/100 inch'''
unit_cm=10
unit_inch= round((unit_cm/2.54)*10,0)#  change to float
unit_inch= round((unit_cm/2.54)*100)  #  change to integer
print (unit_inch)

my_image = openpyxl.drawing.image.Image(img_name)
my_image.drawing.width= unit_inch
my_image.drawing.height = unit_inch

ws.add_image(my_image, 'B3')

my_image = openpyxl.drawing.image.Image(img_name)
ws.add_image(my_image, 'B50')

wb.save('Add_Picture.xlsx')