Copy link to clipboard
My goal here is being able to identify if a file is correctly formatted or not for reading in cfspreadsheet. Technically speaking "Does this file have these X columns? (yes/no)". I don't care how this is done... but I have no other means to do it than subject it to cfspreadsheet action="read".
One of the biggest challenges when dealing with imports is getting clients to use "clean" files. I've run into several situations where they will "hide, merge, etc" columns and entire tabs. Recently a client attempted to update 100 records where a tab had been "hidden". There wasn't a lot of data and due to privacy I can't share that file, however I can confirm that something about this excel sheet would trigger incredibly high cpu usage until such point that ColdFusion would crash.
The only way we were able to get it to import was to copy/paste the data from tab 2 into a new xlsx document. Then it worked fine.
Any suggestions on how to read if a xlsx document is formatted correctly would be great,
Have something to add?