Hi Les,
Are you working with Excel 2007 files? I've had issues with reading the
latest version of Excel files using the version of the POI library included
in CF. After upgrading to the newer 3.0.2 version I had less issues.
HTH,
t
On Mon, Jun 23, 2008 at 1:46 PM, Les Mizzell <[EMAIL PROTECTED]> wrote:
> I've got it working pretty darned good - except for one problem. If
> there's a NULL cell in the Excel sheet, it's throwing an error
>
> "Element CELL is undefined in LOCAL."
>
> LOCAL.CellType = LOCAL.Cell.GetCellType();
>
>
> If I go into my Excel sheet and just enter a space in the cells, no error.
>
> So, I'm trying a try/catch block to force the cell type to string (1),
> if it's NULL since I know that's what all the values are in the sheets
> being used anyway:
>
> for (
> LOCAL.ColumnIndex = 0 ;
> LOCAL.ColumnIndex LT LOCAL.ColumnCount ;
> LOCAL.ColumnIndex = (LOCAL.ColumnIndex + 1)
> ){
>
> LOCAL.Cell = LOCAL.Row.GetCell( JavaCast( "int", LOCAL.ColumnIndex ));
>
>
> // Get the type of data in this cell.
>
> try {
> LOCAL.CellType = LOCAL.Cell.GetCellType();
> } catch(any excpt)
> {
> LOCAL.CellType = 1
> }
>
>
> But, that doesn't seem to be working either.
>
> Anybody got a clue?
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307996
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
