Do You Want to Speed Up Your Development?

It's very obvious that developers can use Aspose.Cells to create Excel files from scratch with the help of its flexible API. One of the most common uses of Aspose.Cells is to create and populate Excel files with data (that may come from an existing database or a user etc.) dynamically. But, besides adding data to Excel files, developers also need to put some extra efforts by adding lines of code to just apply the format settings (related to look and feel) of the Excel files. Doing so, would definitely increase your development efforts and time. So, what could be the possible solution to speed up your development?

Designer Spreadsheet - The Solution

To speed up your development, Aspose.Cells introduces an exciting feature: Designer Spreadsheet.

What is a Designer Spreadsheet?

A Designer Spreadsheet is an Excel file created by developers using Microsoft Excel in which all format settings are already applied and its contents can be decided at design time. It's more like a template file that doesn't contain any data but just the format settings as shown below:

In the Featured Demos of Aspose.Cells, all spreadsheets are created using this methodology except the Invoice demo.

How to Use It?

After you create a designer spreadsheet, you can use Aspose.Cells API to read the designer spreadsheet and add data to its specified positions (according to your pre-defined format settings) at runtime. For example, in the above figure of a sample designer spreadsheet, you can see that we already decided at design time to add Product Name, Category Name, Quantity Per Unit and Units In Stock columns but with no data, which will be added at runtime. The above figure shows a simple designer spreadsheet but if you want to create well designed spreadsheets then this approach will definitely save your time.

What More?

Additionally, Aspose.Cells also allows to add Smart Markers in the designer spreadsheets, which can be processed by developers at runtime using the Process method of WorkbookDesigner class. This can help you to write least code to get best results.

For more details about Smart Markers and their usage, Click Here .