Free Support Forum - aspose.com

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

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: http://www.aspose.com/Community/Forums/thread/102203.aspx

I specify the related urls for all your queries here as well, kindly check them:

  • Allow User to delete and insert Columns.
  • Allow User to insert, delete rows.

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: http://www.aspose.com/Wiki/default.aspx/Aspose.Grid/DeleteRowsColumns.html

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

Check: http://www.aspose.com/Wiki/default.aspx/Aspose.Grid/InsertRowsColumns.html

  • 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: http://www.aspose.com/wiki/default.aspx/Aspose.Grid/SearchingAndReplacing.html

  • 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: http://www.aspose.com/Products/Aspose.Grid/Demos/Filter/AutoFilter.aspx

Well, Aspose.Grid.Web allows to define dropdowns through data validations only, please check: http://www.aspose.com/Products/Aspose.Grid/Demos/common/dataValidation.aspx

  • Allow to mark fixed /stationary/frozen Rows & Columns

Please check the url: http://www.aspose.com/wiki/default.aspx/Aspose.Grid/AGWFreeze.html

and also check the online demos: http://www.aspose.com/Products/Aspose.Grid/Demos/common/FreezePaneCustom.aspx

http://www.aspose.com/Products/Aspose.Grid/Demos/common/FreezePane.aspx

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

Please check the wiki topic: http://www.aspose.com/Wiki/default.aspx/Aspose.Grid/FormattingCells.html#NumberFormat

Also you may check the folowing demos:

http://www.aspose.com/Products/Aspose.Grid/Demos/format/number.aspx

http://www.aspose.com/Products/Aspose.Grid/Demos/format/dateAndTime.aspx

http://www.aspose.com/Products/Aspose.Grid/Demos/format/CustomFormat.aspx

  • Allow Sort

Please check the folowing demo:

http://www.aspose.com/Products/Aspose.Grid/Demos/common/Sort.aspx

Note: the featured demos http://www.aspose.com/Products/Aspose.Grid/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.