Adding a label to export to excel caption

A datalist please. 

I have the datalist on the client side:

<asp:DataList ID="DataList2" runat="server" 
           DataSourceID="AreaName" ToolTip="Area" style="font-weight: 700" Width="404px">
            <ItemTemplate>                Area 
                <asp:Label ID="Label1" runat="server" Text='<%# Eval("area") %>'></asp:Label> -
                <asp:Label ID="Label2" runat="server" Text='<%# Eval("doc_name") %>'></asp:Label>  
            </ItemTemplate>       </asp:DataList>

it is my title to the gridiview. When I export to excel I want this datalist (labels) to export with it.

In that case you will need to put both GridView and DataList in Panel and then export the Panel

Thanks that's what I did and it works but the datalist labels aren't centered.  I tried to do it using style but it didn't work.  I'm not going to worry about it as it was exported.  Thanks for your help!

See for centering you need to add style tags to the controls. Another thing you can use a Table or DIV and use their align property