Extracting Excel Report with multiple sheets from dataset in ASP.Net

Hi

I know to populate Excel file using htmltextwriter from dataset.

I want to know how to populate Excel multiple sheets using htmltextwriter from dataset based on condition

Please reply me as soon as possible

Thanks & Regards,

Revathi