需要添加引用:Microsoft.Office.Interop.Excel
using Excel = Microsoft.Office.Interop.Excel;
调用:SaveAsExcel(@"D:\TEST.xls",@"D:\TEST.CSV");
/// <summary>
/// 将Excel转换成CSV
/// </summary>
/// <param name="excelFileName">Excel路径</param>
/// <param name="csvFileName">CSV要保存的路径</param>
public static void SaveAsExcel(string excelFileName, string csvFileName)
{
//定义一个COM中空类型的对象(作用类似于大家所熟悉的null)
object missing = System.Reflection.Missing.Value;
//创建Excel应用程序对象(会帮我们在启动Excel进程)
Excel.Application app = new Excel.ApplicationClass();
Excel.Workbook wb = app.Workbooks.Open(excelFileName, 0, false, 5, missing, missing, true, 1, missing, fals