protected void btnOk_Click(object sender, EventArgs e) //确定
{
filePath = File1.Value; //获取路径
DataTable dt = RecordScore(); 方法详细在下面
GridView1.DataMember = "[Sheet1$]";
GridView1.DataSource = dt;
GridView1.DataBind();
}
/// <summary>
/// 操作Excel
/// </summary>
/// <param name="scoreR"></param>
/// <returns></returns>
public DataTable RecordScore()
{
string sqlString = "select * from [Sheet1$]";
OleDBManager OleDB = new OleDBManager(filePath); //OleDBManager 是我写的类
return OleDB.LoadDataFromExcel(sqlString);
}
//OleDBManager 详细如下:public class OleDBManager
{
public static OleDbConnection conExcel;
public OleDBManager(string filePath)
{
string strOleConn = "Provider=Microsoft.Jet.OleDb.4.0;" + "data source = " + filePath + ";Extended Properties='Excel 8.0; HDR=YES; IMEX=1'";
try
{
conExcel = new OleDbConnection(strOleConn);
conExcel.Open();
}
catch(Exception ex)
{
}
} /// <summary>
/// 加载Excel(读取excel内容)
/// </summary>
/// <param name="sql"></param>
/// <returns>返回值是一个DataSet</returns>
public DataTable LoadDataFromExcel(string sql)
{
OleDbDataAdapter oleDr = new OleDbDataAdapter(sql, conExcel);
DataTable dt = new DataTable();
oleDr.Fill(dt);
return dt;
} /// <summary>
///
/// </summary>
/// <param name="filenameurl"></param>
/// <param name="table"></param>
/// <param name="sql"></param>
/// <returns></returns>
public DataSet ExcelDs(string filenameurl, string table)
{
OleDbDataAdapter OleDr = new OleDbDataAdapter();
DataSet ds = new DataSet();
OleDr.Fill(ds,table);
return ds;
}
}
我这样做显示是显示出来了!可是无法控制显示的格式,也就是不能原样输入。
望高手赐教,在这里我先谢谢各位了!谢谢!!
{
filePath = File1.Value; //获取路径
DataTable dt = RecordScore(); 方法详细在下面
GridView1.DataMember = "[Sheet1$]";
GridView1.DataSource = dt;
GridView1.DataBind();
}
/// <summary>
/// 操作Excel
/// </summary>
/// <param name="scoreR"></param>
/// <returns></returns>
public DataTable RecordScore()
{
string sqlString = "select * from [Sheet1$]";
OleDBManager OleDB = new OleDBManager(filePath); //OleDBManager 是我写的类
return OleDB.LoadDataFromExcel(sqlString);
}
//OleDBManager 详细如下:public class OleDBManager
{
public static OleDbConnection conExcel;
public OleDBManager(string filePath)
{
string strOleConn = "Provider=Microsoft.Jet.OleDb.4.0;" + "data source = " + filePath + ";Extended Properties='Excel 8.0; HDR=YES; IMEX=1'";
try
{
conExcel = new OleDbConnection(strOleConn);
conExcel.Open();
}
catch(Exception ex)
{
}
} /// <summary>
/// 加载Excel(读取excel内容)
/// </summary>
/// <param name="sql"></param>
/// <returns>返回值是一个DataSet</returns>
public DataTable LoadDataFromExcel(string sql)
{
OleDbDataAdapter oleDr = new OleDbDataAdapter(sql, conExcel);
DataTable dt = new DataTable();
oleDr.Fill(dt);
return dt;
} /// <summary>
///
/// </summary>
/// <param name="filenameurl"></param>
/// <param name="table"></param>
/// <param name="sql"></param>
/// <returns></returns>
public DataSet ExcelDs(string filenameurl, string table)
{
OleDbDataAdapter OleDr = new OleDbDataAdapter();
DataSet ds = new DataSet();
OleDr.Fill(ds,table);
return ds;
}
}
我这样做显示是显示出来了!可是无法控制显示的格式,也就是不能原样输入。
望高手赐教,在这里我先谢谢各位了!谢谢!!
用报表