datalsit 导出为excel

Question

DataList <HeaderTemplate>、<ItemTemplate>
用Table 绑定数据 在<ItemTemplate>内，<td><%#Eval("Name")%></td>，导出时如何导出成带有表格线滴
这个Table也要有表格线

Answer 1

只要你样式设了线，导出时一样有（是html的导出）

Answer 2

看不图，你用的本地图，如果在web中看得到线，导出应该看得见，如果web中都看不见，那就要设样式．

Answer 3

你把你的html贴出来．这个贴子搞了这么久没解决，

Answer 4

导出到本地的 那个TABLE 设的样式 在别的页面上是可以看到边框线的 放到DataList里也可以，
运行出来 也看得到 可是导出来就看不到啦 这是运行之后的 图
上面的是导出的图#10

Answer 5

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage/MasterPage_ZGH.master" AutoEventWireup="true" CodeFile="PlanKanBan.aspx.cs" Inherits="JingXiaoSh_SalePlan_PlanKanBan" %><asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <script src="../../jscript/My97DatePicker/WdatePicker.js" type="text/javascript"></script>
 <%--   <asp:ScriptManager ID="ScriptManager1" runat="server">
    </asp:ScriptManager>
    <asp:UpdatePanel ID="UpdatePanel1" runat="server">
        <ContentTemplate>--%>        <table border="0" cellspacing="1"  id=aa runat=server>
<tr>
<td class="left" align=left>请选择条件：</td>
<td>市场部：</td>
<td>
                <asp:DropDownList ID="ddlscb" runat="server" AutoPostBack="True" 
                    onselectedindexchanged="ddlscb_SelectedIndexChanged">
                </asp:DropDownList>
            </td>
<td>经销商：</td>
<td>
                <asp:DropDownList ID="ddljxs" runat="server">
                </asp:DropDownList>
            </td>
            <td>日期：</td>
<td class="content" align=left>
            <asp:TextBox ID="txtTime" runat="server" class="Wdate" Height="22px" 
                NAME="txtDate" onfocus="WdatePicker({skin:'whyGreen',dateFmt:'yyyy-MM',
                    isShowClear:false,readOnly:true})"></asp:TextBox>
            </td>
            <td>
                <asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/img/统计.gif" 
                    onclick="ImageButton1_Click" />
                &nbsp;
            </td>
            <td>&nbsp;
                <asp:ImageButton ID="ImageButton2" runat="server" ImageUrl="~/img/导出excel.gif" 
                    onclick="ImageButton2_Click" />
            </td>
</tr>
</table>
            <asp:DataList runat="server" ID="dlSalePlan" GridLines="Horizontal" >
                <HeaderTemplate>
                    <table align="center" cellpadding="4" cellspacing="1" class="table" 
            style="width:100%">
                        <tr >
                            <td class="left" rowspan=2>
                                销售顾问 
                            </td>
                            <td class="left" colspan=2>
                                日期 
                            </td>
                            <td class="left" colspan=3>
                                本月7日 
                            </td>
                            <td class="left" colspan=3>
                                本月14日 
                            </td>
                            <td class="left" colspan=3>
                                本月21日 
                            </td>
                            <td class="left" colspan=3>
                                本月28日 
                            </td>
                            <td class="left" colspan=3>
                                本月31日 
                            </td>
                            <td class="left" rowspan=2>
                                备注 
                            </td>
                        </tr>
                        <tr >
                            <td class="left">
                                上月订单
                            </td>
                            <td class="left">
                                月目标 
                            </td>
                            <td class="left">
                                订单 
                            </td>
                            <td class="left">
                                目标 
                            </td>
                            <td class="left">
                                实绩 
                            </td>
                            <td class="left">
                                订单 
                            </td>
                            <td class="left">
                                目标 
                            </td>
                            <td class="left">
                                实绩 
                            </td>
                            <td class="left">
                                订单 
                            </td>
                            <td class="left">
                                目标 
                            </td>
                            <td class="left">
                                实绩 
                            </td>
                            <td class="left">
                                订单 
                            </td>
                            <td class="left">
                                目标 
                            </td>
                            <td class="left">
                                实绩 
                            </td>
                            <td class="left">
                                订单 
                            </td>
                            <td class="left">
                                目标 
                            </td>
                            <td class="left">
                                实绩 
                            </td>
                        </tr>
                </HeaderTemplate>
                再顶下 ，还没贴完呢 不能贴了

Answer 6

我明白了，你是不是用了.css文件，这个.css文件是不会下载的，因此，你要将这个页面中用到的样式，写到页面中的<style></style>中

Answer 7

                <ItemTemplate>
                
                    <tr class="content" onmouseover ="this.style.backgroundColor='#E3E3E3'" 
            onmouseout ="this.style.backgroundColor=''">
                         <td>
                            <%#Eval("SPI_OP_Name")%>
                        </td>
                        <td>
                            <%#Eval("SPI_LastMonthSale")%>
                        </td>
                        <td>
                        <%#Eval("SP_SaleNum") %>
                        </td>
                        <td>
                            <%#Eval("SPI_One_Sale")%>
                        </td>
                        <td>
                            <%#Eval("SPI_One_Obj")%>
                        </td>
                        <td>
                            <%#Eval("SPI_One_Fact")%>
                        </td>
                        <td>
                            <%#Eval("SPI_Two_Sale")%>
                        </td>
                        <td>
                            <%#Eval("SPI_Two_Obj")%>
                        </td>
                        <td>
                            <%#Eval("SPI_Two_Fact")%>
                        </td>
                        <td>
                            <%#Eval("SPI_Three_Sale")%>
                        </td>
                        <td>
                            <%#Eval("SPI_Three_Obj")%>
                        </td>
                        <td>
                            <%#Eval("SPI_Three_Fact")%>
                        </td>
                        <td>
                            <%#Eval("SPI_Four_Sale")%>
                        </td>
                        <td>
                            <%#Eval("SPI_Four_Obj")%>
                        </td>
                        <td>
                            <%#Eval("SPI_Four_Fact")%>
                        </td>
                        <td>
                            <%#Eval("SPI_Last_Sale")%>
                        </td>
                        <td>
                            <%#Eval("SPI_Last_Obj")%>
                        </td>
                        <td>
                            <%#Eval("SPI_Last_Fact")%>
                        </td>
                        <td>
                            <%#Eval("SPI_Memo")%>
                        </td>
                    </tr>                </ItemTemplate>
                <FooterTemplate>
                    </table>
                </FooterTemplate>
                <%--<AlternatingItemTemplate></AlternatingItemTemplate>--%>
            </asp:DataList>
            </br>
    <br />
    </asp:Content>

Answer 8

其他页面当然是可以，只要是web页面，.css文件就会生效．

Answer 9

.table {
BACKGROUND:#799ae1;
width:98%;
    height: 28px;
    border:solid   1px   green;
}

Answer 10

Excel不是网页，有些效果直接不能显示
或打开excel模板，通过遍历数据集导入excel设置单元格样式
在style里设置样式
 <TD   noWrap   style="background:#ffffff;border:#808080;border-style:   solid;"><%# Eval("").ToString%>   再导出