Thanks for considering Aspose.
Sure! the grid can handle large files. Some of our users use GridWeb to work with larger files. We always try to optimize the performance with every new release of the control. Which version of Aspose.Grid.Web you are using, kindly try the latest version: http://www.aspose.com/Community/files/53/aspose.grid/default.aspx
The large data processing is a great challenge in the web scenario. But there are still some ways to negotiate it. Do you just want to display the data into the grid, and you don't want to modify the data, you may disable the grid's session mode. e.g.., GridWeb1.EnableSession = false;
GridWeb1.EnableViewState = false; if will certainly enhance your performance.
Related formatting cells, are you individually sets the styles of each cells, there is a way to reduce the number of the instances in this regard. If you sheet contains large number of cells that have the same style, you may build a style object and assign it to all the cells.
Aspose.GridWeb.TableItemStyle style = new Aspose.Grid.Web.TableItemStyle();
// set the style's values
style.Color = ...
// in a loop
cell.Style = style;
If you are loading a large file, you may use grid's paging feature, it will certainly reduce loading data time and can enhance the performance
Do you save the grid's session data in sql or other data source? For large amount of data, that will be hign cost, for the grid will serialize and deserialize the data upon each request.
And, do you find the formula calculations take lots of time? if so, could you give us more details how do you set and which formulas you are applying.
We appreciate if you could create a sample test project to show the issue, zip it and post it here. We will check it soon. And we will continue our work to enhance the component related performance.