Using the POI is awesome. It can do so much more than the cf9 spreadsheet option. You just have to get used to it.
There is a cf poi cfc on riaforge. I helped with some of the extra features! To use even more features you can also "upgrade" the poi that cf uses. Steve -----Original Message----- From: fun and learning [mailto:funandlrnn...@gmail.com] Sent: Thursday, August 11, 2011 11:59 AM To: cf-talk Subject: quick excel question Hi All - I am trying to generate excel using xml. I have a scenario where only 7 columns will be static and other columns are dynamic and may range from 1 to as many as 300 columns. And number of rows would be around 1000. What is the best approach for this situation. I tried new cf9 spreadhsheet but it failed just for few columns. XML workbook works fine where cf9 spreadsheet failed. I am just wondering will using apache poi directly will be of any use since I think cf9 spreadhseet also uses poi Thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346705 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm