导出大Excel

public static void Export(string filePath,string strSql)
{
    ExcelApp.Application excelApp = new ExcelApp.Application();
    ExcelApp._Workbook workbook = excelApp.Workbooks.Add();
    try
    {
        workbook.Activate();
        ExcelApp._Worksheet worksheet = workbook.Worksheets.Add();
        string connection = "ODBC;Driver=SQL Server;Server=.;uid=sa;pwd=850414;database=SMARTRNO_Business;";
        ExcelApp.QueryTable queryTable = worksheet.QueryTables.Add(connection, worksheet.get_Range("A1"), strSql);
        queryTable.Refresh(false);
        workbook.SaveAs(Filename: filePath, AccessMode: ExcelApp.XlSaveAsAccessMode.xlNoChange, AddToMru:false);
        //workbook.SaveAs(Filename: filePath, AccessMode: ExcelApp.XlSaveAsAccessMode.xlNoChange);
    }
    catch (Exception exception)
    {
        Console.WriteLine(exception.Message);
    }
    finally
    {
        workbook.Close();
        excelApp.Quit();
    }
}