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();
}
}
This file has been truncated. 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;
This file has been truncated. 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
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:
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()
This file has been truncated. 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;
}
}
This file has been truncated. 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)
This file has been truncated. 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)
{
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.