Originally Posted by
Vladimir
Hi,
Which topic do you mean?
I had asked how load a grid with the content of a Excel.
I've a FileUpload Field and a Button, so after the use click in this button the grid loads with the content of the excel file.
I had read in another topic the "drop and down solution" but I'm no able to use that.
What can I do?
<ext:ResourceManager ID="resourceUploadView" runat="server" />
<ext:FormPanel ID="formUpload" runat="server" Border="false" Padding="5" ButtonAlign="Left"
LabelWidth="130" MonitorPoll="500" MonitorValid="true" AutoDataBind="true">
<Items>
<ext:FileUploadField ID="fileUpload" runat="server" Width="300" />
</Items>
<Buttons>
<ext:Button ID="btnCarregar" runat="server" Width="80" Text="Incluir" Icon="Disk"
X="5" Y="50">
<DirectEvents>
<Click Before="return #{formUpload}.getForm().isValid();" Url="../../Handler/LerExcel.ashx"
CleanRequest="true" Method="POST" Success="#{gridExcel}.store.reload();">
</Click>
</DirectEvents>
</ext:Button>
</Buttons>
</ext:FormPanel>
<ext:GridPanel Layout="FitLayout" ID="gridExcel" runat="server" StripeRows="true"
TrackMouseOver="true" Title="Excel" Frame="true" AutoExpandColumn="Codigo" Collapsible="true"
CollapseMode="Default" AnimCollapse="true" Height="300">
<Store>
<ext:Store ID="storeExcel" runat="server" WarningOnDirty="false" AutoDataBind="true" AutoLoad="true">
<Reader>
<ext:JsonReader Root="Data" TotalProperty="TotalRecords">
<Fields>
<ext:RecordField Name="Codigo" />
<ext:RecordField Name="Nome" />
<ext:RecordField Name="Data" />
<ext:RecordField Name="Obs" />
</Fields>
</ext:JsonReader>
</Reader>
<SortInfo Field="Codigo" Direction="ASC" />
<DirectEventConfig IsUpload="true" />
</ext:Store>
</Store>
<ColumnModel ID="columnmodelStatusContrato" runat="server">
<Columns>
<ext:Column ColumnID="Codigo" Header="Código" DataIndex="Codigo" Width="80" />
<ext:Column Header="Nome" DataIndex="Nome" Width="120" />
<ext:Column Header="Data" DataIndex="Data" Width="120" />
<ext:Column Header="Obs" DataIndex="Obs" Width="60" />
</Columns>
</ColumnModel>
<SelectionModel>
<ext:RowSelectionModel ID="rowselectionmodelStatusContrato" runat="server" />
</SelectionModel>
<LoadMask ShowMask="true" />
</ext:GridPanel>