C# 快速填充excel 數據表導出excel

using System.Reflection;

using Excel = Microsoft.Office.Interop.Excel;

private string NumTochr(int Num)

        {

            int n = 64 + Num;

            return "" + (Char)n;

        }

        private string NumToExeclRowStr(int Num)

        {

            int X, Y;

            if (Num < 27)

            {

                return NumTochr(Num);

            }

            X = Num / 26;

            Y = Num - X * 26;

            return NumTochr(X) + NumTochr(Y);

        }

        /// <summary>

        /// 將DataTable中的列名及數據導出到Excel表中

        /// </summary>

        /// <param name="tmpDataTable">要導出的DataTable</param>

        /// <param name="strFileName">Excel的保存路徑及名稱</param>

        public void DataTabletoExcelkk(System.Data.DataTable tmpDataTable, string strFileName)

        {

            if (tmpDataTable == null)

                return;

            int rowNum = tmpDataTable.Rows.Count;            int columnNum = tmpDataTable.Columns.Count;

            int rowIndex = 1;

            int columnIndex = 0;

            Excel.Application xlApp = new Excel.ApplicationClass();

            xlApp.DefaultFilePath = "";

            xlApp.DisplayAlerts = true;

            xlApp.SheetsInNewWorkbook = 1;

            Excel.Workbook xlBook = xlApp.Workbooks.Add(true);

            Excel.Worksheet ws = (Excel.Worksheet)xlBook.Worksheets[1];

            int colnum = tmpDataTable.Columns.Count;

            Excel.Range r = ws.get_Range("A1", NumToExeclRowStr(colnum) + "1");

            object[] objHeader = new object[colnum];

            //將DataTable的列名導入Excel表第一行

            foreach (DataColumn dc in tmpDataTable.Columns)

            {

                objHeader[columnIndex] = dc.ColumnName;

                columnIndex++;

            }

            r.Value2 = objHeader;

            //將DataTable中的數據導入Excel中

            for (int i = 0; i < rowNum; i++)

            {

                rowIndex++;

                columnIndex = 0;