Where can I find "How to..." for Grid control & Excel like supported function?

NetRequirements · July 3, 2017, 1:13am

We are in process of making a successful POC to provide "excel like functionality" on ASP.NET 2.0 Web page.

I could upload the EXCEL file in Grid.

Any specific URLs on "How to" that you suggest for following:-

Allow User to delete and insert Columns.
Allow User to insert, delete rows.
Allow user to search and replace (multiple).
Allow Dropdown List for specific columns and cells.
Allow to mark fixed /stationary/frozen Rows & Columns
Allow users to format data (interger (01, 12,) , decimal (1.2, 0.02, 0.40), date (MM/DD/YYYY)
Allow Sort

Any information is greatly appreciated.

Thank you.

amjad.sahi · March 20, 2023, 7:04pm

Hi,

Thanks for considering Aspose.

I think I have already answered a few those, please check:

and for inserting rows /columns, please check wiki topic:

Check:

Allow user to search and replace (multiple).

Yes you may do it, Aspose.Grid.Web offers the related options in its context menu just like MS Office env. Please right-click on the GridWeb control at runtime and you may have Find… Replace Dialog boxes.

Please check:

Allow Dropdown List for specific columns and cells.

If you mean to say AutoFilter feature, 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

Well, Aspose.Grid.Web allows to define dropdowns through data validations only, 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

Allow to mark fixed /stationary/frozen Rows & Columns

Please check the url:

and also check the online demos:

github.com

aspose-cells/Aspose.Cells-for-.NET/blob/master/Examples_GridWeb/GridWeb.Net4/CSharp/RowsAndColumns/FreezePanes.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;
using Aspose.Cells.GridWeb.Data;
using Aspose.Cells.GridWeb.DemosCS;

namespace Aspose.Cells.GridWeb.Examples.CSharp.RowsAndColumns
{
    public partial class FreezePanes : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            // If first visit this page clear GridWeb and load data

This file has been truncated. show original

Allow users to format data (integer (01, 12,) , decimal (1.2, 0.02, 0.40), date (MM/DD/YYYY)

Please check the wiki topic:

Also you may check the following demos:

github.com

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

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

namespace Aspose.Cells.GridWeb.Examples.CSharp.Miscellaneous.Format
{
    public partial class ApplyNumberFormats : System.Web.UI.Page
    {
        Aspose.Cells.GridWeb.GridTableItemStyle style = null;

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack && !GridWeb1.IsPostBack)
            {
                initData();

                
            }
        }

        private void initData()

This file has been truncated. show original

github.com

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

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

namespace Aspose.Cells.GridWeb.Examples.CSharp.Miscellaneous.Format
{
    public partial class ApplyDateTimeFormats : System.Web.UI.Page
    {
        Aspose.Cells.GridWeb.GridTableItemStyle style = null;

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack && !GridWeb1.IsPostBack)
            {
                InitData();

                // Set sheets selectedIndex to 0
                GridWeb1.ActiveSheetIndex = 0;
            }
        }

This file has been truncated. show original

github.com

aspose-cells/Aspose.Cells-for-.NET/blob/master/Examples_GridWeb/GridWeb.Net4/CSharp/Miscellaneous/Format/ApplyCustomFormats.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;
using Aspose.Cells.GridWeb.Data;
using Aspose.Cells.GridWeb;

namespace Aspose.Cells.GridWeb.Examples.CSharp.Miscellaneous.Format
{
    public partial class ApplyCustomFormats : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack && !GridWeb1.IsPostBack)

This file has been truncated. show original

Allow Sort

Please check the following demo:

github.com

aspose-cells/Aspose.Cells-for-.NET/blob/master/Examples_GridWeb/GridWeb.Net4/CSharp/Worksheets/SortData.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;
using Aspose.Cells.GridWeb.Data;
using System.Drawing;
using Aspose.Cells.GridWeb;

namespace Aspose.Cells.GridWeb.Examples.CSharp.Worksheets
{
    public partial class SortData : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

This file has been truncated. show original

Note: the featured demos

are automatically installed when you install using control’s Aspose.Grid.MSI installer and you may open the installed asp.net solutions opening into VS.NET.

Thank you.