A reader Kevin emailed me about the use of
OneCellAnchor class. This is for coding using Excel Open XML format. The relevant article is about image insertion in Excel. Here’s his comment:
I’ve been using the OneCellAnchor and find it perfect: position by row/column and size by image extent in EMU and best of all, the image will not resize when column widths are set.
If you’re having trouble with figuring out the
TwoCellAnchor class properties, you might want to check out
OneCellAnchor class instead. Might be easier to work with.
Thanks, Kevin, for that information.
There’s updated material and source code, together with more information on how to work with Open XML. Click here to find out more.