Exporting a ListView to Excel
<p>I have a ListView that I need to export to an Excel spread sheet. There a bunch of documentation to export GridViews and to a lesser extent ListViews to Excel but not so much in terms of doing some customization before export.</p>

<p>Before exporting I need to prep the data, as a) only a subset of the columns need to be exported b) some of these columns are editable textbox controls.</p>

<p>Doing a simple export without preping the table means that the control gets exported as well which obviously looks really ugly. </p>

<p>At the moment I can iterate the controls and remove the formatting from both the Grid and ListViews thus solving b.</p>

<p>In the GridView and I can just set some the columns I want to hide using Visible = false; and then set back to true when I have finished.</p>

<p>The thing I can't figure is how to do this with the listview.  </p>

<p>I am wondering what is the best way to do this as I am kind of stuck.</p>

<p>Thanks,
Michael</p>
