我分以下几步进行介绍: 1,新建一个C#应用程序,在对话框上放置一个按钮,Name=buttonOutput,Text=Output,用这个按钮激发导出程序;
2,添加对“Microsoft Excel 9.0 Object Library”的引用,根据自己计算机上安装Office版本的来确定Library的版本;
3,在代码中加入引用:
using Excel;
using System.Reflection;
4,在buttonOutput按钮单机事件中加入以下代码:
string strSql;
int col = 0, row = 2;
//定义数据变量
private OleDbConnection conn;
private OleDbCommand comm;
private OleDbDataReader reader;
//连接到数据库
string strConnectionstring = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DB.mdb";
conn = new OleDbConnection(strConnectionstring);
conn.Open();
comm = conn.CreateCommand();
//建立Excel应用对象
Excel.Application xlapp = new Excel.ApplicationClass();
xlapp.Workbooks.Add(true );
xlapp.Visible = false ;
strSql = "select * from INFO";
comm.CommandText = strSql;
reader=comm.ExecuteReader();
if (reader.HasRows)
{
for (col = 0; col < reader.FieldCount; col++)
{
xlapp.Cells[1, col + 1] = reader.GetName(col);
}
while (reader.Read())
{
for (col = 0; col < reader.FieldCount; col++)
{
xlapp.Cells[row, col + 1] = reader.GetValue(col).ToString();
}
row++;
}
}
xlapp.Visible = true;
xlapp.Worksheets.PrintPreview(true);
//关闭数据库纪录集
reader.Close();
comm.Close();