I want to open a xlsx file as template and fill it with values, then save as a result file, but some style missing. the temp file: the result file:
- the cell's width and height is changed
- the merged cell 's border's style is changed, just the left-top cell has border.
- How can I got the cell's width, height then reshape the image fit. the column_dimensions/row_dimensions return None.
- I can add image to a cell coordinate, if there are some way to insert it with offset (margin) or give a (x,y) anchor?
at last I want to insert a image from numpy (not from file), so I use a BytesIO as buffer, which works in v 2.5.3, but not work in the latest version. what is the right usage?