Quantcast

Embedding external excel file in flex app

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Embedding external excel file in flex app

megharajdeepak
Hi,
We have a requirement where in we need to display a flex app within ppt.
Basically, swf will be embedded within ppt file. However, the data for the
app is read from an excel file, which again is embedded within flex app.

The excel file data gets refreshed every week. I get the data file, which I
need to embed in app and then release the app(swf) to ppt team.

I wanted to know if there is any way to embed excel file externally, so
that ppt team donot have dependency on me to build swf with every excel
change.

Kindly let me know if you have any ideas on how can this be done.

-Deepak
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Embedding external excel file in flex app

Alex Harui
Does the SWF also fetch data off the internet/LAN or is all data
embedded/local?  You might try the -use-network flag.

-Alex

On 4/19/17, 10:43 PM, "Deepak MS" <[hidden email]> wrote:

>Hi,
>We have a requirement where in we need to display a flex app within ppt.
>Basically, swf will be embedded within ppt file. However, the data for the
>app is read from an excel file, which again is embedded within flex app.
>
>The excel file data gets refreshed every week. I get the data file, which
>I
>need to embed in app and then release the app(swf) to ppt team.
>
>I wanted to know if there is any way to embed excel file externally, so
>that ppt team donot have dependency on me to build swf with every excel
>change.
>
>Kindly let me know if you have any ideas on how can this be done.
>
>-Deepak

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Embedding external excel file in flex app

clintm
In reply to this post by megharajdeepak
"I wanted to know if there is any way to embed excel file externally, so
that ppt team do not have dependency on me to build swf with every excel
change."

What you mean to ask is can you load the excel file from disk from the swf
inside of powerpoint.
The answer is yes _but_ the end user of the powerpoint preso needs to grant
privileges on their machine via the Flash Security Settings to the
powerpoint file.
https://linuxforlovers.wordpress.com/2009/04/17/powerpointflash-interaction/

You can also do this programatically via the FlashPlayerTrust
http://help.adobe.com/en_US/ActionScript/3.0_ProgrammingAS3/WS5b3ccc516d4fbf351e63e3d118a9b90204-7c95.html#WS357943C4-11D4-4b2a-ADAD-3B485BF39CBF

I don't think relative paths would work in this local-trusted situation so
you'd have to pass the absolute file system path to the swf when it is
embeded in the powerpoint file via flashvars.
https://www.youtube.com/watch?v=BLSJ6a4Djd0

Also… depending on your powerpoint version… you might need to set the
flashvars via vba because they might not get saved when the powerpoint file
is closed and reopened.
http://stackoverflow.com/questions/7089619/setting-value-to-flashvars-property-doesnt-work


On Wed, Apr 19, 2017 at 10:43 PM, Deepak MS <[hidden email]>
wrote:

> Hi,
> We have a requirement where in we need to display a flex app within ppt.
> Basically, swf will be embedded within ppt file. However, the data for the
> app is read from an excel file, which again is embedded within flex app.
>
> The excel file data gets refreshed every week. I get the data file, which I
> need to embed in app and then release the app(swf) to ppt team.
>
> I wanted to know if there is any way to embed excel file externally, so
> that ppt team donot have dependency on me to build swf with every excel
> change.
>
> Kindly let me know if you have any ideas on how can this be done.
>
> -Deepak
>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Embedding external excel file in flex app

Dave Fisher
Hi,

You can update a PowerPoint from an Excel file all in Java using Apache POI. See http://poi.apache.org/

Regards,
Dave

Sent from my iPhone

> On Apr 20, 2017, at 9:02 AM, Clint M <[hidden email]> wrote:
>
> "I wanted to know if there is any way to embed excel file externally, so
> that ppt team do not have dependency on me to build swf with every excel
> change."
>
> What you mean to ask is can you load the excel file from disk from the swf
> inside of powerpoint.
> The answer is yes _but_ the end user of the powerpoint preso needs to grant
> privileges on their machine via the Flash Security Settings to the
> powerpoint file.
> https://linuxforlovers.wordpress.com/2009/04/17/powerpointflash-interaction/
>
> You can also do this programatically via the FlashPlayerTrust
> http://help.adobe.com/en_US/ActionScript/3.0_ProgrammingAS3/WS5b3ccc516d4fbf351e63e3d118a9b90204-7c95.html#WS357943C4-11D4-4b2a-ADAD-3B485BF39CBF
>
> I don't think relative paths would work in this local-trusted situation so
> you'd have to pass the absolute file system path to the swf when it is
> embeded in the powerpoint file via flashvars.
> https://www.youtube.com/watch?v=BLSJ6a4Djd0
>
> Also… depending on your powerpoint version… you might need to set the
> flashvars via vba because they might not get saved when the powerpoint file
> is closed and reopened.
> http://stackoverflow.com/questions/7089619/setting-value-to-flashvars-property-doesnt-work
>
>
> On Wed, Apr 19, 2017 at 10:43 PM, Deepak MS <[hidden email]>
> wrote:
>
>> Hi,
>> We have a requirement where in we need to display a flex app within ppt.
>> Basically, swf will be embedded within ppt file. However, the data for the
>> app is read from an excel file, which again is embedded within flex app.
>>
>> The excel file data gets refreshed every week. I get the data file, which I
>> need to embed in app and then release the app(swf) to ppt team.
>>
>> I wanted to know if there is any way to embed excel file externally, so
>> that ppt team donot have dependency on me to build swf with every excel
>> change.
>>
>> Kindly let me know if you have any ideas on how can this be done.
>>
>> -Deepak
>>

Loading...