[ xxxrugby @ 20.09.2006. 14:43 ] @
Pozz.
Imam problema s jedim Excelom.
ima puno redova. Pa bi bio bezvezan dio da ih prepisujem u nei .MDB ili XML ili tako nesto.
Vec se mucim 2 tjedna s Export Exlel to dataTable koj bi mogao pretrazivat te ispisat odredjen red.

Evo kako sam postavio

Code:

    BindingSource CPL= new BindingSource();

        private void excel_test()
        {

             string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=ExcelBase.xls;Extended Properties=""Excel 8.0;HDR=YES;""";
            DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OleDb");
            DbDataAdapter adapter = factory.CreateDataAdapter();

            DbCommand selectCommand = factory.CreateCommand();
            selectCommand.CommandText = "SELECT IME,PREZIME,BROJ,ULICA FROM [BASE$]";
            DbConnection connection = factory.CreateConnection();
            connection.ConnectionString = connectionString;
            selectCommand.Connection = connection;

            adapter.SelectCommand = selectCommand;

            DataSet cities = new DataSet();
            adapter.Fill(cities);

            CPL.DataSource = cities.Tables[0].DefaultView; ;

            DataGridView PrinterLu = new DataGridView();
            PrinterLu.DataSource = CPL;
            CPL.Filter = "IP like '%10.75.8.202%'";
                             //ERROR koj nije bitan  MessageBox.Show(cities.Tables["BROJ"].Select("9999999").ToString());
        }


Uglavnom. Trebao bi iscitat i protrazit Sheet te ispisat taj ROW al po Tabelama.