A community for Application Developers on OrangeScape's Platform-as-a-Service
Microsoft Excel or Access is the traditional way of storing data for all major long tail applications in non IT companies. In case if you have all the the models in XLSX formate and you require all of them to migrate to OrangeScape, the studio provides you a simple one click option to import your XLSX files and create new models in the application.
Below are few points to be known, how it works?
Use only one sheet in the Microsoft Excel 2007 (xlsx sheet).
The public cells for the studio should be given as named cells in the xlsx sheet.
All the formula in the unnamed cells gets imported as private cells in studio.
If there are any formulas in the xlsx which is not supported in the studio, the upload shows an information as "Unsupported Formula" and migrates the remaining contents of the xlsx to the model.
Studio captures all the formates specified in the xlsx sheet.