We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Using excel template based approach to generate excel reports

Hi,
Does any of the Aspose product allows use of template base approach to generate excel reports.
Along with template base approach, we need foll. features also for excel reporting:
Data filter
Paning
Cell background color chnage depending on certain value
remove leading zeros from numbers except for the contact number present in the data at runtime
Adding new column at run time
Summation

Hi,
Thanks for considering Aspose.
Aspose.Cells is spreadsheet management library used to manipulate native excel files (xls, xlsx, xlsm, xltm, csv, txt, tab delimited, spreadsheetml, pdf etc.). Yes, you may manipulate existing excel files (template files), you can also create workbooks from the scratch. I think Aspose.Cells suits your needs very well.
For your queries:
Data filter
Aspose.Cells supports data filtering including auto filter data feature, see the following docs:
Aspose Documentation

Data Filtering
Class Libraries & REST APIs for the developers to manipulate & process Files from Word, Excel, PowerPoint, Visio, PDF, CAD & several other categories in Web, Desktop or Mobile apps. Develop & deploy on Windows, Linux, MacOS &…
Aspose Documentation

Data Validation
Class Libraries & REST APIs for the developers to manipulate & process Files from Word, Excel, PowerPoint, Visio, PDF, CAD & several other categories in Web, Desktop or Mobile apps. Develop & deploy on Windows, Linux, MacOS &…
Aspose Documentation

Data Sorting
Class Libraries & REST APIs for the developers to manipulate & process Files from Word, Excel, PowerPoint, Visio, PDF, CAD & several other categories in Web, Desktop or Mobile apps. Develop & deploy on Windows, Linux, MacOS &…
Paning
You mean Freezing / Unfreezing panes, yes, the component can do the task, see the doc:
Aspose Documentation

Worksheet Views
Class Libraries & REST APIs for the developers to manipulate & process Files from Word, Excel, PowerPoint, Visio, PDF, CAD & several other categories in Web, Desktop or Mobile apps. Develop & deploy on Windows, Linux, MacOS &…
Cell background color change depending on certain value
Aspose.Cells support conditional formattings to do your desired formattings upon change in a cell value, see the doc:
Aspose Documentation

Conditional Formatting
How to apply conditional formats in CSharp.
remove leading zeros from numbers except for the contact number present in the data at runtime
Yes, the component provides this feature, you may exclude or include the leading zeros with the number for your need, try the following sample code:

Workbook excel = new Workbook();
Worksheet worksheet = excel.Worksheets[0];
Cells cells = worksheet.Cells;
//If you want to display the leading zero. Cell is A1
cells[0, 0].PutValue("00032353");
//If you do not want to display the leading zero. Cell is B1
cells[0, 1].PutValue("00032353", true);
excel.Save("f:\\test\\myouttput.xls"); 

Adding new column at run time
Yes, Aspose.Cells support to add/remove columns at runtime for your need, see the following doc:
Aspose Documentation

Inserting and Deleting Rows and Columns
Class Libraries & REST APIs for the developers to manipulate & process Files from Word, Excel, PowerPoint, Visio, PDF, CAD & several other categories in Web, Desktop or Mobile apps. Develop & deploy on Windows, Linux, MacOS &…
Summation
Summation is a broad term, I am not sure which feature/features you are referring. For your info, Aspose.Cells supports pivot tables, smart markers, read, write, set and calculate formulas (it has its own formula calculation engine). See some doc links/sub links for reference:
Aspose Documentation

Pivot Tables
Create and format pivot tables of spreadsheet files.
Aspose Documentation

Smart Markers
Class Libraries & REST APIs for the developers to manipulate & process Files from Word, Excel, PowerPoint, Visio, PDF, CAD & several other categories in Web, Desktop or Mobile apps. Develop & deploy on Windows, Linux, MacOS &…
Aspose Documentation

Formulas
Gets, sets and calculates formulas of excel files.
Feel free to contact us any time if you need further info and we will be more than glad to help you.
Thank you.

Hi Amjad,
Thanks for your reply. It was indeed what we wanted for excel reporting.
I had one more queries regarding word:
I have a word template, certain values in the word template need to be changed at runtime like compnay name, tel. no., address etc. for sending this word file to diff. users.
Do aspose.word provides such facilities.
Thanks.

Also can you please give URL reference of using excel template for generating reports.
We are offshore development company base in India. We follow typical SDLC model for development.Which and how much licenses of excel and word do we need to buy for scenario below.
Development machine
Test server
UAT server and
Production server

Hi,
Yes, I think Aspose.Words does provide the features you inquired. I have also moved this thread to Aspose.Words forum, so, one of our developer will help you soon.
Have a good day!

Hi,
Also can you please give URL reference of using excel template for generating reports.
Well, you will use Workbook.Open() method to use an existing file (template file), manipulate it (for your need) and then save it / save it as. e.g…,

Workbook excel = new Workbook();
excel.Open("f:\\test\\MyFile.xls");
Worksheet worksheet = excel.Worksheets[0]; 
Cells cells = worksheet.Cells;
.............. 

We are offshore development company base in India. We follow typical SDLC model for development.Which and how much licenses of excel and word do we need to buy for scenario below…
For licensing, please post a query @: https://forum.aspose.com/c/purchase/6
Thank you.

Hi
Thank you for your interest in Aspose.Words. I think you should use mail merge feature to fill your Word template with data. Please see the following links for more information.
https://docs.aspose.com/words/net/types-of-mail-merge-operations/
Hope this helps.
Best regards.