//   将当前查询的数据导入Excel中  
        SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["sqlcon"]);

        //   设置为true,则在当前的数据上追加数据,否则,重写当前数据  
        StreamWriter w = new StreamWriter(Server.MapPath("数据库.xls"), false, Encoding.Default);
        con.Open();

        try
        {
            SqlCommand SqlCmd = con.CreateCommand();
            SqlCmd.CommandText = "select * from 80NT";
            SqlDataReader Reader = SqlCmd.ExecuteReader();
            for (int i = 0; i < Reader.FieldCount; ++i)
            {
                w.Write(Reader.GetName(i));
                w.Write('\t');
            }
            w.Write("\r\n");
            object[] values = new object[Reader.FieldCount];
            while (Reader.Read())
            {
                Reader.GetValues(values);
                for (int i = 0; i < values.Length; ++i)
                {
                    w.Write(values[i].ToString());
                    w.Write('\t');
                }
                w.Write("\r\n");
            }
            w.Flush();
            w.Close();
            Reader.Close();
            con.Close();
            Response.Redirect("数据库.xls");
        }
        catch
        {
            w.Close();
            con.Close();
            return;
        }