Page 1 of 1

Export swf to MS Excel

Posted: Mon Oct 18, 2010 9:12 pm
by S_henry
Hi guys, I need your help. In my system, I have 2 sections of reports. 1 is table report, another 1 is chart report shown in swf format. For table report, I can export to word/excel without problem. Can anybody help me on how to export my chart report in swf format to word/excel?
Thank you.

Re: Export swf to MS Excel

Posted: Mon Oct 18, 2010 10:14 pm
by requinix
You can't use Excel to make the chart?

Re: Export swf to MS Excel

Posted: Mon Oct 18, 2010 10:30 pm
by S_henry
Currently I'm using flash/swf to view chart with some effects. But when comes to exporting that chart to excel, i've no idea on how to do it. Maybe it's a good idea to make that chart in excel when exporting. Can you give me an idea on how to make chart in excel?
Thanks.

Re: Export swf to MS Excel

Posted: Mon Oct 18, 2010 10:41 pm
by requinix
Making a chart in Excel is totally beyond the scope of this forum. Whole site, even.

Google is your friend. So is the F1 key.

Re: Export swf to MS Excel

Posted: Tue Oct 19, 2010 2:19 am
by greyhoundcode
tasairis wrote:Making a chart in Excel is totally beyond the scope of this forum. Whole site, even.
Totally agree. I'm certainly not an Excel expert, or even a regular user really, but for what it's worth my initial approach would be to record a macro whereby I create a graph from the data within an Excel workbook. I'd then inspect the VBA code that makes up the macro and go from there ...

Might be worth taking a look at C Sharp Corner, particularly if you are targeting recent editions of MS Office. I'm sure you'll get more complete help there.

Re: Export swf to MS Excel

Posted: Tue Oct 19, 2010 4:49 am
by requinix
It occurs to me that I might have misunderstood a bit. You want to create the spreadsheet from scratch and then insert a chart into it? Ah. Not what I was thinking.

It'll probably be easier for you to use data imports in Excel. You create the spreadsheet yourself and have it pull down data from some source: could be CSV output from a PHP script, could be tied directly to a database. Stick the chart in yourself and tweak it as you wish.
Just refresh the data whenever you want to see current numbers.