Mar 09, 2012, 2:14 PM
[CLOSED] Import Excel into Grid
Hi, I'm using ASP.NET MVC and need import the content of a Excel File (using FileUploadField) into a Grid, but I'm getting successfull.
I want to load the grid after the user click in a button. I had read in another post that is not possible populate a store with JSON, right? But I'm not to use the "drag and drop solution". What do I do?
The "LerExcel" event returns a JSON string.
Thank you
I want to load the grid after the user click in a button. I had read in another post that is not possible populate a store with JSON, right? But I'm not to use the "drag and drop solution". What do I do?
<%@ Page Language="C#" Inherits="System.Web.Mvc.ViewPage<dynamic>" %>
<%@ Import Namespace="System.Collections.Generic" %>
<%@ Import Namespace="System.Xml.Xsl" %>
<%@ Import Namespace="System.Xml" %>
<%@ Import Namespace="System.Linq" %>
<%@ Import Namespace="System.Threading" %>
<%@ 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">
<script type="text/javascript" src="../../Scripts/jquery-1.5.1.js"></script>
<script type="text/javascript" src="../../Scripts/jquery.unobtrusive-ajax.min.js"></script>
<script type="text/javascript" src="../../Scripts/SimpleProgress-fx.js?v1"></script>
<script type="text/javascript" src="../../Scripts/jquery.simplemodal-1.4.2.js"></script>
<script runat="server">
</script>
<html>
<head runat="server">
<title>UploadView</title>
</head>
<body>
<form id="form" runat="server">
<ext:ResourceManager ID="resourceUploadView" runat="server" />
<ext:FormPanel ID="formUpload" runat="server" AutoDataBind="true">
<Items>
<ext:FileUploadField ID="fileUpload" runat="server" Width="300" />
</Items>
<Buttons>
<ext:Button ID="btnCarregar" runat="server" Width="80" Text="Incluir">
<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"
Title="Excel">
<Store>
<ext:Store ID="storeExcel" runat="server" WarningOnDirty="false" AutoDataBind="true"
AutoLoad="false">
<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>
<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="Nome" Width="120" />
<ext:Column Header="Obs" DataIndex="Obs" Width="60" />
</Columns>
</ColumnModel>
<LoadMask ShowMask="true" />
</ext:GridPanel>
</form>
</body>
</html>
The "LerExcel" event returns a JSON string.
Thank you
Last edited by Daniil; Mar 13, 2012 at 2:24 PM.
Reason: [CLOSED]