Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
ramkumar_cpt
 
Posts: n/a
Default Can I generate the excel chart with out opening the excel instance?


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

  #2   Report Post  
Posted to microsoft.public.excel.charting
Tushar Mehta
 
Posts: n/a
Default Can I generate the excel chart with out opening the excel instance?

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 ,
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Copy and paste Excel chart in Word -- font compresses ScooterGirl Charts and Charting in Excel 3 February 10th 06 04:25 AM
Setting Excel chart series from vb6 Jim Charts and Charting in Excel 7 January 27th 06 10:41 AM
Keep Excel from opening new instance widman Excel Discussion (Misc queries) 7 October 1st 05 01:53 AM
Opening two separate instances of Excel Ron Bishop Excel Discussion (Misc queries) 2 August 4th 05 05:30 PM


All times are GMT +1. The time now is 08:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"