Hello,
I want to receive the worksheet names for random Excel sheets, the below
mentioned solution works for most excel sheet but with the most important one
I get too many excel sheets in this format

'WS1$' ''this one works
'WS1$'print_tables
'WS2$'Z_XX_XXX
'WS2$'Print_area

Where does the stuff after the $' come frome and how can I avoid this and
just receive the actual worksheet names ('WS1$') and at best in the order the
occur in the document and not alphabetically.

Thanks very much for your support and I hope i phrased the question in an
understandable fashion
Jörg


Code to get the Excel schema
string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=Book1.xls;Extended Properties=""Excel 8.0;HDR=YES;""";
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
connection.Open();
worksheets = connection.GetSchema("Tables");
}