How to Add two DataTable data into one workSheet?

Question

I want to add 2 different table data into single excel Worksheet using asp.net . like i added one image with this post. please give me any idea how to achieve this.

Lisa White · Answer

An alternative way is to export it to 2 worksheets and merge them into one. http://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Document-Operation/How-to-merge-several-Excel-worksheets-into-a-single-Excel-worksheet.html

Ankita Yadav · Answer

thanks do you have any sample project? My code is Like this shall we modified it for getting desire result

Upendra Pratap Shahi · Answer

Use spreadsheet gear to this type. In this you can achieve your goal easily.