This page is an overview of getting started with Spreadcell. Also you will find here further links for Spreadcell documentation and related resources. Spreadcell is Microsoft Excel™ library for syncronizing Excel files and building Excel based business applications. Learn what Spreadcell is all about on our homepage or in the tutorial.
Creating Spreadcell project is easy. Just create account (if you don't have it yet) or log in. In your Spreadcell administration panel choose "PROJECTS", click on "CREATE NEW PROJECT" and add a name to your project.
Now your first Spreadcell project has been created.
Please see, that every project has it's unique ID (GUID). This GUID is needed to connect your Spreadcell Excel file with server.
Download latest Spreadcell Excel connector file. This file contains short overview and sample data structure.
It is also possible to import Spreadcell macros to your existing Excel file (please see the Tutorial - Updating project).
Now you are ready to define:
Good thing about Spreadcell is that you can start working with it (or just testing) without adding all your objects and fields. Spreadcell data structure is dynamic, so there is no need to build or deploy anything. Just add a new object or attribute and server will restore this, when it gets the data from Excel.
Also there is no need to define forms, you can just use tables (ordinary Excel sheets) for managing data and syncronizing with server.
After defining your objects and attributes, add your project GUID in Spreadcell settings (scSettings sheet "ProjectGUID" setting). Now reload the API, log in with your username and password and start syncing data between Excel files or other users.
If data objects are properly set, you will see:
Now as your project is ready (you will need you can add colaborators to your project, see the change log and data, create backups, manage counter fields etc.
Spreadcell provides many functions for developing applications with VBA. Description of most useful methods can be found from Excel API page. There is also overview of Spreadcell classes, forms and macros. As Spreadcell Excel connector source is open, it is possible to investigate the methods right from Spreadcell source code.