.net 操作Excel

将数字序号转换为列号 

private string NunberToChar(int number)

        {
            if (1 <= number && 36 >= number)
            {
                int num = number + 64;
                System.Text.ASCIIEncoding asciiEncoding = new System.Text.ASCIIEncoding();
                byte[] btNumber = new byte[] { (byte)num };
                return asciiEncoding.GetString(btNumber);
            }
            if (number > 36)
            {
                int num = number - 36 + 64;
                System.Text.ASCIIEncoding asciiEncoding = new System.Text.ASCIIEncoding();
                byte[] btNumber = new byte[] { (byte)num };
                return "A" + asciiEncoding.GetString(btNumber);
            }
            return "";

        }

object missing = System.Reflection.Missing.Value;
Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook newWorkBook = excel.Application.Workbooks.Add(true);//添加新工作簿
newWorkBook.Worksheets.Add(missing, missing, missing, missing);//向Excel文件中增加工作表
Microsoft.Office.Interop.Excel.Worksheet sheet = (Microsoft.Office.Interop.Excel.Worksheet)newWorkBook.Sheets[1];
Microsoft.Office.Interop.Excel.Range range;

string sMaxCol = NunberToChar(dtLCLJJD.Rows.Count + 1);
range = sheet.get_Range("A1:" + sMaxCol + "1", Type.Missing); 

range.Merge(0); //合并单元格显示

range.Value2 = “标题1”;

 range.Font.Size = 15;

 range.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlVAlign.xlVAlignCenter;

range.WrapText = true;//自动换行