Free Support Forum - aspose.com

Urgent help requested - Import from Excel and/or create report?

Aspose.Cells Product Family
#1

Hi

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.

#2

Hi,

Thanks for considering Aspose

Well, you may import / export excel files, pleae check: http://www.aspose.com/Wiki/default.aspx/Aspose.Grid/OpeningWebExcelFile.html and http://www.aspose.com/Wiki/default.aspx/Aspose.Grid/SavingWebExcelFile.html . But, currently, we do not support to import a pivot table report to GridWeb control, although you may create pivot tables using the APIs of Aspose.Grid.Web control. Please check the source code of PivotTable Report in our featured demos: http://www.aspose.com/Products/Aspose.Grid/Demos/

Well, I have checked your attached Example.xls file. I think you may easily create those reports.

For the Quarterly Totals report, how would I insert the quarterly totals rows?..........

Yes you may do it. For inserting rows/columns, please check: http://www.aspose.com/Wiki/default.aspx/Aspose.Grid/InsertRowsColumns.html

And, since cell C3 is a merged cell based on C3:E3. For merging/unmerging cells please check: http://www.aspose.com/Wiki/default.aspx/Aspose.Grid/MergingAndUnmergingCells.html

and for setting formula, please check: http://www.aspose.com/Wiki/default.aspx/Aspose.Grid/AddingFormulasToWebCells.html

and also you may check Formula Demos in our featured demos

Finally, the Full Report is what I need to create. How would I create the final 2 rows.......

Yes, for numbers formattings cells, please check: http://www.aspose.com/Wiki/default.aspx/Aspose.Grid/FormattingCells.html#NumberFormat

and also check the Data Format Demos in our featured demos.

Note: We recommend you to check all our featured demos first. The featured demos are automatically installed when you use Control's MSI installer.

Thank you.

#3

Thank you very much Amjad, that is all great news!

I will do some more testing but expect a purchase order very soon.

Many thanks.