Questions about Excel Object Model

5 Jul 2006 4:02 AM

Tim

I have been digging through MSDN and this group for solutions, but
I'm just left with questions.

Can I use the object model to create a XLS file from scratch on a
machine that doesn't have Excel installed on it?
Right now my solution is just creating an XML file formatted so excel
can read it however I have to add a chart to one of the workbooks and I
don't believe I can accomplish that through XLM. If anyone has a link
to an example of this it'd be appreciated.

Thanks,
Tim

5 Jul 2006 4:50 PM

Paul Clement

On 4 Jul 2006 21:02:03 -0700, "Tim" <omegaspec***@earthlink.net> wrote:

¤ I have been digging through MSDN and this group for solutions, but
¤ I'm just left with questions.
¤
¤ Can I use the object model to create a XLS file from scratch on a
¤ machine that doesn't have Excel installed on it?
¤ Right now my solution is just creating an XML file formatted so excel
¤ can read it however I have to add a chart to one of the workbooks and I
¤ don't believe I can accomplish that through XLM. If anyone has a link
¤ to an example of this it'd be appreciated.

You can create an Excel Workbook (with one or more Worksheets) using the ADOX (Microsoft ADO Ext 2.x
for DDL and Security) library. However, there is no way that I am aware of to create any charts w/o
using automation with Excel.

Paul
~~~~
Microsoft MVP (Visual Basic)