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:

  • 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.

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 @: http://www.aspose.com/community/forums/aspose.purchase/220/showforum.aspx
Thank you.

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.

http://www.aspose.com/documentation/file-format-components/aspose.words-for-.net-and-java/report-generation-overview.html

http://www.aspose.com/documentation/file-format-components/aspose.words-for-.net-and-java/simple-mail-merge-explained.html

Hope this helps.

Best regards.