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.