*Excel limitations apply across all cloud providers when you use an Excel file to build your app. Smartsheet: Sheet and file size limitationsīox: What is the maximum file size I can upload? *ĭropbox: Is there a limit or maximum to how big my files can be? * Google Drive: Files you can store in Google DriveĮxcel and Office 365: Excel specifications and limits If you want to know the limitations by provider, please check the links below: If you've ever worked in an Excel spreadsheet that uses all the processors in your PC and takes over a minute to refresh because of formulas, then you should expect a similar behavior in your app if it's connected to that spreadsheet. Please keep this in mind as you build your app. If you do enable the option to cache images for offline access, they are stored in a different location on the device that does not have the same size limitations.Įach spreadsheet provider has their own limitations based on performance, file size, number of formulas and calculations. Images and documents are not cached locally on the device by default. You can definitely have applications with many rows and an image in every row.
"External" data like images and documents are not included in this data size limit. In the future, we may increase the 5MB/10MB limit. In general, the fewer cells in the sheet, the better.
For example, a large spreadsheet with a lot of empty cells will probably compress better than a smaller spreadsheet with no empty cells. It is difficult to translate this accurately into a specific number of rows or columns because compressed data size depends on how much repetition there is in the data. What is "huge"? For an AppSheet app, the compressed data size limit is 5MB or 10MB (depending on the device) for all the data in one app. Ideally, you should make your data set as small as possible to achieve the desired functionality.ĭo not build an AppSheet app against a huge data set. This is an important factor to consider when designing your app. As a result, all data used by the app must be cached locally on the mobile device. AppSheet is meant for mobile apps that are designed to work seamlessly despite intermittent connectivity or being completely offline.
0 kommentar(er)
