Write directly to Excel file hosted on Microsoft One Drive

Hi ​@davtorgh,

Thank you for posting your question on the FME Community!

There isn’t currently a way to write directly to an Excel file hosted on OneDrive in the same way that FME can write directly to Google Sheets. However, you can still achieve the same end result using a file-based workflow in FME.

A common approach is to use the OneDriveConnector to download the Excel file from OneDrive to a local location, then read that local file using a FeatureReader (or the Excel reader). Once the data has been processed or updated in FME, you can write the updated Excel file using a FeatureWriter, and finally upload the file back to OneDrive using the OneDriveConnector. This workflow overwrites the existing Excel file in OneDrive. 

Please let me know if you have any questions about this. I’m happy to help!