i just made two function related to excel .
1. Merging all sheet of excel as tables in single Dataset
2. Exporting a dataset to Excel File .(all the tables of dataset as sheets)
i just wanted to share.. i hope it becomes helpful to you.
ps: Dont forget to add references to
Imports Microsoft.Office.Interop.Excel Imports System.Data.OleDb