March 9, 2020
ColdFusion 2016 and Google Drive
Comments
(0)
March 9, 2020
ColdFusion 2016 and Google Drive
Newbie 1 posts
Followers: 0 people
(0)

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.

0 Comments
Add Comment