导出excel

private void Port_Excel()
        {
            SaveFileDialog save = new SaveFileDialog();
            save.Filter = "所有xls文件|*.xls";
            if (save.ShowDialog() == DialogResult.OK)
            {
                string FillName = save.FileName;
                FileStream fs = null;
                if (File.Exists(FillName))
                {
                    fs = new FileStream(FillName, FileMode.Open);
                }
                else
                {
                    fs = new FileStream(FillName, FileMode.CreateNew);
                }
                StreamWriter sw = new StreamWriter(fs, System.Text.Encoding.GetEncoding(-0));
                string str = "";
                for (int i = 0; i < this.dataGridView1.Columns.Count; i++)
                {
                    if (i > 0)
                    {
                        str += "/t";
                    }
                    str += this.dataGridView1.Columns[i].HeaderText;
                }
                sw.WriteLine(str);

              
                DataTable tab = this.ReturnTable();
                for (int i = 0; i < tab.Rows.Count; i++)
                {
                    string temsql = "";
                    for (int j = 0; j < tab.Columns.Count; j++)
                    {
                        if (j > 0)
                        {
                            temsql += "/t";
                        }
                        temsql += tab.Rows[i][j].ToString();
                    }

                    sw.WriteLine(temsql);

                }
                sw.Close();
                fs.Close();
            }
        }
        //utf-8解码

        public string Decode(string value)
        {

            return System.Web.HttpUtility.UrlDecode(value, System.Text.Encoding.UTF8);

        }
        private DataTable ReturnTable()
        {
           if (demo.conn.State == ConnectionState.Closed)
            {
                demo.conn.Open();
            }
            sql = "select id,carno,cartype,companyname,cardate,companyperson,insureperson,insuremoney,commitperson,invoicedate,enddate,finace,cardesc from insurecar";
            DataTable dt = new DataTable();
            SqlDataAdapter da = new SqlDataAdapter(sql, demo.conn);
            da.Fill(dt);
            return dt;

        //}