首页 / C# / C# .csv文件转为Excel格式；Excel格式转换为.csv

C# .csv文件转为Excel格式；Excel格式转换为.csv

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了C# .csv文件转为Excel格式；Excel格式转换为.csv，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含4216字，纯文字阅读大概需要7分钟。

内容图文

            using
             System;

            using
             System.Diagnostics;

            using
             System.IO;

            using
             System.Reflection;

            using
             System.Windows.Forms;

            using Excel=Microsoft.Office.Interop.Excel;
namespace WinFromAPP
{
    publicpartialclass Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        ///<summary>/// 将Csv文件转换为XLS文件
        ///</summary>///<param name="FilePath">文件全路路径</param>

///<returns>返回转换后的Xls文件名</returns>publicstaticstring CSVSaveasXLS(string FilePath)
        {
            QuertExcel();
            string _NewFilePath = "";

            Excel.Application excelApplication;
            Excel.Workbooks excelWorkBooks = null;
            Excel.Workbook excelWorkBook = null;
            Excel.Worksheet excelWorkSheet = null;

            try
            {
                excelApplication = new Excel.ApplicationClass();
                excelWorkBooks = excelApplication.Workbooks;
                excelWorkBook = ((Excel.Workbook)excelWorkBooks.Open(FilePath, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value));
                excelWorkSheet = (Excel.Worksheet)excelWorkBook.Worksheets[1];
                excelApplication.Visible = false;
                excelApplication.DisplayAlerts = false;
                _NewFilePath = FilePath.Replace(".csv", ".xls");
                excelWorkBook.SaveAs(_NewFilePath, Excel.XlFileFormat.xlAddIn, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Excel.XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
                excelWorkBook.Close();
                QuertExcel();
                // ExcelFormatHelper.DeleteFile(FilePath);
                //可以不用杀掉进程QuertExcel();

                GC.Collect(System.GC.GetGeneration(excelWorkSheet));
                GC.Collect(System.GC.GetGeneration(excelWorkBook));
                GC.Collect(System.GC.GetGeneration(excelApplication));

            }
            catch (Exception exc)
            {
                thrownew Exception(exc.Message);
            }

            finally
            {
                GC.Collect();
            }

            return _NewFilePath;
        }



        ///<summary>/// 将xls文件转换为csv文件
        ///</summary>///<param name="FilePath">文件全路路径</param>///<returns>返回转换后的csv文件名</returns>publicstaticstring XLSSavesaCSV(string FilePath)
        {
            QuertExcel();
            string _NewFilePath = "";

            Excel.Application excelApplication;
            Excel.Workbooks excelWorkBooks = null;
            Excel.Workbook excelWorkBook = null;
            Excel.Worksheet excelWorkSheet = null;

            try
            {
                excelApplication = new Excel.ApplicationClass();
                excelWorkBooks = excelApplication.Workbooks;
                excelWorkBook = ((Excel.Workbook)excelWorkBooks.Open(FilePath, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value));
                excelWorkSheet = (Excel.Worksheet)excelWorkBook.Worksheets[1];
                excelApplication.Visible = false;
                excelApplication.DisplayAlerts = false;
                _NewFilePath = FilePath.Replace(".xls", ".csv");

                // excelWorkSheet._SaveAs(FilePath, Excel.XlFileFormat.xlCSVWindows, Missing.Value, Missing.Value, Missing.Value,Missing.Value,Missing.Value, Missing.Value, Missing.Value);                excelWorkBook.SaveAs(_NewFilePath, Excel.XlFileFormat.xlCSV, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
                QuertExcel();
                //ExcelFormatHelper.DeleteFile(FilePath);            }
            catch (Exception exc)
            {
                thrownew Exception(exc.Message);
            }
            return _NewFilePath;
        }



        ///<summary>/// 删除一个指定的文件
        ///</summary>///<param name="FilePath">文件路径</param>///<returns></returns>publicstaticbool DeleteFile(string FilePath)
        {
            try
            {
                bool IsFind = File.Exists(FilePath);
                if (IsFind)
                {
                    File.Delete(FilePath);
                }
                else
                {
                    thrownew IOException("指定的文件不存在");
                }
                returntrue;
            }
            catch (Exception exc)
            {
                thrownew Exception(exc.Message);
            }

        }


        ///<summary>/// 执行过程中可能会打开多个EXCEL文件 所以杀掉
        ///</summary>privatestaticvoid QuertExcel()
        {
            Process[] excels = Process.GetProcessesByName("EXCEL");
            foreach (var item in excels)
            {
                item.Kill();
            }
        }

        privatevoid btnConvert_Click(object sender, EventArgs e)
        {
            //CSVSaveasXLS(textBox1.Text);
            XLSSavesaCSV(textBox1.Text);
        }
    }
}
原文转载自：http://www.cnblogs.com/junjie94wan/archive/2013/05/23/3094483.html

原文：http://www.cnblogs.com/wuhuisheng/p/4323242.html

内容总结

以上是互联网集市为您收集整理的C# .csv文件转为Excel格式；Excel格式转换为.csv全部内容，希望文章能够帮你解决C# .csv文件转为Excel格式；Excel格式转换为.csv所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/1253673.html

来源：【匿名】