I’m trying to export a Google Sheets file as xlsx file using Google Drive node. The file is correct, i’ve set the file conversion to MS Excel and included a file name with extension. But, when I download the output, is very different from the file download clicking on the Google Sheets UI. The file seems corrupted. Am I doing something wrong?
My main goal is to send this file to a slack channel.
I had a look at the Google Drive node, it appears that when we use the Google File Conversion Google Sheet to MS Excel we actually download the file in the mimetype application/x-vnd.oasis.opendocument.spreadsheet that matches the OpenDocument format.
The extension of the file should therefore be .ODS and you should be able to open it with Excel.
In any case I will see with our node team if we can implement a direct download in .XLSX (mimetype application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)