ExportExcel/ExcelToData.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Windows.Forms;
using Common;

/// <summary>
/// 将Excel导入函数
/// </summary>
/// <remarks></remarks>
namespace ExportExcel
{
    public class ExcelToData
    {
        /// <summary>
        /// 将excel导入到DataTable
        /// </summary>
        /// <remarks></remarks>
        public static DataTable toData()
        {
            DataTable dtToData = null;
            try
            {
                OpenFileDialog Fd = new OpenFileDialog();
                Fd.Filter = "*.xls| *.xls";
                if (Fd.ShowDialog() == DialogResult.OK)
                {
                    dtToData = toData(Fd.FileName);
                }

                return dtToData;
            }
            catch (Exception ex)
            {
                Common.Debug.myMsg(ex.Message, "");
                return dtToData;
            }
        }

        private static DataTable toData(string Path)
        {
            try
            {
                string str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Path + ";Extended Properties=Excel 8.0";
                System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(str);
                System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter();
                System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand();
                cmd.Connection = conn;
                cmd.CommandText = "select * from [Sheet1$]";
                da.SelectCommand = cmd;
                DataTable dt = new DataTable();
                da.Fill(dt);
                return dt;
            }
            catch (Exception ex)
            {
                Common.Debug.myMsg(ex.Message, "");
                return null;
            }
        }
    }