I starting to develop with Aspose.Grid, loading an xls file into the grid for manipulation etc. Though I am getting stuck on a couple of problems and wondered whether there was solution:
- My file is 1.9Mb, rendering time I feel could be a problem. Is it possible to force the client to only render the sheet I am looking at?
- The Excel file includes autofiltering is this able to be handled directly in the grid or do I need to re-model it to create my own pivot tables etc using the grid functions?