Can I generate the excel chart with out opening the excel instance?

[ramkumar_cpt]

Hi Friends,

I have one doubt in excel chart. Can i generate the excel chart with out opening the excel instance?

I mean in my server system there is no ms office excel. We cannot install it in server. because some license, security problem. I have to create a excel chart dynamically. After user can download it from their client system. So Can i generate the excel chart with out opening the excel instance?

And excel instance has concurrent issue. At same time two more instance is not running.

Pls give valuable solution.

Thanks
Ram kumar.

[Tushar Mehta]

I imagine you can do this with a 2 part solution though it is not perfect.

Create a workbook with just sample data. This is data that you will
eventually create from your server system. Save this file as a XML file.

Create a new workbook. Create a chart in this workbook that uses the data
in the XML workbook as the source. Save this file as a regular workbook.

Put both on your server. Your code can update the XML file with the
appropriate data. To see what XL puts in the XML file, just open it with a
text editor like NotePad.

Send both the XML and the XLS file to the clent.

All this works very well. Now, comes the one clumsy bit. Since the data
source is in a XML file, XL will not update the chart unless you open the
XML file. But, other than that, everything works just fine.

I implemented the above slightly differently for a system developed last
year. The ASP based code creates the XML workbook on the server. The
client downloads it to the local machine. There, the customer uses an add-
in that I provide. This add-in has the templates for all the analysis and
charts associated with the system. So, the client opens the downloaded XML
workbook and selects this one particular menu item. It adds the necessary
worksheets, formulas, charts, chartsheets, named formulas, etc., to the XML
workbook and when ready displays a dialog box asking the user to save the
file as a regular workbook.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>,
[email protected] says...
>
> Hi Friends,
>
> I have one doubt in excel chart. Can i generate the excel
> chart with out opening the excel instance?
>
> I mean in my server system there is no ms office excel. We cannot
> install it in server. because some license, security problem. I have to
> create a excel chart dynamically. After user can download it from their
> client system. So Can i generate the excel chart with out opening the
> excel instance?
>
> And excel instance has concurrent issue. At same time two more
> instance is not running.
>
> Pls give valuable solution.
>
> Thanks
> Ram kumar.
>
>
> --
> ramkumar_cpt
> ------------------------------------------------------------------------
> ramkumar_cpt's Profile: http://www.excelforum.com/member.php...o&userid=28673
> View this thread: http://www.excelforum.com/showthread...hreadid=517688
>
>