Hi all!

I am trying to generate an Excel file using data from xml and formatting it using xsl.

The generic xsl for getting all data from xml and rendering excel xml is attached as excel.zip

I am not able to figure out how to filter data in two different sheets...

For example I have an xml file having data from orders and order details table of northwind db. I want the data from order table in a different sheet and order details table in a different sheet.

I dont know i am missing something somewhere, Attaching the xml file for reference, pls help me in getting the data in two different sheets.

Thanks

Regards

Mustafa.