Creating multiple tabs from a template

GroupDocs.Assembly Product Family
1

Hi. We currently use the dotnet version of the groupdocs assembly software. We also use another report generator next to groupdocs, however if possible we would like to just use groupdocs to create reports.

There’s however the following case which we have not been able to solve:
Attached is a template, a datasource and a finished report. At the moment our other reportgenerator creates a copy of the template tab in excel for every object that it finds in the datasource that meets certain criteria (in this same, ‘sample’ objects with a matrix code for water). After creating the tabs the object id is printed on the first cell. Then groupdocs fills in every created tab with the tags you see in the template.

My question is, would it be possible to create tablads like this within groupdocs?
by using a foreach loop on a certain object for example?

Groupdocs_template.zip (842.5 KB)

If you need any additional information we’d happily answer them.

2

@TerraIndexService
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): ASSEMBLYNET-230

You can obtain Paid Support services if you need support on a priority basis, along with the direct access to our Paid Support management team.

3

@TerraIndexService

I’m sorry, but the ability to dynamically add worksheets into a workbook is not available in GroupDocs.Assembly and it is unlikely that this feature will be added in the near future.
However, if you intent is to switch to GroupDocs, then we would advise you to take the following steps:

  • Create a single-worksheet template workbook
  • Use the template to produce several workbooks using GroupDocs.Assembly
  • Combine the workbooks into one using GroupDocs.Merger. Details on Merging Excel files can be found at Merge Excel spreadsheets