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);