How to export only visible colm. in GridPanel

最新推荐文章于 2025-12-05 12:17:00 发布

转载最新推荐文章于 2025-12-05 12:17:00 发布 · 712 阅读

文章标签：

#server #button #ext #csv #excel #border

本文介绍了一个使用ExtJS框架实现的网格面板(grid panel)，该面板具备导出数据为Excel、CSV和XML格式的功能，并提供了分页、每页显示条数自定义及不同格式导出的实现方式。

<mce:script type="text/javascript"></mce:script> <ext:Store runat="server" ID="store1"> <Reader> <ext:JsonReader> <Fields> </Fields> </ext:JsonReader> </Reader> <Listeners> <LoadException Handler="Ext.Msg.alert('Members - Load failed', e.message || e )" /> </Listeners> </ext:Store> <ext:Hidden ID="FormatType" runat="server" /> <ext:Hidden ID="ColConfig" runat="server" /> <ext:GridPanel runat="server" ID="gridPanel1" StoreID="store1" Title="Members" BodyBorder="true" Border="true" Header="true" Height="400px" TrackMouseOver="true" Icon="Table"> <ColumnModel runat="server"> <Columns> <ext:RowNumbererColumn /> </Columns> </ColumnModel> <SelectionModel> <ext:RowSelectionModel runat="server" SingleSelect="false"></ext:RowSelectionModel> </SelectionModel> <LoadMask ShowMask="true" /> <TopBar> <ext:Toolbar runat="server"> <Items> <ext:ToolbarFill runat="server" /> <ext:Button runat="server" ID="btnExcel" Text="To Excel" Icon="PageExcel" AutoPostBack="true"> <Listeners> <Click Handler="setFields(#{gridPanel1}, #{FormatType}, #{ColConfig}, 'Excel');" /> </Listeners> </ext:Button> <ext:Button runat="server" ID="btnCSV" Text="To CSV" Icon="PageAttach" AutoPostBack="true"> <Listeners> <Click Handler="setFields(#{gridPanel1}, #{FormatType}, #{ColConfig}, 'CSV');" /> </Listeners> </ext:Button> <ext:Button runat="server" ID="btnXml" Text="To XML" Icon="PageCode" AutoPostBack="true"> <Listeners> <Click Handler="setFields(#{gridPanel1}, #{FormatType}, #{ColConfig}, 'XML');" /> </Listeners> </ext:Button> </Items> </ext:Toolbar> </TopBar> <BottomBar> <ext:PagingToolBar runat="server" ID="pager1" PageSize="50" StoreID="store1"> <Items> <ext:Label runat="server" ForID="txtPageSize" Html=" Page Size " /> <ext:NumberField runat="server" ID="txtPageSize" AllowBlank="false" AllowDecimals="false" AllowNegative="false" FieldLabel="Page Size" MinValue="1" MaxValue="10000" Width="40"> </ext:NumberField> <ext:Button runat="server" Text="Apply"> <Listeners> <Click Handler="#{pager1}.pageSize = parseInt(#{txtPageSize}.getValue()); #{pager1}.doLoad(0);" /> </Listeners> </ext:Button> </Items> </ext:PagingToolBar> </BottomBar> </ext:GridPanel>