Calling tabs in an Excel spreadsheet (C# in Visual Studio)

To select a tab in the SAME Excel worksheet, this seems to work for me in C# :
Make sure you Include References:
Add the Excel Interop Reference Library in your project , AND also include the statement    .......using Microsoft.Office.Interop.Excel;
Define Excel Object :
Microsoft.Office.Interop.Excel._Application ExcelApp = new Microsoft.Office.Interop.Excel.Application();
Open WorkBook and Call your Tab:
string myPath = @"C:\Excel.xls";
ExcelApp.Workbooks.Open(myPath);
ExcelApp.Worksheets["MyTAB"].Select();

hi friend,

I have attach the project download it and see how it works.

if you have Excel-07 format of Sheets then you have to change the ConnectionString to below:

  string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;" +
              @"Data Source=" + Server.MapPath("~/App_Data/PhraseContentFiles/" + filename + "") + ";" +
              "Extended Properties=\"Excel 12.0;HDR=YES\";";

All the Best.

Please don't forget to mark the answer.

ok thanks, I would greatly appreciate suggestions
 
J

hi friend,
i can help you but you have to wait for some time i have done this before accessing sheets of excel seperately and modifying column.
wait for some time i'll come up with a solution for you.