Where to Use Aspose.Cells

Aspose.Cells is created to help developers create and manage Microsoft Excel spreadsheets programmatically. Aspose.Cells does not only understand spreadsheets in Microsoft Excel Sheet Format (XLS/XLSX) but also many other file formats like Comma Separated Values (CSV), Tab‑Delimited/TSV (text), SpreadsheetML, etc.

Aspose.Cells provides most of the features available in Microsoft Excel, but the exciting thing is that Aspose.Cells can process Excel files dynamically, which enables developers to process thousands or millions of spreadsheets very quickly.

This article discusses common scenarios of using Aspose.Cells.

Possible Usage Scenarios

It’s up to developers how they use Aspose.Cells, but there are a few common scenarios in which Aspose.Cells can help. The most common use of Aspose.Cells is deploying it on a web server or in web services for server‑side processing. Some of the possible usage scenarios of Aspose.Cells are described below.

Automated Spreadsheet Management

1. Users upload manually created spreadsheets to a server.
2. Aspose.Cells is used to open files and retrieve data.
   After the data is retrieved:
   1. The data is saved to a database.
   2. Certain data is presented in web pages.
   3. Some aspects of the spreadsheets are modified and saved back as Microsoft Excel files.

Web Application

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

We have discussed a few of the most common scenarios of using Aspose.Cells in a web‑based environment. But Aspose.Cells is equally useful in desktop‑based applications as well.