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.
Hi,
Thanks for considering Aspose.
I think I have already answered a few those, please check:
Class Libraries & REST APIs for the developers to manipulate & process Files from Word, Excel, PowerPoint, Visio, PDF, CAD & several other categories in Web, Desktop or Mobile apps. Develop & deploy on Windows, Linux, MacOS &...
and for inserting rows /columns, please check wiki topic:
Check:
Class Libraries & REST APIs for the developers to manipulate & process Files from Word, Excel, PowerPoint, Visio, PDF, CAD & several other categories in Web, Desktop or Mobile apps. Develop & deploy on Windows, Linux, MacOS &...
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:
Class Libraries & REST APIs for the developers to manipulate & process Files from Word, Excel, PowerPoint, Visio, PDF, CAD & several other categories in Web, Desktop or Mobile apps. Develop & deploy on Windows, Linux, MacOS &...
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:
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();
}
}
show original
Well, Aspose.Grid.Web allows to define dropdowns through data validations only, please check:
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;
show original
Allow to mark fixed /stationary/frozen Rows & Columns
Please check the url:
Class Libraries & REST APIs for the developers to manipulate & process Files from Word, Excel, PowerPoint, Visio, PDF, CAD & several other categories in Web, Desktop or Mobile apps. Develop & deploy on Windows, Linux, MacOS &...
and also check the online demos:
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
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:
Class Libraries & REST APIs for the developers to manipulate & process Files from Word, Excel, PowerPoint, Visio, PDF, CAD & several other categories in Web, Desktop or Mobile apps. Develop & deploy on Windows, Linux, MacOS &...
Also you may check the following demos:
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()
show original
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;
}
}
show original
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)
show original
Please check the following demo:
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)
{
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.