knowing the excel sheet name

[rfazendeiro]

Hi to all,

Im currently loading an excel to a DataSet and show the information in a Datadrig. Every month a new excel with the same format arrives and my application will process the information.

My problem is that the name of the excel sheets dont always come with the same name, and there is no pattern to those names. Is there anyway for me to know the sheet name before i make the select ??

I have this simple code to load the Excel file to a datagrid

private void btnExcel_Click(object sender, System.EventArgs e)
{
	try
	{
	        System.Data.DataSet DS;
		System.Data.OleDb.OleDbDataAdapter MyCommand;
		System.Data.OleDb.OleDbConnection MyConnection;
		MyConnection = new System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0; " + "data source=C:\\Book1.xls; " + "Extended Properties=Excel 8.0;");
		MyCommand = new System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]", MyConnection);

		DS = new System.Data.DataSet();
		MyCommand.Fill(DS);
		MyConnection.Close();

		this.dgExcel.DataSource = DS;
	}
	catch(Exception ex)
	{
		MessageBox.Show(ex.ToString());
	}
		
}

 

[SonicBoomAu]

Couldnt you use a Open File Dialog box to select the file?

Sorry Didnt read the question properly. Couldnt you use the active sheet instead of sheet1?

 

[rfazendeiro]

And how do i do that?? what i do is just open a ODBC. how can i get the active sheet?

 

[herilane]

Worksheets in an Excel workbook are equivalent to tables in a database.
Have a look here for examples of retrieving table information.

 

[rfazendeiro]

GREAT!!! that worked fine...thx for the help