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