To Export excel data to gridview,I got the error message like this
The Microsoft Office Access database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path name correctly.
MyCommand = new OleDbDataAdapter("select * from [Sheet1$]", MyConnection);
DtSet = new DataSet();
Thanks in advance