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:307994
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
