I’m soliciting help with a problem.
Using ColdFusion 2016 Enterprise, I trying to read a Google Spreadsheet (Sheets). Using CFFILE ACTION=”UPLOAD”, I cannot read a Google Sheet file nor one download to my local drive with the File -> Download -> Microsoft Excel option within Google Sheets and read it that way. The best that I can determine is that I have to download it, open it with MS Excel, and re-save it in a new version of MS Excel in order to read it. Google Sheets is making the spreadsheet in version 5.0 to 7.0 and CFFILE ACTION=”UPLOAD” will only read spreadsheets created with version 95+ . It would be a pain to download and have to convert thirty+ (30+) Sheets every time someone who it’s shared with makes a change.
Thanks in advance.