C# 操作excel 进行分列操作

 

//FileFullName 打开文件的路径

/./strfile 分列后保存的路径

 public void OpenExcel(string FileFullName,string strfile)
        {
            try
            {
                //Create excel instance
                excelApp = new Excel.Application();
                excelApp.Application.DisplayAlerts = false;
                excelApp.Visible = false;
                excelApp.UserControl = false;

                excelApp.Workbooks.OpenText(FileFullName, System.Reflection.Missing.Value, 1, Excel.XlTextParsingType.xlDelimited, Excel.XlTextQualifier.xlTextQualifierNone, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, true, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value,