You have the option to use an online stored file for your app. For example a spreadsheet from your Dropbox, Sharepoint, OneDrive or Google Sheets.
The use of source files stored in the cloud has the advantage that changes made in the Excel spreadsheet itself will be communicated directly with the app.
The modified file does not need to be switched each time manually in the app creator.
When using files from your cloud, only the initial app creation process takes place in the Open as App Cloud. In this case the source file will be encrypted and stored temporarily for the creation process only. Future changes to your spreadsheet are communicated to your mobile devices by your cloud directly. This communication is never taking place via the Open as App cloud.
Currently, you have the possibility to access files from your Dropbox, SharePoint Online, OneDrive, Google Sheets, Box, and the providers shown in the picture below.
More information about the individual providers can be found in the section 'Data'
n 'Step 1: Data' you will be asked to select the Excel file you want to turn into an app.
Please note that some browsers prevent the website to open "pop-up windows". Open your browser settings and allow www.openasapp.net to open pop-up windows.
- Click on "Choose File" to open the upload file dialogue.
Alternative: You can drag & drop it in the framed area (Drop Excel File Here).
- Choose your desired Excel file.
- Click on 'Open' in the dialogue window or
- Select your cloud provider from the 'Connect external service' section.
- Log into your cloud account (if needed).
- Allow access to the file to create an app out of it. Access can be revoked at any time in your cloud settings.
- Select the desired file.
- Click open.
The Open as App Wizard immediately begins the analysis of the file structure and automatically redirects you to the next step of the app creation process.
Alternatively, you can paste the link to the source file "manually". Please note that in this case a guest-link to the file must be generated.
- Under the 'Connect external service' section click on the 'Paste a shared URL' link.
- Paste the link to your Excel file in the pop-up window.