How to Add two DataTable data into one workSheet?

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 Yadav10y ago

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

Upendra Pratap Shahi10y ago

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