如何制作SQL命令来生成Excel

答案：string strSql = @"SELECT (SELECT title FROM inspect_arrange_info WHERE code=inspect_code) AS 巡视安排
              ,(SELECT dict_name FROM dictionary WHERE dict_code=(SELECT YEAR FROM inspect_arrange_info WHERE code=inspect_code)) AS 年份
              ,(SELECT dict_name FROM dictionary WHERE dict_code=(SELECT batch FROM inspect_arrange_info WHERE code=inspect_code)) AS 批次 
              ,(SELECT departmentName from Departments WHERE deparmentcode=(SELECT group_code FROM inspect_arrange_info WHERE code=inspect_code)) AS 巡视组
              ,summary AS 简介
              ,add_date_time AS 添加时间
          FROM Team_PatrolReport_info where 1=1 order by code desc";

        DataSet ds = dp.GetDataSet(strSql);

        string data = ExportCSV(ds);
        string fileName = "TeamWorkProgram_" + System.DateTime.Now.ToShortDateString() + ".csv";
        string temp = string.Format("attachment;filename={0}", fileName);
        Response.ClearHeaders();
        Response.AppendHeader("Content-disposition", temp);
        Response.Write(data);
        Response.End();

上一个：跪求Excel表中函数设置：
下一个：有哪位Excel高手会编程宏，请指导！