用Excel.Application打开Excel文件和SaveAs的问题 加上Excel.Application.DisplayAlerts = False這句 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 自己搞定了,代码如下: private void ExcelFileToCSVFile(string ExcelFile, string CSVFile) { object missing = System.Reflection.Missing.Value; Excel.Application excel = new Excel.ApplicationClass(); excel.Application.Visible = false; excel.Application.Workbooks.Open(ExcelFile, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing); long CSVFileFormatIndex = 6; // TextFileFormatIndex = 3 excel.Application.ActiveWorkbook.SaveAs(CSVFile, CSVFileFormatIndex, missing, missing, missing, missing, Excel.XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing); excel.Application.ActiveWorkbook.Close(false, missing, false); excel.Application.Quit(); excel = null; }不过还有一个问题,就是执行之后任务栏有Excel.exe仍在运行,没有关掉.解决了立即给分. excel.Workbooks.Close(); excel.Quit(); 自己搞定,代码如下: private void ExcelFileToCSVFile(string ExcelFile, string CSVFile) { object missing = System.Reflection.Missing.Value; Excel.Application excel = new Excel.Application(); excel.Visible = false; Excel.Workbooks oBooks = excel.Workbooks; oBooks.Open(ExcelFile, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing); Excel.Workbook oBook = excel.ActiveWorkbook; oBook.SaveAs(CSVFile, XlFileFormat.xlCSV, missing, missing, missing, missing, Excel.XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing); excel.DisplayAlerts = false; oBook.Close(false, missing, false); System.Runtime.InteropServices.Marshal.ReleaseComObject(oBook); oBook = null; System.Runtime.InteropServices.Marshal.ReleaseComObject(oBooks); oBooks = null; excel.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComObject(excel); excel = null; System.GC.Collect(); }留言者有分. 如何重写一个Form窗体,然后其它窗体继承这个窗体。 在线客服怎么做啊,可以即使通讯的 请教一个treeview无刷新遍历以及获取选中值 字符串转化为数字做异或运算,谁帮忙看看,谢谢 C# 加密解密 想要对C#了解的更透彻一点,网上有哪些视频意义让我参考啊?? Ftp路径中文问题 如何消除数据库中字段的数据空格 高手请进 wpf 动画做的弹窗有时候出来有时候不出来 cmpp???? UtilityLibrary,你会用吗?(回帖即有分!!!)
private void ExcelFileToCSVFile(string ExcelFile, string CSVFile)
{
object missing = System.Reflection.Missing.Value;
Excel.Application excel = new Excel.ApplicationClass();
excel.Application.Visible = false;
excel.Application.Workbooks.Open(ExcelFile, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
long CSVFileFormatIndex = 6; // TextFileFormatIndex = 3
excel.Application.ActiveWorkbook.SaveAs(CSVFile, CSVFileFormatIndex, missing, missing, missing, missing, Excel.XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing);
excel.Application.ActiveWorkbook.Close(false, missing, false);
excel.Application.Quit();
excel = null;
}
不过还有一个问题,就是执行之后任务栏有Excel.exe仍在运行,没有关掉.
解决了立即给分.
excel.Quit();
private void ExcelFileToCSVFile(string ExcelFile, string CSVFile)
{
object missing = System.Reflection.Missing.Value;
Excel.Application excel = new Excel.Application();
excel.Visible = false;
Excel.Workbooks oBooks = excel.Workbooks;
oBooks.Open(ExcelFile, missing, missing, missing, missing, missing, missing, missing,
missing, missing, missing, missing, missing); Excel.Workbook oBook = excel.ActiveWorkbook;
oBook.SaveAs(CSVFile, XlFileFormat.xlCSV, missing, missing, missing, missing,
Excel.XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing);
excel.DisplayAlerts = false;
oBook.Close(false, missing, false);
System.Runtime.InteropServices.Marshal.ReleaseComObject(oBook);
oBook = null; System.Runtime.InteropServices.Marshal.ReleaseComObject(oBooks);
oBooks = null; excel.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(excel);
excel = null;
System.GC.Collect();
}留言者有分.