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)
{

}

}
}