Skip to main content
Known Participant
June 23, 2012
Question

CFSpreadsheet - reading an XLS file imports empty columns

  • June 23, 2012
  • 1 reply
  • 1016 views

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

    This topic has been closed for replies.

    1 reply

    Inspiring
    June 25, 2012

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