How to extend Web Grid to provide EXCEL Like functions

NetRequirements · July 3, 2017, 1:16am

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.

amjad.sahi · March 20, 2023, 6:39pm

Hi,

Thanks for considering Aspose.

1. Import Excel File

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:

github.com

aspose-cells/Aspose.Cells-for-.NET/blob/master/Examples_GridWeb/GridWeb.Net4/CSharp/Cells/SetAutoFilter.aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace Aspose.Cells.GridWeb.Examples.CSharp.Cells
{
    public partial class SetAutoFilter : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            // If first visit to the page, init GridWeb
            if (!Page.IsPostBack && !GridWeb1.IsPostBack)
            {
                InitGridWeb();
            }
        }

This file has been truncated. show original

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.,

github.com

aspose-cells/Aspose.Cells-for-.NET/blob/master/Examples_GridWeb/GridWeb.Net4/CSharp/databind/Aspose.Cells.GridWeb.DemosCS.DataBind.dataset11.Designer.cs

//------------------------------------------------------------------------------
// <auto-generated>
//     This code was generated by a tool.
//     Runtime Version:2.0.50727.1433
//
//     Changes to this file may cause incorrect behavior and will be lost if
//     the code is regenerated.
// </auto-generated>
//------------------------------------------------------------------------------

#pragma warning disable 1591

namespace Aspose.Cells.Demos.databind {
    
    
    /// <summary>
    ///Represents a strongly typed in-memory cache of data.
    ///</summary>
    [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
    [global::System.Serializable()]

This file has been truncated. show original

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:

github.com

aspose-cells/Aspose.Cells-for-.NET/blob/master/Examples_GridWeb/GridWeb.Net4/CSharp/Miscellaneous/Common/DataValidation.aspx.cs

using System;
using Aspose.Cells.GridWeb.Data;
using System.Collections.Specialized;
using Aspose.Cells.GridWeb;

public partial class demos_Common_DataValidation : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        License lic = new  License();
        //lic.SetLicense(@"C:\CellLicense\Aspose.Total.NET.lic");
        //lic.SetLicense(@"D:\DotNet Projects\Aspose\2019\Aspose.Total.NET.lic");

        if (!IsPostBack && !GridWeb1.IsPostBack)
        {
            
            GridWeb1.WorkSheets.Add();

            //set sheets selectedIndex to 0
            GridWeb1.WorkSheets.ActiveSheetIndex = 0;

This file has been truncated. show original

10. Allow pagination for performance

Yes, the control allows this:

github.com

aspose-cells/Aspose.Cells-for-.NET/blob/master/Examples_GridWeb/GridWeb.Net4/CSharp/Miscellaneous/Common/Pagination.aspx.cs

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

namespace Aspose.Cells.GridWeb.Examples.CSharp.Miscellaneous.Common
{
    public partial class Pagination : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            // If first visit this page init GridWeb1 
            if (!IsPostBack && !GridWeb1.IsPostBack)
            {

This file has been truncated. show original

Thank you.