Last Updated: 2022-2-3
Koivu.Cloud is a platform that lets you develop, deploy and run data-driven applications. The platform is built around the following central concepts:
Also, Koivu.Cloud is a spreadsheet-database hybrid that lets you choose between two interfaces: an Excel add-in or a browser app. The Koivu.Cloud Excel add-in enables you to manage data that is stored in a cloud database with Excel, while the Koivu Web app allows you to access the same data using a web browser.
Additionally, Koivu.Cloud can receive and send data through its REST APIs and provide further computation in the cloud. Using the full capabilities of Koivu.Cloud you can quickly and easily create new Excel and web-based applications that are driven by your data.
Koivu.Cloud integrates seamlessly with Excel, and thus transforms Excel into an interface for a low-code platform that enables you to create data-driven enterprise applications.
The Koivu.Cloud Excel add-in enables you to manage data in Excel that is located in the cloud. With the add-in you can instantly get data into Excel from a database, make changes to the data, and save your changes. However, it's important to note that Koivu.Cloud only saves the data, not the actual Excel workbook. That is, the sheets in your workbook only function as the interface to the data.
In this tutorial we'll go through the basic use of the Koivu.Cloud Excel add-in. You'll learn how to:
Using the Koivu.Cloud add-in is not difficult, however, you should at least have the following:
To begin using the Koivu.Cloud Excel add-in, you have two options. You can either load a workbook from the Koivu Web App, which includes the add-in, or you can load the add-in from the Office store in Excel.
After you have registered and accessed the Koivu.Cloud Web App, you can see instructions on the Homepage that guide you through the add-in activation process. First, to make sure you're on the home screen of the Koivu.Cloud web, click Home from the navigation menu. Next, you'll need to download an Excel file that will automatically look for the add-in. The spreadsheet includes further guidance about the process. The home page displays buttons that you can use to download an Excel workbook, invite people to Koivu.Cloud or access the Koivu.Cloud community. Click Download to get the workbook.
If you choose to use your own Excel workbook, you can install the add-in from the Office Store. First, open a workbook in Excel.
To get the add-in from the Office Store:
Koivu
.Alternatively, if your Office Admin has approved the Koivu.Cloud add-in, select Admin managed instead of Store.
Once you've installed the add-in you still need to open it in Excel.
To open the add-in:
Before you can start using the add-in, you need to login:
Alternatively, you can use the other sign-in possibilities, such as Google Sign-In.
In summary, you can use the Excel add-in to search, view, create and change data that is stored in the cloud database. The following sections introduce how you can perform basic data management with the Koivu.Cloud Excel add-in. Including how to:
The Excel workbook can be empty, but it is recommended that you build a specific template for your data. This template file would have all but the actual data rows. We'll go through templates in another tutorial. But for now we'll discuss only the very basic use of the Excel add-in.
You can use the Search command to retrieve data from the cloud database into an Excel sheet:
Different cloud tables have different query options. The Example table above only includes a default search field.
You can modify the spreadsheet's values in the usual manner. For example, you can insert and delete rows if needed. However, we've put some of the most used operations as helper tools into the add-in to make it easier to add rows.
Cloning data copies the data from the selected row(s) into the new row(s).
To clone the data:
After you have done your modifications, you need to save the changes into the cloud database.
To save your data:
Congratulations, you now know how to find your way around the Koivu.Cloud Excel add-in! Of course, the add-in includes plenty of additional functionality, which we'll cover in other tutorials, but these skills are enough to get you started.
You now have the Koivu.Cloud add-in, and know how to search, modify and save data. You also learned how Koivu.Cloud uses a cloud database to store data.
Next, explore these tutorials to learn more about what you can do with Koivu.Cloud:
Note that these tutorials are meant to be read in order, so start with the first one.
Make sure to visit our community site and learn more about Koivu.Cloud.