C# 怎么导出 Excel2007？求高手解答

[lclonger]

下面是我之前的代码，导出Excel2003可以，昨天装了07，能正常导出，但是每次打开却出现“您尝试打开的文件***的格式与文件扩展名指定的格式不一致”。
我把 文件名.xls 改成 文件名.xlsx,
将 Response.ContentType = "application/vnd.ms-excel";
改成 "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
也不行，请问该怎么解决？

protected void btnToExcel_Click(object sender, EventArgs e)
    {
        //设置文档输出类型
        Response.Clear();
        Response.Buffer = true;
        Response.Charset = "GB2312";
        Response.AppendHeader("Content-Disposition",
            "attachment;filename=文件名.xls");
        //如果设置为GetEncoding("GB2312");导出的文件将会出现乱码！！！
        Response.ContentEncoding = System.Text.Encoding.UTF7;
        //设置输出文件类型为excel文件
        Response.ContentType = "application/vnd.ms-excel";

        //输出表格数据
        StringWriter stringWriter = new StringWriter();
        HtmlTextWriter htmlTextWriter = new HtmlTextWriter(stringWriter);
        this.gvScore.RenderControl(htmlTextWriter);
        // Response.Output.Write(stringWriter.ToString());
        Response.Flush();
        //根据<br/>换行
        Response.Write(stringWriter.ToString().Replace("<br/>", "<br style='mso-data-placement:same-cell;'/><br style='mso-data-placement:same-cell;'/> "));
        //结束
        Response.End();
    }

[jshzp]

[Quote=引用 2 楼 ydh85362600 的回复:]
C# code


private void SaveAs() //另存新档按钮 导出成Excel
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "Execl files (*.xls)|*.xls……
[/Quote]
+1

[haosa]

Response.AppendHeader("Content-Disposition",
"attachment;filename=文件名.xls");
后缀名
Execl files (*.xls)|*.xls

[wtj2832]

http://hi.baidu.com/%C3%CE%C8%E7%D0%D0%D4%C6/blog/item/82956d0e407a82f537d12230.html
http://archive.cnblogs.com/a/2006677/

[ydh85362600]

  private void SaveAs() //另存新档按钮 导出成Excel
            {
            SaveFileDialog saveFileDialog = new SaveFileDialog();
            saveFileDialog.Filter = "Execl files (*.xls)|*.xls";
            saveFileDialog.FilterIndex = 0;
            saveFileDialog.RestoreDirectory = true;
            saveFileDialog.CreatePrompt = true;
            saveFileDialog.Title = "Export Excel File To";
            saveFileDialog.ShowDialog();
            Stream myStream;
            myStream = saveFileDialog.OpenFile();
            StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312"));
           // StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0));
            string str = "";
            try
            {
            //写标题
            for (int i = 0; i < dgvAgeWeekSex.ColumnCount; i++)
            {
            if (i > 0)
            {
                str += "\t";
            }
            str += dgvAgeWeekSex.Columns[i].HeaderText;
            }
            sw.WriteLine(str);
            //写内容
            for (int j = 0; j < dgvAgeWeekSex.Rows.Count; j++)
            {
            string tempStr = "";
            for (int k = 0; k < dgvAgeWeekSex.Columns.Count; k++)
            {
            if (k > 0)
            {
            tempStr += "\t";
            }
            tempStr += dgvAgeWeekSex.Rows[j].Cells[k].Value.ToString();
            }
            sw.WriteLine(tempStr);
            }
            sw.Close();
            myStream.Close();
            }
            catch (Exception e)
            {
            MessageBox.Show(e.ToString());
            }
            finally
            {
            sw.Close();
            myStream.Close();
            }
            }

[remember_me]

using System.Data.OleDb;

public class Program
{
   static void Main()
  {
      string connString = "Provider = Microsoft.Jet.Ole.4.0;Data Source = EXCEL文件路径;Extended Properties = 'Excel 8.0;HDR=YES;IMEX=1'";

      //实例化OleDbConnection对象
       using(OleDbConnection connection = new OleDbConnection(connString))
      {
           //SQL语句
            string sql = "Select * from [Sheet1$]";

           //实例化OleDbCommand对象
           using(OleDbCommand objCommand = new OleDbCommand(sql,connection))
           {
               //打开数据库连接
                 connection.Open();

               //实例化OleDbDataReader对象
                 using(OleDbDataReader objReader = objCommand.ExecuteReader())
               {
                   if(objReader.HasRows)
                   {
                      while(objReader.Read())
                      {
                           //objReader["列名或索引号"]
                      }
                   }
               }
           }
      }
  }
}

[子夜__]

可是考虑使用NOPI

[liu_yun88]

StringBuilder sb = new StringBuilder();
StringWriter sw = new StringWriter(sb);
HtmlTextWriter htw = new HtmlTextWriter(sw);
Page page = new Page();
HtmlForm form = new HtmlForm();
gvExaminationresult.EnableViewState = false;
page.EnableEventValidation = false;
page.DesignerInitialize();
page.Controls.Add(form);
form.Controls.Add(gvExaminationresult);
page.RenderControl(htw);
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment;filename=score.xls");
Response.Charset = "UTF-8";
Response.ContentEncoding = Encoding.Default;
Response.Write(sb.ToString());
Response.End();

这个行么？