C#将数据集连接到Excel并显示

来源：互联网发布：js封装编辑：程序博客网时间：2024/06/08 15:05

using Microsoft.Office.Interop.Excel;

需要引用Microsoft Excel 12.0 Object Library

private void WriteExcel(string filename,string sql) { Application excel; _Workbook xBk; _Worksheet xSt; _QueryTable xQt; excel = new ApplicationClass(); if (excel == null) { MessageBox.Show("无法创建Excel对象，可能您的机子未安装Excel"); return; } xBk = excel.Workbooks.Add(true); xSt = (_Worksheet)xBk.ActiveSheet; string Conn = "ODBC;DRIVER=SQL Server;SERVER=" + host + ";UID=sa;PWD=58325245;DATABASE=CMSChina"; xQt = xSt.QueryTables.Add(Conn, xSt.get_Range(excel.Cells[1, 1], excel.Cells[1, 1]), sql); xQt.Name = "导出示例"; xQt.FieldNames = true; xQt.RowNumbers = false; xQt.FillAdjacentFormulas = false; xQt.PreserveFormatting = false; xQt.BackgroundQuery = true; xQt.RefreshStyle = XlCellInsertionMode.xlInsertDeleteCells; xQt.AdjustColumnWidth = true; xQt.RefreshPeriod = 0; xQt.PreserveColumnInfo = true; xQt.Refresh(xQt.BackgroundQuery); excel.Visible = true; }