I have been testing Aspose.Grid and so far I'm very pleased with the results (I've been using Aspose.Excel & Aspose.Cells for a few years now). Before I go ahead with any purchase I need to know if my requirements can be met.
Firstly, is it possible to simply import a worksheet from an Excel file and display the worksheet? I have a complex pivot table report (containing forumlas) that I need to display in web format, so is it possible to simply import the relevant worksheet form my Excel file and display it to the user? I have seen a thread linking to Aspose.Excel.Web.Viewer but that product is no longer for sale. Is there something else that does this?
If that can be done - great! But, I also need to know if the reports in my attached file can be created using Aspose.Grid.
I have no problem creating the Simple report using Aspose.Grid.
For the Quarterly Totals report, how would I insert the quarterly totals rows? Would this be done after binding the grid?
Finally, the Full Report is what I need to create. How would I create the final 2 rows where comparison percentages are calculated?
Thanks in advance.