There is one missing part: specification of the mapping between EMF and the spreadsheet. Where is it?
Everything else is solvable. You can access metafile using the class
System.Drawing.Imaging.Metafile, Programming Excel is accessible through Microsoft Office toolkit:
http://msdn.microsoft.com/en-us/library/d2tx7z6d.aspx[
^].
A metafile is a collection of vector graphical primitives. They are stored in the meta-file in some sequence — the order in which these objects were drawn on a metafile. The list is polymorphous; it contains primitives of several different types. One relevant type of objects are strings. Those strings can be extracted from the metafile and placed in the spreadsheet cells. Alternatively/additionally, some meta-data and/or numerical data on each object can be presented as some spreadsheet type data and placed in the cells using certain mapping rules. That's it. I don't think anything else may make any sense. (And frankly, writing those objects on the spreadsheet hardly can make any sense. Maybe I'm missing something :-))
Now, define the mapping between the metafile objects and the spreadsheet and — get to work!
(Honestly, who needs this, ever?)
—SA
Submit an article or tip