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.
Yes you can do it with ease, please check for importing:
and for exporting:
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:
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:
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:
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.,
8. Conditionally enable / disable cells
Yes you may do it, please check:
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: