Free Support Forum - aspose.com

How to extend Web Grid to provide EXCEL Like functions

Aspose.Cells Product Family
#1

I am looking to build / develop following functions for our end users of ASP.NET 2.0 web based application:-

1. Import Excel File

2. Allow users to delete rows, columns

3. Allow users to map "columns from EXCEL File" into application specific "Data Columns" using say dropdowns that appear in first row and that row stays "fixed" or "stationary".

4.provide multiple lookup , search and replace functions

5. Add a row

6. Add a column

7. Provide "additional command buttons" that will allow to execute specific .NET code (such as unloading the web form (ASPX PAGE) that contains the grid)

8. Conditionally enable / disable cells

9. Allow dropdowns in cell / columns.

10. Allow pagination for performance

The maximum # of rows in the EXCEL file will be around 30, 000 and we think that the files that we will get contain 12-20 columns.

Any guidance / help is greatly appreciated.

We have used "Infragistics Web Grid" and "FarPoint's Spread" to achieve similar functions but we have to write great deal of code to accustom everything and now we are evaluating if ASPOSE controls can save our time by providing ready to use functionality mentioned above.

Thank you.

#2

Hi,

Thanks for considering Aspose.

1. Import Excel File

Yes you can do it with ease, please check for importing: http://www.aspose.com/Wiki/default.aspx/Aspose.Grid/OpeningWebExcelFile.html

and for exporting: http://www.aspose.com/Wiki/default.aspx/Aspose.Grid/SavingWebExcelFile.html

2. Allow users to delete rows, columns

Yes, Aspose.Grid.Web provides a context menu which has these options. Alternatively you may do it programmatically using the API of Aspose.Grid.Web.i.e. WebCells.DeleteRow(s), WebCells.DeleteColumn methods. Also check: http://www.aspose.com/Wiki/default.aspx/Aspose.Grid/DeleteRowsColumns.html

3. Allow users to map "columns from EXCEL File" into application specific "Data Columns" using say dropdowns that appear in first row and that row stays "fixed" or "stationary".

You mean AutoFilter feature, yes Aspose.Grid.Web offers this feature. Please check the related demo: http://www.aspose.com/Products/Aspose.Grid/Demos/Filter/AutoFilter.aspx

4.provide multiple lookup , search and replace functions

Yes you may do it, Aspose.Grid.Web offers the related options in its context menu just like MS Office env.

5. Add a row

Yes, you may add rows and column

6. Add a column

Yes, you may add rows and column

Check: http://www.aspose.com/Wiki/default.aspx/Aspose.Grid/InsertRowsColumns.html

7. Provide "additional command buttons" that will allow to execute specific .NET code (such as unloading the web form (ASPX PAGE) that contains the grid)

Yes Aspose.Grid.Web allows to create custom command buttons, please check the related Databinding demos e.g, http://www.aspose.com/Products/Aspose.Grid/Demos/DataBind/DataBind1.aspx

8. Conditionally enable / disable cells

Yes you may do it, please check: http://www.aspose.com/Wiki/default.aspx/Aspose.Grid/ProtectingCell.html

Yes you may do it using the APIs of the Aspose.Grid.Web.

9. Allow dropdowns in cell / columns.

Well, Aspose.Grid.Web allows to define dropdowns through data validations, please check: http://www.aspose.com/Products/Aspose.Grid/Demos/common/dataValidation.aspx

10. Allow pagination for performance

Yes, the control allows this: http://www.aspose.com/Products/Aspose.Grid/Demos/common/Pagination.aspx

Thank you.