C#-将一个文件夹（包含子文件夹）中的所有EXCEL表格转换成CSV格式文件

通过网盘分享的文件：ExcelToCsv.rar
链接: https://pan.baidu.com/s/1TtlJV2LzHMG9ac1Kx3xeAw?pwd=sky1 提取码: sky1

实现效果展示：

目标数据源 文件夹1

里面有一个1.xlsx，和demo文件夹，demo文件夹中存在一个2.xls Excel表格 如下图所示

操作

1、双击附件中的WindowsFormsApp1.exe

2、点击button按钮

3、选择Excel所在的文件夹目录 并确定

4、选择目标文件夹（CSV文件夹） 并确定

执行成功

点击查看代码

using Microsoft.Office.Interop.Excel;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Runtime.InteropServices;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using Excel = Microsoft.Office.Interop.Excel;

namespace WindowsFormsApp1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void btnConvert_Click(object sender, EventArgs e)
        {
            // 选择源文件夹
            using (FolderBrowserDialog folderBrowserDialog = new FolderBrowserDialog())
            {
                if (folderBrowserDialog.ShowDialog() == DialogResult.OK)
                {
                    string sourceFolderPath = folderBrowserDialog.SelectedPath;

                    // 选择目标文件夹
                    using (FolderBrowserDialog destinationFolderBrowserDialog = new FolderBrowserDialog())
                    {
                        if (destinationFolderBrowserDialog.ShowDialog() == DialogResult.OK)
                        {
                            string destinationFolderPath = destinationFolderBrowserDialog.SelectedPath;

                            // 转换文件
                            ConvertExcelFilesToCsv(sourceFolderPath, destinationFolderPath);

                            MessageBox.Show("转换完成！");
                        }
                    }
                }
            }

        }

        private void ConvertExcelFilesToCsv(string sourceFolderPath, string destinationFolderPath)
        {
            try
            {
                var sourceFolder = sourceFolderPath;
                var destinationFolder = destinationFolderPath;

                var excelApp = new Excel.Application();
                string[] files = Directory.GetFiles(sourceFolderPath, "*.xls*", SearchOption.AllDirectories);
                files = files.Where(s => !s.Contains("~$")).ToArray();
                foreach (var file in files)
                {
                    // 打开工作簿
                    Workbook workbook = excelApp.Workbooks.Open(file);

                    // 构建目标CSV文件路径
                    string csvFilePath = Path.Combine(destinationFolderPath, Path.GetFileNameWithoutExtension(file) + ".csv");

                    // 保存为CSV格式
                    workbook.SaveAs(csvFilePath, XlFileFormat.xlCSV, Type.Missing, Type.Missing, Type.Missing, Type.Missing, XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

                    // 关闭工作簿
                    workbook.Close(false);

                    // 释放COM对象（可选，但推荐）
                    Marshal.ReleaseComObject(workbook);
                }

                excelApp.Quit();
                System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp);
                MessageBox.Show("转换完成！");
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
        }


        private void Form1_Load(object sender, EventArgs e)
        {

        }

    }
}