Feb 08, 2011, 12:28 PM
Export data to excel - in order columns
hi,
i want to ask something about exporting data to excel from gridpanel,
i can do that but problem is that, when i change column sorting and export excel, it doesn't work correctly.
Like that, now columns in order;
Name - Surname - Phone
when i change on page like that --> Name - Phone - Surname
and export to excel, ordering in excel document is "Name - Surname - Phone" , doesnt work
how can i do that?
i want to ask something about exporting data to excel from gridpanel,
i can do that but problem is that, when i change column sorting and export excel, it doesn't work correctly.
Like that, now columns in order;
Name - Surname - Phone
when i change on page like that --> Name - Phone - Surname
and export to excel, ordering in excel document is "Name - Surname - Phone" , doesnt work
how can i do that?
<%@ Page Language="C#" AutoEventWireup="true" ValidateRequest="false" CodeFile="ext-test3.aspx.cs" Inherits="ext_test" %>
<%@ Register Assembly="Ext.Net" Namespace="Ext.Net" TagPrefix="ext" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<script type="text/javascript">
var saveData = function () {
GridData.setValue(Ext.encode(GridPanel1.getRowsValues({ visibleOnly: true, excludeId: true })));
};
</script>
</head>
<body>
<form id="form1" runat="server">
<ext:ResourceManager ID="ResourceManager1" Theme="Gray" runat="server" />
<ext:Hidden ID="GridData" runat="server" />
<ext:Store ID="Store1" runat="server" OnRefreshData="MyData_Refresh" RemoteSort="false">
<Reader>
<ext:ArrayReader>
<Fields>
<ext:RecordField Name="Ad" Type="String" />
<ext:RecordField Name="Soyad" Type="String" />
<ext:RecordField Name="CepTelefonu" Type="String" />
<ext:RecordField Name="EvTelefonu" Type="String" />
<ext:RecordField Name="IsTelefonu" Type="String" />
<ext:RecordField Name="Email" Type="String" />
<ext:RecordField Name="Il" Type="String" />
<ext:RecordField Name="Ilce" Type="String" />
<ext:RecordField Name="Semt" Type="String" />
</Fields>
</ext:ArrayReader>
</Reader>
<DirectEventConfig IsUpload="true" />
</ext:Store>
<ext:GridPanel
ID="GridPanel1"
runat="server"
StoreID="Store1"
Title="Müşteri Raporu"
TrackMouseOver="true"
Height="550">
<ColumnModel ID="ColumnModel1" runat="server">
<Columns>
<ext:RowNumbererColumn />
<ext:Column ColumnID="FirstName" Header="Ad" DataIndex="Ad" />
<ext:Column ColumnID="LastName" Header="Soyad" DataIndex="Soyad" />
<ext:Column ColumnID="MobilePhone" Header="Cep Telefonu" DataIndex="CepTelefonu" />
<ext:Column ColumnID="HomePhone" Header="Ev Telefonu" DataIndex="EvTelefonu" />
<ext:Column ColumnID="WorkPhone" Header="İş Telefonu" DataIndex="IsTelefonu" />
<ext:Column ColumnID="PersonelEmail" Width="160" Header="Email" DataIndex="Email" />
<ext:Column ColumnID="City" Header="İl" DataIndex="Il" />
<ext:Column ColumnID="District" Header="İlçe" DataIndex="Ilce" />
<ext:Column ColumnID="Vicinity" Header="Semt" DataIndex="Semt" />
</Columns>
</ColumnModel>
<BottomBar>
<ext:PagingToolbar ID="PagingToolbar1" runat="server" PageSize="20" />
</BottomBar>
<SelectionModel>
<ext:RowSelectionModel ID="RowSelectionModel1" runat="server" />
</SelectionModel>
<TopBar>
<ext:Toolbar ID="Toolbar1" runat="server">
<Items>
<ext:ToolbarFill ID="ToolbarFill1" runat="server" />
<ext:Button ID="Button2" runat="server" Text="Excel Belgesi" AutoPostBack="true" OnClick="ToExcel" Icon="PageExcel">
<Listeners>
<Click Fn="saveData" />
</Listeners>
</ext:Button>
</Items>
</ext:Toolbar>
</TopBar>
</ext:GridPanel>
</form>
</body>
</html>
Last edited by Daniil; Mar 22, 2012 at 7:48 AM.
Reason: Please use [CODE] tags