DataSource of GridView is Excel
前台:
<div>
<table style="border-right: medium none; border-top: medium none; border-left: medium none;
border-bottom: medium none" class="BillTable" cellspacing="0" cellpadding="0"
width="100%">
<caption style="border-right: medium none; border-top: medium none; border-left: medium none;
border-bottom: medium none">
<br />
<asp:Label ID="kk" runat="server" Text=" 江苏公司网络部-核心网专业室员工“卓越与进步”表扬档案记录榜" Font-Bold="true"
Font-Size="25px"></asp:Label>
</caption>
<tbody>
</tbody>
</table>
<asp:SGridView ID="sgvPerson" runat="server" PageSize="5" AllowPaging="true" OnPageIndexChanging="sgvPerson_PageIndexChanging">
</asp:SGridView>
</div>
后台:
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("http://www.cnblogs.com/AttacheFile/核心网室员工《卓越与进步》表扬档案记录榜080927.xls") + "; Extended Properties=Excel 8.0;";
OleDbConnection objConn = new OleDbConnection(strConn);
objConn.Open();
OleDbCommand objCmd = new OleDbCommand("select * from [sheet1$]", objConn);
OleDbDataAdapter objAdapter = new OleDbDataAdapter();
objAdapter.SelectCommand = objCmd;
DataSet ds = new DataSet();
objAdapter.Fill(ds, "XLSData");
sgvPerson.DataSource = ds.Tables[0].DefaultView;
sgvPerson.DataBind();
GridViewDS = ds;
objConn.Close();
sgvPerson.Columns[8].ItemStyle.Wrap = false;
sgvPerson.Columns[2].ItemStyle.Wrap = false;
sgvPerson.Columns[3].ItemStyle.Wrap = false;
sgvPerson.Columns[4].ItemStyle.Wrap = false;
}
}


浙公网安备 33010602011771号