Naprosto funkční kód:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OleDb;
using System.Data;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
            "Data Source=" + Server.MapPath("data.xls") + ";" +
            "Extended Properties=Excel 8.0;";

        OleDbConnection objConn = new OleDbConnection(sConnectionString);

        
        objConn.Open();
		OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM [List1$A1:B7]", objConn);
		object nazev = objCmdSelect.ExecuteScalar();
        OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();

        objAdapter1.SelectCommand = objCmdSelect;

        DataSet objDataset1 = new DataSet();

        objAdapter1.Fill(objDataset1, "XLData");

        GridView1.DataSource = objDataset1.Tables[0].DefaultView;
        GridView1.DataBind();

        objConn.Close();
    }
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
}

Jak ho tedy mám rozchodit zde?

    public class vyber
    {
        public static string getText()
        {
            String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                        "Data Source=" + Server.MapPath("data.xls") + ";" +
                        "Extended Properties=Excel 8.0;";

            OleDbConnection objConn = new OleDbConnection(sConnectionString);


            objConn.Open();
            OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM [List1$A1:B7]", objConn);
            object nazev = objCmdSelect.ExecuteScalar();
            OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();

            objAdapter1.SelectCommand = objCmdSelect;

            DataSet objDataset1 = new DataSet();

            objAdapter1.Fill(objDataset1, "XLData");

            GridView1.DataSource = objDataset1.Tables[0].DefaultView;
            GridView1.DataBind();

            objConn.Close();

        }
    }

Respoktive co returnovat? a jak to pak vyčíst do togo GridViewu? Nepředpokládám že to lze v tom classu jak to tu mám na ukázku