Export swf to MS Excel

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
S_henry
Forum Contributor
Posts: 148
Joined: Sun Jan 25, 2004 10:25 pm
Location: M'sia

Export swf to MS Excel

Post 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.
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: Export swf to MS Excel

Post by requinix »

You can't use Excel to make the chart?
S_henry
Forum Contributor
Posts: 148
Joined: Sun Jan 25, 2004 10:25 pm
Location: M'sia

Re: Export swf to MS Excel

Post 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.
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: Export swf to MS Excel

Post 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.
User avatar
greyhoundcode
Forum Regular
Posts: 613
Joined: Mon Feb 11, 2008 4:22 am

Re: Export swf to MS Excel

Post 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.
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: Export swf to MS Excel

Post 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.
Post Reply