how to get the sheet name from excel?

Question

hi how to get the sheet name from excel.. for import to db.

George eric · Answer

Hi Since you mentioned to get the worksheet name. So below is my part of codes see: Excel.Application app = new Excel.Application(); Excel.Workbook wbk = null; string xlsPath=where is your Excel file; wbk = app.Workbooks.Open(xlsPath missing missing missing missing missing missing missing missing missing missing missing missing missing missing); //Get the reference of second worksheet Excel.Worksheet worksheet = (Excel.Worksheet)sheets.get_Item(1); // Then you Get the name of worksheet. string strWorksheetName = worksheet.Name; Also there is an C# Excel article for fear that my reply can't help you out.