使用C#将DataTable打印到Excel的代码示例

using System;
using System.Data;
using Excel = Microsoft.Office.Interop.Excel;
// 添加引用 -> .NET -> Microsoft.Office.Interop.Excel(2003->11.0, 2007->12.0)

public static class UserSchema
{
    #region DataTable
    private static DataTable dataTable;

    static UserSchema()
    {
        dataTable = new DataTable("User");
        dataTable.Locale = System.Globalization.CultureInfo.InvariantCulture;
        string[] cn = { "UserName", "UserEmail", "Content" };
        foreach (string name in cn)
        {
            dataTable.Columns.Add(name, typeof(string));
        }
        dataTable.Columns.Add("SendTime", typeof(DateTime));
        dataTable.Constraints.Add("Name", dataTable.Columns["UserName"], true);
    }

    public static DataTable UserTable
    {
        get { return dataTable; }
        set { dataTable = value; }
    }
    #endregion