hii
i planed to use aspose grid for grid purpose in vb.net 2005/windows vista.
I need some help for
1.is it support grouping/subtotal/treeview functions
2.how can print/print preview the grid directly
3.how can handle large data like 300000 records
need help with samples
thanking you
Diji Varghese
Hi Diji Varghese,
Thanks for considering Aspose.
1.is it support grouping/subtotal/treeview functions
Yes, the GridWeb supports, kindly check the following featured demos (the demo solutions are automatically installed when you use Grid's msi installer to install the control):
grouping: http://www.aspose.com/demos/aspose.grid/description/grouping/grouping.htm
subtotaling: http://www.aspose.com/demos/aspose.grid/description/grouping/subtotal.htm
treeview: http://www.aspose.com/demos/aspose.grid/description/databind/expandchildview.htm
2.how can print/print preview the grid directly
Well, the feature is not supported, but you may use Browser's option (e.g.., IE) to print the grid for your need.
3.how can handle large data like 300000 records
Well, manipulating huge data e.g.., 300000 records would require huge amount of memory and resources. I think you may try some options:
1. Try splitting 300000 records into multiple worksheets in an excel file or workbooks (excel files).
2. Use Paging option (e.g.., GridWeb.EnablePaging = true) to accordingly: http://www.aspose.com/demos/aspose.grid/description/common/Pagination.htm
3. Try to use Style formattings where necessary, create style object (TableItemStyle class) with common formattings and apply the style to the cells.
4. Try set GridWeb.EnableSmartNavigation to set to false, it will also improve performance to some extent.
Thank you.
Can you please elaborate on the style formatting settings in your 3rd suggestion?
Hi,
Here is the sample code for Style Formattings to explain you:
Sample code:
TableItemStyle style = new TableItemStyle();
style.HorizontalAlign = HorizontalAlign.Center;
style.BorderStyle = BorderStyle.Solid;
style.BorderColor = Color.Black;
style.BorderWidth = 1;
for (int i = 1; i <= GridWeb1.WebWorksheets[0].Cells.MaxRow; i++)
{
for (int j = 0; j <= GridWeb1.WebWorksheets[0].Cells.MaxColumn; j++)
{
WebCell cell = GridWeb1.WebWorksheets[0].Cells[i, j];
cell.Style.CopyFrom(style);
}
}
Thank you.