Barney, That looks awesome, I don't know why I didn't find that when I just-f*in-googledit.
Thanks a ton! Chris Peterson -----Original Message----- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Thursday, July 13, 2006 3:38 PM To: CF-Talk Subject: Re: CF query to excel question JExcelAPI is a nifty little Java library for reading and writing Excel workbooks. Jakarta POI is another. I've usually been concerned with writing excel sheets, not reading them, but both have that capability. Of the two, based on my limited experience, I prefer JExcelAPI. It's worth mentioning, however, that POI does Word docs as well as Excel, so if you need both, it's probably the way to go. cheers, barneyb On 7/13/06, Peterson, Chris <[EMAIL PROTECTED]> wrote: > I am designing a program to allow ad-hoc queries across 2 joined excel > sheets, and am running into a snag. I really don't want to limit my > users to only uploading an excel file with a workbook named 'sheet1', > is there any way using CF, ODBC, or java to query a list of available > sheets and / or data ranges from an excel workbook on Windows 2003 > server with CF 7.02 Ent? > > Chris Peterson -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246459 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
