CFSpreadsheet - reading an XLS file imports empty columns

Report · Jun 23, 2012

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

Report · Jun 25, 2012

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