MDB转excel工具源码下载

【实例截图】

【核心代码】

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Text.RegularExpressions;

namespace WindowsFormsApplication1
{
    public partial class MDB2XLS : Form
    {
        #region FIELDS
        public string[] filePathes { get; set; }
        public MDB2XLS()
        {
            InitializeComponent();
            filePathes = new string[3];
            filePathes[0] = AppDomain.CurrentDomain.BaseDirectory   "template\\模板.xls"; 
        }
        #endregion

        #region 瓦片按钮事件
        private void metroTileItem1_Click(object sender, EventArgs e)
        {
            //打开mdb
            OpenFileDialog of = new OpenFileDialog();
            of.Filter = "MDB|*.mdb";
            of.Multiselect = false;
            of.Title = "打开MDB文件";
            DialogResult dr = of.ShowDialog();
            if (dr == DialogResult.OK)
            {
                filePathes[0] = of.FileName;
            }
        }
        private void metroTileItem3_Click(object sender, EventArgs e)
        {
            //打开XML
            OpenFileDialog of = new OpenFileDialog();
            of.Filter = "配置|*.xml";
            of.Multiselect = false;
            of.Title = "打开配置文件";
            DialogResult dr = of.ShowDialog();
            if (dr == DialogResult.OK)
            {
                filePathes[1] = of.FileName;
            }
        }
        private void metroTileItem6_Click(object sender, EventArgs e)
        {
            FolderBrowserDialog fb = new FolderBrowserDialog();
            if (fb.ShowDialog() == DialogResult.OK)
            {
                filePathes[2] = fb.SelectedPath;
            }
        }
        private void metroTileItem2_Click(object sender, EventArgs e)
        {
            //运行
            BackgroundWorker bWork = new BackgroundWorker();
            bWork.WorkerReportsProgress = true;
            bWork.WorkerSupportsCancellation = true;
            bWork.DoWork  = new DoWorkEventHandler((ss, ee) =>
            {
                try
                {
                    this.Invoke(new Action(() => { metroTileItem2.Text = "开始执行.."; }));
                    DAL.MDB2EXCEL.Service.Facade.Run(filePathes, ss as BackgroundWorker);
                }
                catch (Exception eee)
                {
                    MessageBox.Show(eee.Message   "\n"   eee.StackTrace);
                }
            });
            bWork.RunWorkerCompleted  = new RunWorkerCompletedEventHandler((ss, ee) =>
            {
                this.Invoke(new Action(() => { metroTileItem2.Text = "操作结束.."; }));
            });
            bWork.ProgressChanged  = new ProgressChangedEventHandler((ss, ee) =>
            {
                this.Invoke(new Action(() => { metroTileItem2.Text = ee.ProgressPercentage.ToString(); }));
                this.Invoke(new Action(() => { lb_statue.Text = ee.UserState.ToString(); }));
            });
            bWork.RunWorkerAsync();
        }
        private void metroTileItem4_Click(object sender, EventArgs e)
        {
            //配置向导
            MDB2XLSConf form = new MDB2XLSConf();
            if (string.IsNullOrEmpty(filePathes[1]))
            {
                form.Show();
            }
            else
            {
                form.xmlPath = filePathes[1];
                form.Show();
            }
        }
        private void metroTileItem5_Click(object sender, EventArgs e)
        {
            //设置
            lb_statue.Text = "暂无设置选项";
        }
        #endregion

    }
}