Spaltennamen eines Arbeitsblatts einer Excel-Datei auslesen

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

private string[] GetColumnNames(string excelFile, string worksheetName)
{
	// Namen der Excel-Arbeitsblätter enden immer mit $ ("Tabelle1$")
	if (!worksheetName.EndsWith("$"))
	{
		worksheetName = worksheetName + "$";
	}

	OleDbConnection con = new OleDbConnection();
	con.ConnectionString = "Data Source=" + excelFile + 
		";Provider=Microsoft.Jet.OLEDB.4.0" +
		";Extended Properties=Excel 8.0";
	
	con.Open();
	
	DataTable tab = con.GetOleDbSchemaTable(
		OleDbSchemaGuid.Columns, 
		new object[] {null, null, worksheetName, null});
	
	con.Close();

	string[] columnNames = new string[tab.Rows.Count];

	for (int i = 0; i < tab.Rows.Count; i++)
	{
		columnNames[i] = tab.Rows[i]["Column_Name"].ToString();
	}

	return columnNames;
}