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

If sExcelFile is a 2.1 Excel file the name of the file gets returned for
some reason.

The reason is that prior to Excel 5 worksheets did not have names beyond
their file names.

--
Jim
wrote in message
oups.com...
|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
|

Any idea on how I could access a sheet in Excel 2.1 using OLEDB?

Most queries look like this with more recent version of excel:

SELECT * FROM [Sheet Name$]

What happens when there are no sheets as in the case of older excel
versions?

Sorry, out of my depth here. Maybe the file name would work? (Q - Would a
DB driver that works with XL97+ files work with older Excel file formats?)

--
Jim
wrote in message
oups.com...
| Any idea on how I could access a sheet in Excel 2.1 using OLEDB?
|
| Most queries look like this with more recent version of excel:
|
| SELECT * FROM [Sheet Name$]
|
| What happens when there are no sheets as in the case of older excel
| versions?
|