代碼如下:
using System;
using System.Collections.Generic;
using System.Reflection;
using System.Web;
using Excel = Microsoft.Office.Interop.Excel;

/// <summary>
///ExcelClass 的摘要說明
/// </summary>
public class ExcelClass
{
    /// <summary>
    /// 構(gòu)建ExcelClass類
    /// </summary>
    public ExcelClass()
    {
        this.m_objExcel = new Excel.Application();
    }
    /// <summary>
    /// 構(gòu)建ExcelClass類
    /// </summary>
    /// <param name="objExcel">Excel.Application</param>
    public ExcelClass(Excel.Application objExcel)
    {
        this.m_objExcel = objExcel;
    }

    /// <summary>
    /// 列標(biāo)號
    /// </summary>
    private string AList = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";

    /// <summary>
    /// 獲取描述區(qū)域的字符
    /// </summary>
    /// <param name="x"></param>
    /// <param name="y"></param>
    /// <returns></returns>
    public string GetAix(int x, int y)
    {
        char[] AChars = AList.ToCharArray();
        if (x >= 26) { return ""; }
        string s = "";
        s = s + AChars[x - 1].ToString();
        s = s + y.ToString();
        return s;
    }

    /// <summary>
    /// 給單元格賦值1
    /// </summary>
    /// <param name="x">行號</param>
    /// <param name="y">列號</param>
    /// <param name="align">對齊（CENTER、LEFT、RIGHT）</param>
    /// <param name="text">值</param>
    public void setValue(int y, int x, string align, string text)
    {
        Excel.Range range = sheet.get_Range(this.GetAix(x, y), miss);
        range.set_Value(miss, text);
        if (align.ToUpper() == "CENTER")
        {
            range.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
        }