Excel and Coldfusion

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

numerical07 - 27 Mar 2007 02:04 GMT

I know how to turn a html document into a excel document. but how do I turn excel document into a query to appear on a page or even in a database

Reply to this Message

kim il sung - 27 Mar 2007 11:37 GMT

search excell tags from cf exchange.
cheers
kim

Reply to this Message

JR "Bob" Dobbs - 30 Mar 2007 17:02 GMT

I know of two possiblities

1. Ben Forta explains has a sample in Chapter 27 of "Advanced ColdFusion MX 7
Application Development".

2. Using Apache Jakarta POI
http://www.bennadel.com/index.cfm?dax=blog:472.view
http://www.bennadel.com/index.cfm?dax=blog:474.view

Reply to this Message

Sojovi - 30 Mar 2007 17:15 GMT

The simplest solution could be create a datasource targeting the excel files
and retrieve the content with SQL statements, but this solution not always
works, depends on the complexity of the excel document.

Regards

Reply to this Message

Webmaster Forum / ColdFusion / Getting Started / March 2007

Excel and Coldfusion