how to read a xls file

[jorgemur]

I was searching in internet about this and I found a library "POIUtility" wich I down loaded.

When I run the test code I get the following error:

Element CELL is undefined in LOCAL.

This is the line with the problem: 365 : LOCAL.CellType = LOCAL.Cell.GetCellType();

Has anybody used that library ?

Or, if do you know another way to do it !!!

[c_wigginton]

There's a couple of ways to do it from using a COM object or just setting up the excel file up as an odbc datasource. I've got a writeup on the datasource method on my blog that may help.

http://www.intersuite.com/client/index.cfm/2006/12/5/ColdFusion-QD-Reading-Excel-Data

[Newsgroup_User]

This link just came through the HouseOfFusion cftalk list. Looks very
interesting.

http://www.bennadel.com/index.cfm?dax=blog:474.view