gridview与exel

如果GridView存在模板列，其中包含子控件，例如CheckBox等，导出EXCEL后就会出现该区域的不规律。所以要对模板列单独处理（转载）我转的，啊哈

public void PrepareGridViewForExport(Control gv)//模式化特殊元素 flashcong

  {

 

  LinkButton lb = new LinkButton();

  Literal l = new Literal();

  string name = String.Empty;

 

  for (int i = 0; i < gv.Controls.Count; i++)

  {

   

  if (gv.Controls[i].GetType() == typeof(LinkButton))

  {

 

  l.Text = (gv.Controls[i] as LinkButton).Text;

  gv.Controls.Remove(gv.Controls[i]);

  gv.Controls.AddAt(i, l);

 

  }

 

  else if (gv.Controls[i].GetType() == typeof(DropDownList))

  {

 

  l.Text = (gv.Controls[i] as DropDownList).SelectedItem.Text;

  gv.Controls.Remove(gv.Controls[i]);

  gv.Controls.AddAt(i, l);

 

  }

 

  else if (gv.Controls[i].GetType() == typeof(CheckBox))

  {

 

  l.Text = (gv.Controls[i] as CheckBox).Checked ? "True" : "False";

  gv.Controls.Remove(gv.Controls[i]);

  gv.Controls.AddAt(i, l);

 

  }

 

  else if (gv.Controls[i].GetType() == typeof(ImageButton))

  {

  l.Text = "图片";

  gv.Controls.Remove(gv.Controls[i]);

  gv.Controls.AddAt(i, l);

  }

 

  if (gv.Controls[i].HasControls())

  {

  PrepareGridViewForExport(gv.Controls[i]);

  }

  }

}