This is great Matt. I cant think of a project I had to work on where we did not have to read or write excel files. I have used Ben Nadel's PoiUtility.cfc for many things, as well as Jason Delmore's cfxl.cfc and cfjxl.cfc.
I had to start using the cfjxl.cfc (JExcelApi) because several companys I work for have exports on their legacy apps that only export excel 95. Unfortunately the POI lib will not read excel 95. So In those use cases I would use the JExcelApi just to read those files and convert to a version POI would read. At first I thought this was overkill, it is not too hard to open a xls and convert it manually. but I was amazed at how many times I have had to use it for automated imports of data. I just wanted to mention this. Great job Matt! On Thu, Jul 16, 2009 at 8:19 PM, Matthew Woodward <[email protected]>wrote: > I was inspired by some discussions with Vince to see what I could do in > terms of creating CFSPREADSHEET functionality that would run on > BlueDragon/OpenBD as well as other CFML engines, and I'm happy to share the > basic results thus far: > http://bit.ly/SKdRo > > The highlights: > * CFSPREADSHEET-like functionality for any CFML engine > * A single CFC can be instantiated and all the methods you need are in that > CFC > * If you prefer, UDFs and custom tags mirror CF 9 syntax > > It's in the beginning stages and there's just a couple of bugs at this > point, but I think it's a good start. I'd love to get feedback from you > brave early-adopter types. > > Thanks again to Vince for the inspiration for taking this on--it's been fun > thus far and I have plans to do a lot more with POI. > > If you're interested in the project make sure and join the mailing list on > Google Groups. Comments welcome. > > Thanks, > Matt > -- > Matthew Woodward > [email protected] > http://www.mattwoodward.com/blog > > Please do not send me proprietary file formats such as Word, PowerPoint, > etc. as attachments. > http://www.gnu.org/philosophy/no-word-attachments.html > -- -- if you've written a homegrown[*CFML] controller layer that rivals the sophistication and ease of use of the three major players (MG/MII/FB) - then share it or shut up. You code in a silo - that's great. Just stay in there and don't try to tell everyone how good it smells. --Dave Ross --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official site @ http://www.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
