Hi,
Thanks for considering Aspose.
I think Aspose.Grid can serve your need. I will also try to answer you queries by referencing some of our featured demos: http://www.aspose.com/demos/aspose.grid/default.htm The featured demos are automatically installed on your system when you use Aspose.Grid.msi installer to install it. So, you may open the demos solutions in your VS.NET and check the source codes.
User select number of rows to display per page (Show 10, Show 20, etc.)
Do you mean records per page for paging. You can set it for your need: e.g.,
// Allows Paging.
GridWeb1.EnablePaging = true;
// Specifies the Size 20 rows per Page.
GridWeb1.PageSize = 20;
You can also set the grid's matrix: e.g..,
private void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
GridWeb1.MaxColumn = 85;
GridWeb1.MaxRow = 10;
}
}
Pagination: Previous/Next and First/Last Buttons, Display page X of X
Please check: http://www.aspose.com/demos/aspose.grid/description/common/pagination.htm
Grouping of data
Please check: http://www.aspose.com/demos/aspose.grid/description/grouping/grouping.htm
http://www.aspose.com/demos/aspose.grid/description/grouping/subtotal.htm
AJAX Enabled behaviors
Please check: http://www.aspose.com/demos/aspose.grid/description/grouping/subtotal.htm
Save User profile (preferences, columns displayed, etc.)
I think you can set session modes, please check: http://www.aspose.com/documentation/visual-components/aspose.grid-for-.net/introduction-to-different-grid-modes.html: . Another example is here: e.g.,
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using Aspose.Grid.Web;
using Aspose.Grid.Web.Data;
namespace Aspose.Grid.Web.DemosCS
{
///
/// Summary description for WebForm8.
///
public class WebForm8 : System.Web.UI.Page
{
protected Aspose.Grid.Web.GridWeb GridWeb1;
private void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
GridWeb1.WebWorksheets.Clear();
//GridWeb1.EnableSession = false;
GridWeb1.SessionMode = SessionMode.Custom;
// Loads the initial data, from file or database.
GridWeb1.WebWorksheets.ImportExcelFile("d:/test/test.xls");
// Do something.....................
// Saves the session data.
GridWeb1.SaveAGW2File("d:/test/save.agw2");
}
}
private void GridWeb1_SheetDataUpdated(object sender, System.EventArgs e)
{
// Handles the SheetDataUpdated event.
// Saves the session data for each update.
GridWeb1.SaveAGW2File("d:/test/save.agw2");
}
private void GridWeb1_LoadCustomData(object sender, System.EventArgs e)
{
// Handles the LoadCustomData event.
// Loads the session data.
GridWeb1.LoadAGW2File("d:/test/save.agw2");
}
Conditional Formatting
It's not supported yet.
Preset Display Styles (Office 07, etc.)
Please check: http://www.aspose.com/demos/aspose.grid/description/common/changestyle.htm
Summary Row
Please check: http://www.aspose.com/demos/aspose.grid/description/grouping/grouping.htm
http://www.aspose.com/demos/aspose.grid/description/grouping/subtotal.htm
And kindly check Aspose.Grid documentation: http://www.aspose.com/documentation/visual-components/aspose.grid-for-.net/index.html for your further reference.
Thank you.