62,046
社区成员
发帖
与我相关
我的任务
分享
/// <summary>
/// 直接导出数据到excel
/// </summary>
/// <param name="connectionString">连接字符串</param>
/// <param name="sql">查询语句</param>
/// <param name="fileName">文件名</param>
/// <param name="sheetName">表名</param>
static bool ExportDataToExcel(string connectionString, string sql, string fileName, string sheetName)
{
bool IsExport = false;
Excel.Application app = new Excel.ApplicationClass();
Excel.Workbook wb = (Excel.WorkbookClass)app.Workbooks.Add(Missing.Value);
Excel.Worksheet ws = wb.Worksheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value) as Excel.Worksheet;
ws.Name = sheetName;
try
{
Excel.QueryTable qt = ws.QueryTables.Add(connectionString,
ws.get_Range("A1", Missing.Value), sql);
qt.HasAutoFormat = true;
qt.Refresh(false); //是否异步查询
IsExport = true;
}
catch (Exception ex)
{
string str = ex.Message;
IsExport = false;
}
finally
{
wb.Saved = true;
wb.SaveCopyAs(fileName); //保存
app.Quit(); //关闭进程
}
return IsExport;
}