读取Excel 文件 转换为（DataSet）DataTable,在转化成.xml文件

 

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.OleDb;

using Lodge.ToolKit.Common;

 

public partial class GameInfo_GameXml : System.Web.UI.Page

{

 

    /// <summary>

    /// 读取Excel 文件 转换为（DataSet）DataTable,在转化成.xml文件

    /// </summary>

    /// <param name="sender"></param>

    /// <param name="e"></param>

    protected void Page_Load(object sender, EventArgs e)

    {

        string fileName = "daoju";

        DataTable dtResult = new DataTable(); 

        try

        {

            string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~/App_Data/")+fileName + ".xls;Extended Properties='Excel 8.0;HDR=No;IMEX=1'";

            using (OleDbConnection connect = new OleDbConnection(strConn))

            {

                OleDbDataAdapter command = new OleDbDataAdapter("select F1 as imgName,F3 as name,F4 as intro from[Sheet1$]", connect);

                DataSet ds = new DataSet();

                command.Fill(ds);

                if (ds.Tables.Count > 0)

                    dtResult = ds.Tables[0];

            } 

        }

        catch (Exception ex)

        {

            LogUtility.Add(ex);                                //web.config 配置异常处理

        }

        dtResult.TableName = "Item";

        dtResult.DataSet.DataSetName = "ItemList";

        dtResult.WriteXml(Server.MapPath("~/App_Data/")+fileName+".xml");

    }

}