CFSpreadsheet - reading an XLS file imports empty columns

[srushing]

Hi everyone,

I'm developing a simple application to let some users upload XLS sheet to be processed and added to a database.  When I do a CFDUMP of the query created by CFSPREADSHEET, I see a lot of extra columns which say "empty string".  I'd like to find a way to delete those columns from the query.  Anyone ran into this and found an elegant solution?  I can't control the creation of the original spreadsheet so I need to put in some logic into my app to make sure I'm not trying to process the empty strings.

Thanks

S

[-__cfSearching__-]

It would help to see a dump of the query. Also, what code are you using to process the query values?