Excel入~~想Excel的哪行哪列始~~高手9999
string sConnectionString =@ " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source= ' "+openname+ " ';Extended Properties=Excel 8.0 ";
OleDbConnection oleDbConnection = new OleDbConnection(sConnectionString);
try
{
oleDbConnection.Open();
//取excel表
DataTable dataTable = oleDbConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
//利用SQL句取出Excel文件面的
string query = "SELECT 月份,品,位成本,分代,分名,[工(USD)],率,[位工(NTD)] FROM [BOM及工$] ";
DataSet dataset = new DataSet();

OleDbDataAdapter oleAdapter = new OleDbDataAdapter(query, sConnectionString);
oleAdapter.Fill(dataset);
oleAdapter.Fill(dataTable);//查看行
this.gridControl1.DataSource=dataset.Tables[0].DefaultView;

以上能入到DataGrid面了``
但是excel的第一行第一列始的`包括了表我Excel上面的空白``
在我想``excel的第行第列才始```
高手指教````

[解决办法]
你可以用DataTable 进行筛选
DataRow[] rows = dataTable.Select( "月份!= ' ' ");
dataTable.Rows.Clear();
for(int i=0;i <rows.Length;i++)
{
dataTable.Rows.Add(rows[i]);
}