C# Merge Excel

dxm809

于 2021-07-01 10:59:23 发布

阅读量275

点赞数

分类专栏： C#

本文链接：https://blog.csdn.net/dxm809/article/details/118381741

版权

C# 专栏收录该内容

369 篇文章 10 订阅

订阅专栏

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Reflection;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

using Excel = Microsoft.Office.Interop.Excel;


namespace MergeDemo
{
    public partial class MainForm : Form
    {
        public MainForm()
        {
            InitializeComponent();
        }

        private void btnBrowse1_Click(object sender, EventArgs e)
        {
            FolderBrowserDialog dlg = new FolderBrowserDialog();
            dlg.SelectedPath = "D:\\";

            if (dlg.ShowDialog() == DialogResult.OK)
            {
                txtSrcFolder.Text = dlg.SelectedPath;
            }
        }

        private void btnBrowse2_Click(object sender, EventArgs e)
        {
            FolderBrowserDialog dlg = new FolderBrowserDialog();
            dlg.SelectedPath = "D:\\";

            if (dlg.ShowDialog() == DialogResult.OK)
            {
                txtDstFolder.Text = dlg.SelectedPath;
            }
        }

        private void btnMerge_Click(object sender, EventArgs e)
        {

            if (txtSrcFolder.Text.Trim()=="")
            {
                MessageBox.Show("Please select source folder first");
                return;
            }

            if (txtDstFolder.Text.Trim() == "")
            {
                MessageBox.Show("Please select destination folder first");
                return;
            }
            string[] excelFiles = Directory.GetFiles(txtSrcFolder.Text, "*.xls");
            if (excelFiles.Length<=1)
            {
                MessageBox.Show("Can not find enough excel files in source folder");
                return;
            }

            Excel.Application excel = null;
            try
            {
                //int modelSheetHeadRows = 1;
                excel = new Excel.Application();
                excel.DisplayAlerts = false;

                

                List<Excel.Workbook> workbookList = new List<Excel.Workbook>();

                for (int i = 0; i < excelFiles.Length; i++)
                {
                    Excel.Workbook tmpWorkBook = excel.Workbooks.Open(excelFiles[i], Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing
                              , Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
                    Excel.Worksheet worksheet = tmpWorkBook.Worksheets[0];
                    for (int col = 0; col < 20; col++)
                    {
                        Excel.Range range = (Excel.Range)worksheet.Cells[1, col];
                        string val = range.Value==null?"":range.Text.ToString();
                    }
                    tmpWorkBook.Close();
                   
                }

                excel.Quit();
                MessageBox.Show("Merge successful");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

        }
    }
}