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:
Paning
You mean Freezing / Unfreezing panes, yes, the component can do the task, see the doc:
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:
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:
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:
Feel free to contact us any time if you need further info and we will be more than glad to help you.
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.
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.
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.
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.......
Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
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.