Introduction

Everything in this world is built for some special purpose and so as Aspose.Cells. Aspose.Cells is created to facilitate developers to create and manage Microsoft Excel Spreadsheets programmatically. Aspose.Cells doesn't only understand spreadsheets in Microsoft Excel Sheet Format (XLS) but also many other file formats like Comma Separated Values (CSV), Tab Delimited (Text), SpreadsheetML etc. Aspose.Cells provides most of those features that you use in Microsoft Excel but the exciting thing is that Aspose.Cells allows to process Excel files dynamically, which enables developers to process thousands or millions of spreadsheets in hours or a day. Developers can use Aspose.Cells in any way according to their requirements or desires. We will discuss some common possible scenarios of using Aspose.Cells.

Possible Usage Scenarios

As we have described that it's totally up to the developers that how can they make use of Aspose.Cells to fulfill their application needs but there are few most common scenarios in which Aspose.Cells can be used perfectly. Most common use of Aspose.Cells is deploying it on the Web Server or in Web Services for server side processing. Some of the possible usage scenarios of Aspose.Cells are described below.

Scenario No.1

• Users upload manually created Spreadsheets to server
• Aspose.Cells is used to open files and retrieve data
• After the data is retrieved, there are some possible actions that can be performed by developers:
• Save data to database
• Present data in web pages
• Modify data and send back the modified Excel files

Scenario No.2

• Users input data in web pages
• Data is collected by the web server
• Aspose.Cells is used to populate data in brand new files or pre-defined template files
• After the Excel file is created, it can be sent to user as a report etc.

Note: We have discussed few of the most common scenarios of using Aspose.Cells in web based environment. But Aspose.Cells is equally useful in desktop based applications also.