Hello, I was wondering if it is possible to connect an excel sheet either an online version or local version to my mendix app. I know of the excel import and that works well for me. But I want to know if it is possible for me to make changes in an excel document and those changes to be reflected in my mendix app. Lets say add data in the sheet can that data be then added to the app in the sandbox? Any suggestions or ways to do this would be much appreciated. Thanks.
OData would enable you to do this. You would create a published OData service in your Mendix app and then point Excel to that service to retrieve and update the data.