I have a batch program that creates an Excel spreadsheet with multiple worksheets. I need to extract a copy of a diagram into a worksheet. This obviously works with Word documents generation but I have no idea how this might work with Excel. Any help/advice gratefully received.
What do you mean by extract a MEGA diagram to Excel
A diagram is a complex information:
Excel export wizard in primarily designed to export objects with string and text properties.
If the property _drawing can be fully exported, you can consider to use Excel export but this will be very delicated.
Besides, the diagram drawing will not be displated as in HOPEX: it would be a long binary string.
We meet again! Thank you for the interest in my issue.
Basically, I have a VB batch program that creates an Excel Workbook with different sheets for Data Model information. I have bee asked to display the MEGA diagram as an image in one of the sheets. I have a work around in that our web site generation builds pages showing the diagrams. The generation process creates image s in the Images folder. I'm using "ExcelSheet.Shapes.AddPicture" passing the image file name. This seems to work but is not quite what I was wanting. I was hoping there was a "GetImage" method!
There is a method saveasimage for a diagram if I remember correctly. That is what I would do and then import it in the excel document
Hey! That sounds just the job. Any idea where I may find an example? I cannot see any reference in the API manual.....
Hi. Apologies as didn't see your alternative. I'll investigate that method also.