Need A support

Aspose.Cells Product Family
1

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

This message was posted using Email2Forum by ShL77.
2

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

subtotaling

treeview

  1. 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.

  1. 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.

  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.

3

Can you please elaborate on the style formatting settings in your 3rd suggestion?

4

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.