c#实现从txt文本里读取大量数据到Datetable再绑定到datagirdview，再导出到excel

   ///

private System.Data.DataTable datateble(System.Data.DataTable dt,string path,int a)
        {
            try
            {
                StreamReader st = new StreamReader(path);
                dt.Columns.Add("序号", typeof(string));
                dt.Columns.Add("数据内容", typeof(string));
                dt.Columns.Add("时间", typeof(string));
                String line;
                while ((line = st.ReadLine()) != null)
                {
                    a++;
                    DataRow dr = dt.NewRow();
                    string[] strs = line.Split(‘|‘);
                    dr[0] = a.ToString();
                    dr[2] = strs[0];
                    dr[1] = strs[1];
                    
                    dt.Rows.Add(dr);
                }
                st.Close();
                return dt;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Text;
//using Microsoft.Office.Interop.Excel;
using System.Windows.Forms;
using System.Threading;
using System.IO;
using Commonication_Program.CONFIG;
using System.Data;
using System.Threading.Tasks;

namespace Commonication_Program.RINTRUN
{
    class Rt_Excel
    {

        public Microsoft.Office.Interop.Excel.Application m_xlApp = null;
        /// 

        /// 将DataTable数据导出到Excel表
        /// 
        /// 要导出的DataTable
        /// Excel的保存路径及名称
        /// txt存放路径
        public void DataTabletoExcel(System.Data.DataTable tmpDataTable, string strFileName,string path)
        {
            if (tmpDataTable == null)
            {
                return;
            }

            long rowNum = tmpDataTable.Rows.Count;//行数
            int columnNum = tmpDataTable.Columns.Count;//列数
            m_xlApp = new Microsoft.Office.Interop.Excel.Application();

            m_xlApp.DisplayAlerts = false;//不显示更改提示
            m_xlApp.Visible = false;

            try
            {
                Microsoft.Office.Interop.Excel.Workbooks workbooks = m_xlApp.Workbooks;
                Microsoft.Office.Interop.Excel.Workbook workbook = workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
                Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];//取得sheet1

                if (rowNum > 65536)//单张Excel表格最大行数
                {
                    long pageRows = 65535;//定义每页显示的行数,行数必须小于65536
                    int scount = (int)(rowNum / pageRows);//导出数据生成的表单数
                    if (scount * pageRows  1)
                        {
                            object missing = System.Reflection.Missing.Value;
                            worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets.Add(
                                        missing, missing, missing, missing);//添加一个sheet
                        }
                        else
                        {
                            worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[sc];//取得sheet1
                        }
                        string[,] datas = new string[pageRows + 1, columnNum];

                        for (int i = 0; i = rowNum)
                        {
                            result = (int)rowNum;
                        }
                        else
                        {
                            result = int.Parse((pageRows * sc).ToString());
                        }

                        for (r = init; r