I am using the Import Excel to Database plugin along with a Connected System to download Excel files from a client’s Google Drive.
Here is the behavior I am observing:
When the Excel file is created using Microsoft Excel, the file is downloaded successfully via the Connected System, and the plugin works as expected. All the data present in the Excel file is imported correctly.
However, when the Excel file is created in Google Sheets, or when an existing Excel file is opened/edited and saved using Google Sheets, the file is still downloaded successfully, and I can see the complete data in the file. But in this case, the Import Excel to Database plugin treats the file as null and does not return any data.
.xlsx
Is this a known limitation of the Import Excel to Database plugin when handling .xlsx files generated or modified by Google Sheets? If so, is there any workaround or recommended approach to handle Excel files coming from Google Sheets?
Any guidance or suggestions would be greatly appreciated.
The imported file is updated in Google Sheet.
The imported file updated in MS Excel
Process Model --
Discussion posts and replies are publicly visible