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

Free Support Forum - aspose.com

Dynamic sheets based on dataset

I have the following template with smart markers:
ReferenceDoclet_withSingleCell.zip (22 Bytes)
The datasource for this template will be the below dataset. My requirement is that each country be displayed in a separate tab. How do i achieve this with smart markers?

Country | City | Count


France | Paris | 10
France | Lyon | 20
Germany | Berlin | 15
Germany | Munich | 30
Italy | Rome | 30
Italy | Venice | 30

@nikhilpinto,

Thanks for the details.

Probably you forgot to include the Excel file in the zipped archive. Please note, this is not possible in Smart Markers or the feature is not supported. You may do:
Once you have all the data filled in the first worksheet (which has smart markers), you may copy data by yourselves using your own code. You may copy respective rows (first use use find/search options to search the individual country country cells rows) to insert the data onto different sheets accordingly.

Book1.zip (8.1 KB)
Reuploaded the zip.
I did not get this: “Please note, this is possible in Smart Markers or the feature is not supported”

@nikhilpinto,

Sorry, I corrected it in my previous reply. I meant this is not possible or this is not supported.