thanks heiner55, the function "width_and_height_calculator_in_pixel" works but, there is an issue.. I'm not sure but probably the width and height values are wrong. see the picture:
[Image: 18d5eb1235200004.jpg]
Excel does not agree with the script result. the script gave me "102" for the "text width", but not Excel! for him the size is bigger. how is it possibile? then I have another question. to set the "width column" in Excel I have to specify a width in inch. following an exaple:
[Image: 18d5eb1235200004.jpg]
Excel does not agree with the script result. the script gave me "102" for the "text width", but not Excel! for him the size is bigger. how is it possibile? then I have another question. to set the "width column" in Excel I have to specify a width in inch. following an exaple:
# set the first colum width in 11" (inch): worksheet.set_column(0, 1, 11)so, it's better to have the "text width" in inch and not in pixel. how can I reach my goal?