GridView templates
<p>Any help on how I could format/structure/template a GridView so that the the contents from an excel spreadsheet's cells would 
display as:</p>

<pre><code>&lt;li&gt;"looking to display data from column1 here between the li tags"&lt;/li&gt;
    &lt;p&gt;"and data from column2 here between the p tags"&lt;/p&gt;

&lt;!-- and so row two from excel / objDataset1 would do the same --&gt;
  &lt;li&gt;"data from column1 here"&lt;/li&gt;
    &lt;p&gt;"data from column2 here"&lt;/p&gt;

etc...
</code></pre>

<p>Here is the code I used to get a named range within the excel file into a gridview:</p>

<pre><code> Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" _
                &amp; "Data Source=" &amp; Server.MapPath("Spreadsheet.xls") _
                &amp; ";" &amp; "Extended Properties=Excel 8.0;"
    '  original code was:  &amp; "Data Source=" &amp; Server.MapPath("../ExcelData.xls") _ ' ???


    Dim objConn As New OleDbConnection(sConnectionString)
    objConn.Open()

    ' Create new OleDbCommand to return the data from the worksheet / RangeName.
    Dim objCmdSelect As New OleDbCommand("SELECT * FROM RangeName", objConn)
    Dim objAdapter1 As New OleDbDataAdapter()
    objAdapter1.SelectCommand = objCmdSelect
    Dim objDataset1 As New DataSet()

    ' Fill the DataSet with the information from the worksheet / RangeName.
    objAdapter1.Fill(objDataset1, "XLData") ' ?!?!?

    ' Build 
    GridView1.DataSource = objDataset1.Tables(0).DefaultView
    GridView1.DataBind()
    objConn.Close()
</code></pre>

<p>---------------------------- the bit I'm after --------------------------------------</p>

<pre><code> &lt;!-- It doesn't do much a present but it does display the info --&gt;
&lt;asp:GridView ID="GridView1" runat="server" style="height: 182px" 
    BackColor="Transparent"
    BorderColor="#DEDFDE"
    BorderStyle="None"
    BorderWidth="1px" 
    CellPadding="4"
    ForeColor="Black"
    GridLines="None"&gt;


    &lt;RowStyle BackColor="Transparent"

    /&gt;

    &lt;FooterStyle BackColor="#CCCC99" /&gt;

   &lt;%-- &lt;PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" /&gt;
    &lt;SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" /&gt;
    &lt;HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" /&gt;--%&gt;
    &lt;%-- I do not want to show the column header info from the excel file - which is coming through - also --%&gt;


    &lt;AlternatingRowStyle BackColor="Transparent" /&gt;

&lt;/asp:GridView&gt;
</code></pre>

<p>I don't even know if I should be using the gridview or something else -  so keep it nice and simple if you can...</p>
