macromedia.coldfusion.advanced_techniques
[Top] [All Lists]

Re: Refreshing Excel through ColdFusion

Subject: Re: Refreshing Excel through ColdFusion
From: "-==cfSearching==-" <webforumsuser@xxxxxxxxxxxxxx>
Date: Thu, 24 Jul 2008 00:51:45 +0000 (UTC)
Newsgroups: macromedia.coldfusion.advanced_techniques

Magikaru wrote:
 > I can use CF to modify the cell values ...
 > So, if I use CF to read the excel table, change the input values, 
 > and read it again, only the input cell values would have been changed;

 If not with java, how are you reading and modifying the cell values? Are you 
working with an actual binary excel file or some other format? 

 > I have to download this Java library and install it somewhere in ColdFusion? 

 Possibly.  You could also use the http://javaloader.riaforge.org/ to load the 
jar dynamically.  Requirement: You must have access to createObject("java", 
...).   

 I also read an interesting thread over at houseoffusion.com. It mentioned 
there may be a version of POI already installed with CF.  _If_ that is correct, 
the built-in jar might be enough for your purposes.  I imagine it would also 
allow you to test the POIUtility JR "Bob" Dobbs mentioned, without having to 
install a new jar.  Assuming the POIUtility does what you need it to do here..  
 



<Prev in Thread] Current Thread [Next in Thread>