We are having one simple problem that we are suing evalution version of your Excel componenet and when ever i try to get data from it by default it opens sheet2 with your advertisement on it how i can get dafault sheet 1 for viewing and getting data or how i can swap the data
This is not a problem but an evaluation warning. If you use the evaluation copy, MS Excel always shows the license sheet of the generated file. When you purchase the license, this license sheet won’t show any more. And you can use Worksheets.ActiveSheetIndex property to set the first active worksheet.