Shows Id when i Export Grid to Excel

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Shows Id when i Export Grid to Excel

    Hi,

    I have a little problem. Following this example, I have created a grid to export to Excel. The grid doesn't have an Id column, but when I create my Excel file, this Id column appears on it like this:
    Click image for larger version. 

Name:	Captura1.PNG 
Views:	76 
Size:	17.3 KB 
ID:	25270
    Click image for larger version. 

Name:	Captura2.PNG 
Views:	113 
Size:	22.4 KB 
ID:	25271

    ¿Is there a way a remove the id column from Excel?

    Thank you very much

    edit: Here is the grid code:

    <ext:GridPanel runat="server" ID="gridnotas"  ColumnWidth="0.7" Height ="230" MarginSpec="20 0 0 0" Frame="false">
                                                        <Store>
                                                            <ext:Store runat="server" ID="StoreNotas"
                                                                OnReadData="RefreshNotasProceso"
                                                                OnSubmitData="SubmitNotasProceso"
                                                                RemoteSort="true">
                                                                <Model>
                                                                    <ext:Model runat="server">
                                                                        <Fields>
                                                                            <ext:ModelField Name="Id" />
                                                                            <ext:ModelField Name="Modelo" />
                                                                            <ext:ModelField Name="Color" />
                                                                            <ext:ModelField Name="Talla" />
                                                                            <ext:ModelField Name="T36" />
                                                                            <ext:ModelField Name="T37" />
                                                                            <ext:ModelField Name="T38" />
                                                                            <ext:ModelField Name="T39" />
                                                                            <ext:ModelField Name="T40" />
                                                                            <ext:ModelField Name="T41" />
                                                                            <ext:ModelField Name="T42" />
                                                                            <ext:ModelField Name="T43" />
                                                                            <ext:ModelField Name="T44" />
                                                                            <ext:ModelField Name="T45" />
                                                                            <ext:ModelField Name="T46" />
                                                                            <ext:ModelField Name="T47" />
                                                                        </Fields>
                                                                    </ext:Model>
                                                                </Model>
                                                            </ext:Store>
                                                        </Store>
                                                        <ColumnModel runat="server">
                                                            <Columns>
                                                                <ext:Column runat="server" Text="Modelo" DataIndex="Modelo" Width="100" Align="Center"/>
                                                                <ext:Column runat="server" Text="Color" Width="100" DataIndex="Color" Align="Center"/>
                                                                <ext:Column runat="server" Text="Talla" DataIndex="Talla" Width="150" Align="Center"/>
                                                                <ext:Column runat="server" Text="36" DataIndex="T36" Width="65" Align="Center"/>
                                                                <ext:Column runat="server" Text="37" DataIndex="T37" Width="65" Align="Center"/>
                                                                <ext:Column runat="server" Text="38" DataIndex="T38" Width="65" Align="Center"/>
                                                                <ext:Column runat="server" Text="39" DataIndex="T39" Width="65" Align="Center"/>
                                                                <ext:Column runat="server" Text="40" DataIndex="T40" Width="65" Align="Center"/>
                                                                <ext:Column runat="server" Text="41" DataIndex="T41" Width="65" Align="Center"/>
                                                                <ext:Column runat="server" Text="42" DataIndex="T42" Width="65" Align="Center"/>
                                                                <ext:Column runat="server" Text="43" DataIndex="T43" Width="65" Align="Center"/>
                                                                <ext:Column runat="server" Text="44" DataIndex="T44" Width="65" Align="Center"/>
                                                                <ext:Column runat="server" Text="45" DataIndex="T45" Width="65" Align="Center"/>
                                                                <ext:Column runat="server" Text="46" DataIndex="T46" Width="65" Align="Center"/>
                                                                <ext:Column runat="server" Text="47" DataIndex="T47" Width="65" Align="Center"/>
                                                            </Columns>
                                                        </ColumnModel>
                                                    </ext:GridPanel>
    Last edited by PascuV; Jun 17, 2019 at 9:28 AM. Reason: add code

Similar Threads

  1. Replies: 2
    Last Post: May 10, 2019, 10:29 PM
  2. Export to Excel for Dynamic Grid panel
    By kavitha in forum 2.x Help
    Replies: 0
    Last Post: Jan 22, 2014, 10:33 AM
  3. Export the grid to excel
    By Mr.Techno in forum 1.x Help
    Replies: 34
    Last Post: Aug 23, 2013, 11:39 AM
  4. how to export selected columns from a grid to excel
    By deepu s nair in forum 2.x Help
    Replies: 0
    Last Post: Feb 05, 2013, 12:09 PM
  5. Excel Export in Grid
    By BLOZZY in forum 1.x Help
    Replies: 0
    Last Post: Oct 09, 2011, 11:37 AM

Posting Permissions