Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2.1 - .NET Automation
I have an application that needs to retrieve the name of the first
Worksheet in an Excel Workbook. This works great, unless an older excel file is used with this routine that did not support multiple sheets (i.e. Excel 2.1). What is the work around to retrieve the sheet name? Here is some code: private string GetFirstSheetName(sExcelFile) { .... oExcel = new Excel.ApplicationClass(); oBooks = oExcel.Workbooks; oBook = oBooks.Open(sExcelFile,Type.Missing,Type.Missing,T ype.Missing,Type.Missing,Type.Missing,Type.Missing ,Type.Missing,Type.Missing,Type.Missing,Type.Missi ng,Type.Missing,Type.Missing,Type.Missing,Type.Mis sing); oSheets = oBook.Worksheets; oSheet = (Excel.Worksheet)oSheets[1]; return oSheet.Name; } If sExcelFile is a 2.1 Excel file the name of the file gets returned for some reason. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Automation | Excel Programming | |||
Excel automation | Excel Programming | |||
Excel automation | Excel Programming | |||
Ole automation with Excel 10 from Vb.net | Excel Programming | |||
Excel Com Automation | Excel Programming |