[CLOSED] Import Excel into Grid

Threaded View

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

    [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?



    
    <%@ 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]

Similar Threads

  1. Import excel to Datagrid
    By xborderland in forum 1.x Help
    Replies: 3
    Last Post: Nov 03, 2016, 6:31 AM
  2. Export the grid to excel
    By Mr.Techno in forum 1.x Help
    Replies: 34
    Last Post: Aug 23, 2013, 11:39 AM
  3. [CLOSED] how to export few columns from grid store to excel?
    By rnachman in forum 1.x Legacy Premium Help
    Replies: 1
    Last Post: Mar 28, 2012, 8:32 PM
  4. Excel Export in Grid
    By BLOZZY in forum 1.x Help
    Replies: 0
    Last Post: Oct 09, 2011, 11:37 AM
  5. Paste from Excel into Grid?
    By rthiney in forum 1.x Help
    Replies: 3
    Last Post: Sep 14, 2009, 7:11 PM

Posting Permissions