Export more then one Excel sheet

Hi ,

Is that possible to Export more then one excel files at a single click of a button.

Thanks

Monisha.

Hi Monisha,

I am not very sure about your need. Could you elaborate it and give us some more details about your scenario and requirement. Do you want to Save As multiple copies of a Workbook to generate multiple excel files. For a WinForm solution, there is no problem, you may write your own code to achive your goal. For a web solution (ASP.NET), do you mention the download dialog box's button. Well, by default, IE will open the stream in the response object based on the header. So, normally there is no direct way for this. I think you have to control the post back times and try to take the button click in a loop.

Thank you.