Aspose cells capabilities

Aspose.Cells Product Family
1

I am looking for a spread sheet control and came across your product … I have few questions with respect to its capabilities …

1.Can the control be used in asp.net, asp.net MVC, HTML5 applications.

  1. Does it offer any java script framework for spread sheet manipulation ? I am planning to use the spreadsheet control as a client side control.
    For example I may extract data out of excel on the client and may further process data using javascript.

  2. Are there any limitations on the number of rows ? The data I have might run into 10,000 …

  3. Does the spread sheet control offer copy & paste options ? where in I can copy data from another excel into the spread sheet control.

  4. Does it offer filtering & sort ?

  5. Does it offers Validated Lists / drop downs ?

  6. Does it offers VLookup ?

2

@raghbala329

Thanks for considering Aspose APIs.

Aspose.Cells can create and manipulate Excel files without the use of Microsoft Excel. It means, Aspose.Cells does not depend upon Microsoft Office or Office Automation. It is a class library that can be used on server side without any issue of performance or memory.

Here are the Aspose.Cells Family products that you can consider.

1 - Aspose.Cells for .NET

This is the most advanced version of Aspose.Cells. It supports all of the features you have mentioned. It depends on .NET Framework alone.

2 - Aspose.Cells for JavaScript

Probably, this is the one you need. But it is in initial releases and it may not support all of your needs. Please visit this page to explore it more.

Node.js APIs for Excel Spreadsheets | products.aspose.com

3 - Aspose.Cells for GridWeb and GridDesktop

These two components are GUI components. They present themselves as grids like Microsoft Excel and are used for Web and Windows Form applications. They are built on the top of Aspose.Cells for .NET

Please visit these links for more help.

Excel File Format Solution | products.aspose.com
Aspose.Cells for .NET|Documentation
Aspose.Cells Product Family
Aspose.Cells.GridWeb|Documentation
Aspose.Cells.GridDesktop|Documentation

3

Are there any hosted working sample available ?

From the documentation I understand that GridWeb is supported only on asp.net type of applications ? Is my understanidng correct ?

4

@raghbala329,

You may find examples (for Aspose.Cells, Aspose.Cells.GridWeb, Aspose.Cells.GridDesktop) @ Github repos. here:

Yes, your understanding is correct.