1. #141
    Sencha User
    Join Date
    Feb 2009
    Posts
    13
    Vote Rating
    0
    stevenhzj is on a distinguished road

      0  

    Default


    Quote Originally Posted by emredagli View Post
    Hii,
    I found a way to save as different filename and also working in IE 7.0 by using .NET framework in server side.
    .js code:
    Code:
    function post_to_url(path, params, method) {
        method = method || "post"; 
     
        var form = document.createElement("form");
        form.setAttribute("method", method);
        form.setAttribute("action", path);
     
        for(var i=0; i<params.length; i++) {
            var hiddenField = document.createElement("input");
            hiddenField.setAttribute("type", "hidden");
            hiddenField.setAttribute("name", params[i].name);
            hiddenField.setAttribute("value", params[i].value);
     
            form.appendChild(hiddenField);
        }
     
        document.body.appendChild(form);   
        form.submit();
    }
     
    function exportExcell() {
     
        var dataURL = 'CommonPages/ExportToExcelType1.aspx';
     
        params =[{
            name: 'Data',
            value: resultGrid.getExcelXml()  // Mr. Animal's part...
        },{
            name: 'FileName',
            value: 'File1.xls'
        }];
     
        post_to_url(dataURL, params, 'post');
    }
    CommonPages/ExportToExcelType1.aspx.cs code is:

    Code:
        protected void Page_Load(object sender, EventArgs e)
        {
            Response.Clear();
            Response.Buffer = true;
            Response.ContentType = "application/vnd.ms-excel";
            Response.AddHeader("Content-Disposition", "attachment;filename=\"" + Request.Params["FileName"].ToString() + "\"");
            Response.Charset = "";
            this.EnableViewState = false;
     
            System.IO.StringWriter SW = new System.IO.StringWriter();
            System.Web.UI.HtmlTextWriter HTW = new System.Web.UI.HtmlTextWriter(SW);
            HTW.WriteLine(Request.Params["Data"]);
     
            Response.Write(SW.ToString());
            Response.End();
     
        }
    And do not forget to put ValidateRequest="false" in the top of the ExportToExcelType1.aspx file like:
    Code:
    <%@ Page Language="C#" AutoEventWireup="true" CodeFile="ExportToExcelType1.aspx.cs" Inherits="CommonPages_ExportToExcelType1" ValidateRequest="false"%>
    In this solution there may be unnecessary parts...
    But it works nicelly.
    I hope it helps you... Good luck...

    hi emredagli
    i use you code, and my store is any pages. any each page can show data,but i can get store.data.length is 0? anybody help me?

  2. #142
    Ext JS Premium Member NoahK17's Avatar
    Join Date
    Apr 2008
    Location
    Atlanta, GA
    Posts
    518
    Vote Rating
    1
    NoahK17 is on a distinguished road

      0  

    Default


    I used to have this working, but even now when I try the new Example, the returned file is called "xxxxxx.xls.PART" -- What is causing the .part extension to be returned from the server? Here's the XML that's returned... can anyone make it a .xls file and see if Excel opens it properly? I only have OpenOffice on this computer.

    Code:
    <?xml version="1.0" encoding="utf-8"?><ss:Workbook xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:o="urn:schemas-microsoft-com:office:office"><o:DocumentProperties><o:Title>Array Grid</o:Title></o:DocumentProperties><ss:ExcelWorkbook><ss:WindowHeight>9000</ss:WindowHeight><ss:WindowWidth>39350</ss:WindowWidth><ss:ProtectStructure>False</ss:ProtectStructure><ss:ProtectWindows>False</ss:ProtectWindows></ss:ExcelWorkbook><ss:Styles><ss:Style ss:ID="Default"><ss:Alignment ss:Vertical="Top" ss:WrapText="1" /><ss:Font ss:FontName="arial" ss:Size="10" /><ss:Borders><ss:Border ss:Color="#e4e4e4" ss:Weight="1" ss:LineStyle="Continuous" ss:Position="Top" /><ss:Border ss:Color="#e4e4e4" ss:Weight="1" ss:LineStyle="Continuous" ss:Position="Bottom" /><ss:Border ss:Color="#e4e4e4" ss:Weight="1" ss:LineStyle="Continuous" ss:Position="Left" /><ss:Border ss:Color="#e4e4e4" ss:Weight="1" ss:LineStyle="Continuous" ss:Position="Right" /></ss:Borders><ss:Interior /><ss:NumberFormat /><ss:Protection /></ss:Style><ss:Style ss:ID="title"><ss:Borders /><ss:Font /><ss:Alignment ss:WrapText="1" ss:Vertical="Center" ss:Horizontal="Center" /><ss:NumberFormat ss:Format="@" /></ss:Style><ss:Style ss:ID="headercell"><ss:Font ss:Bold="1" ss:Size="10" /><ss:Alignment ss:WrapText="1" ss:Horizontal="Center" /><ss:Interior ss:Pattern="Solid" ss:Color="#A3C9F1" /></ss:Style><ss:Style ss:ID="even"><ss:Interior ss:Pattern="Solid" ss:Color="#CCFFFF" /></ss:Style><ss:Style ss:Parent="even" ss:ID="evendate"><ss:NumberFormat ss:Format="[ENG][$-409]dd-mmm-yyyy;@" /></ss:Style><ss:Style ss:Parent="even" ss:ID="evenint"><ss:NumberFormat ss:Format="0" /></ss:Style><ss:Style ss:Parent="even" ss:ID="evenfloat"><ss:NumberFormat ss:Format="0.00" /></ss:Style><ss:Style ss:ID="odd"><ss:Interior ss:Pattern="Solid" ss:Color="#CCCCFF" /></ss:Style><ss:Style ss:Parent="odd" ss:ID="odddate"><ss:NumberFormat ss:Format="[ENG][$-409]dd-mmm-yyyy;@" /></ss:Style><ss:Style ss:Parent="odd" ss:ID="oddint"><ss:NumberFormat ss:Format="0" /></ss:Style><ss:Style ss:Parent="odd" ss:ID="oddfloat"><ss:NumberFormat ss:Format="0.00" /></ss:Style></ss:Styles><ss:Worksheet ss:Name="Array Grid"><ss:Names><ss:NamedRange ss:Name="Print_Titles" ss:RefersTo="='Array Grid'!R1:R2" /></ss:Names><ss:Table x:FullRows="1" x:FullColumns="1" ss:ExpandedColumnCount="5" ss:ExpandedRowCount="31"><ss:Column ss:AutoFitWidth="1" ss:Width="1000" /><ss:Column ss:AutoFitWidth="1" ss:Width="75" /><ss:Column ss:AutoFitWidth="1" ss:Width="75" /><ss:Column ss:AutoFitWidth="1" ss:Width="75" /><ss:Column ss:AutoFitWidth="1" ss:Width="85" /><ss:Row ss:Height="38"><ss:Cell ss:StyleID="title" ss:MergeAcross="4"><ss:Data xmlns:html="http://www.w3.org/TR/REC-html40" ss:Type="String"><html:B><html:U><html:Font html:Size="15">Array Grid</html:Font></html:U></html:B>Generated by ExtJs</ss:Data><ss:NamedCell ss:Name="Print_Titles" /></ss:Cell></ss:Row><ss:Row ss:AutoFitHeight="1"><ss:Cell ss:StyleID="headercell"><ss:Data ss:Type="String">Company</ss:Data><ss:NamedCell ss:Name="Print_Titles" /></ss:Cell><ss:Cell ss:StyleID="headercell"><ss:Data ss:Type="String">Price</ss:Data><ss:NamedCell ss:Name="Print_Titles" /></ss:Cell><ss:Cell ss:StyleID="headercell"><ss:Data ss:Type="String">Change</ss:Data><ss:NamedCell ss:Name="Print_Titles" /></ss:Cell><ss:Cell ss:StyleID="headercell"><ss:Data ss:Type="String">% Change</ss:Data><ss:NamedCell ss:Name="Print_Titles" /></ss:Cell><ss:Cell ss:StyleID="headercell"><ss:Data ss:Type="String">Last Updated</ss:Data><ss:NamedCell ss:Name="Print_Titles" /></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="even"><ss:Data ss:Type="String">3m Co</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">71.72</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">0.02</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">0.03</ss:Data></ss:Cell><ss:Cell ss:StyleID="evendate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="odd"><ss:Data ss:Type="String">Alcoa Inc</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">29.01</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">0.42</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">1.47</ss:Data></ss:Cell><ss:Cell ss:StyleID="odddate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="even"><ss:Data ss:Type="String">Altria Group Inc</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">83.81</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">0.28</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">0.34</ss:Data></ss:Cell><ss:Cell ss:StyleID="evendate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="odd"><ss:Data ss:Type="String">American Express Company</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">52.55</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">0.01</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">0.02</ss:Data></ss:Cell><ss:Cell ss:StyleID="odddate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="even"><ss:Data ss:Type="String">American International Group, Inc.</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">64.13</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">0.31</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">0.49</ss:Data></ss:Cell><ss:Cell ss:StyleID="evendate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="odd"><ss:Data ss:Type="String">AT&T Inc.</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">31.61</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">-0.48</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">-1.54</ss:Data></ss:Cell><ss:Cell ss:StyleID="odddate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="even"><ss:Data ss:Type="String">Boeing Co.</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">75.43</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">0.53</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">0.71</ss:Data></ss:Cell><ss:Cell ss:StyleID="evendate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="odd"><ss:Data ss:Type="String">Caterpillar Inc.</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">67.27</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">0.92</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">1.39</ss:Data></ss:Cell><ss:Cell ss:StyleID="odddate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="even"><ss:Data ss:Type="String">Citigroup, Inc.</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">49.37</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">0.02</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">0.04</ss:Data></ss:Cell><ss:Cell ss:StyleID="evendate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="odd"><ss:Data ss:Type="String">E.I. du Pont de Nemours and Company</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">40.48</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">0.51</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">1.28</ss:Data></ss:Cell><ss:Cell ss:StyleID="odddate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="even"><ss:Data ss:Type="String">Exxon Mobil Corp</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">68.1</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">-0.43</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">-0.64</ss:Data></ss:Cell><ss:Cell ss:StyleID="evendate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="odd"><ss:Data ss:Type="String">General Electric Company</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">34.14</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">-0.08</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">-0.23</ss:Data></ss:Cell><ss:Cell ss:StyleID="odddate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="even"><ss:Data ss:Type="String">General Motors Corporation</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">30.27</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">1.09</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">3.74</ss:Data></ss:Cell><ss:Cell ss:StyleID="evendate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="odd"><ss:Data ss:Type="String">Hewlett-Packard Co.</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">36.53</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">-0.03</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">-0.08</ss:Data></ss:Cell><ss:Cell ss:StyleID="odddate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="even"><ss:Data ss:Type="String">Honeywell Intl Inc</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">38.77</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">0.05</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">0.13</ss:Data></ss:Cell><ss:Cell ss:StyleID="evendate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="odd"><ss:Data ss:Type="String">Intel Corporation</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">19.88</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">0.31</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">1.58</ss:Data></ss:Cell><ss:Cell ss:StyleID="odddate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="even"><ss:Data ss:Type="String">International Business Machines</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">81.41</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">0.44</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">0.54</ss:Data></ss:Cell><ss:Cell ss:StyleID="evendate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="odd"><ss:Data ss:Type="String">Johnson & Johnson</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">64.72</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">0.06</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">0.09</ss:Data></ss:Cell><ss:Cell ss:StyleID="odddate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="even"><ss:Data ss:Type="String">JP Morgan & Chase & Co</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">45.73</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">0.07</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">0.15</ss:Data></ss:Cell><ss:Cell ss:StyleID="evendate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="odd"><ss:Data ss:Type="String">McDonald's Corporation</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">36.76</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">0.86</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">2.4</ss:Data></ss:Cell><ss:Cell ss:StyleID="odddate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="even"><ss:Data ss:Type="String">Merck & Co., Inc.</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">40.96</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">0.41</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">1.01</ss:Data></ss:Cell><ss:Cell ss:StyleID="evendate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="odd"><ss:Data ss:Type="String">Microsoft Corporation</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">25.84</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">0.14</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">0.54</ss:Data></ss:Cell><ss:Cell ss:StyleID="odddate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="even"><ss:Data ss:Type="String">Pfizer Inc</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">27.96</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">0.4</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">1.45</ss:Data></ss:Cell><ss:Cell ss:StyleID="evendate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="odd"><ss:Data ss:Type="String">The Coca-Cola Company</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">45.07</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">0.26</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">0.58</ss:Data></ss:Cell><ss:Cell ss:StyleID="odddate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="even"><ss:Data ss:Type="String">The Home Depot, Inc.</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">34.64</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">0.35</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">1.02</ss:Data></ss:Cell><ss:Cell ss:StyleID="evendate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="odd"><ss:Data ss:Type="String">The Procter & Gamble Company</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">61.91</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">0.01</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">0.02</ss:Data></ss:Cell><ss:Cell ss:StyleID="odddate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="even"><ss:Data ss:Type="String">United Technologies Corporation</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">63.26</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">0.55</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">0.88</ss:Data></ss:Cell><ss:Cell ss:StyleID="evendate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="odd"><ss:Data ss:Type="String">Verizon Communications</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">35.57</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">0.39</ss:Data></ss:Cell><ss:Cell ss:StyleID="oddfloat"><ss:Data ss:Type="Number">1.11</ss:Data></ss:Cell><ss:Cell ss:StyleID="odddate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row><ss:Row><ss:Cell ss:StyleID="even"><ss:Data ss:Type="String">Wal-Mart Stores, Inc.</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">45.45</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">0.73</ss:Data></ss:Cell><ss:Cell ss:StyleID="evenfloat"><ss:Data ss:Type="Number">1.63</ss:Data></ss:Cell><ss:Cell ss:StyleID="evendate"><ss:Data ss:Type="DateTime">2009-09-01</ss:Data></ss:Cell></ss:Row></ss:Table><x:WorksheetOptions><x:PageSetup><x:Layout x:CenterHorizontal="1" x:Orientation="Landscape" /><x:Footer x:Data="Page &amp;P of &amp;N" x:Margin="0.5" /><x:PageMargins x:Top="0.5" x:Right="0.5" x:Left="0.5" x:Bottom="0.8" /></x:PageSetup><x:FitToPage /><x:Print><x:PrintErrors>Blank</x:PrintErrors><x:FitWidth>1</x:FitWidth><x:FitHeight>32767</x:FitHeight><x:ValidPrinterInfo /><x:VerticalResolution>600</x:VerticalResolution></x:Print><x:Selected /><x:DoNotDisplayGridlines /><x:ProtectObjects>False</x:ProtectObjects><x:ProtectScenarios>False</x:ProtectScenarios></x:WorksheetOptions></ss:Worksheet></ss:Workbook>
    Noah
    Senior Web Developer
    NBA.com

  3. #143

  4. #144
    Ext JS Premium Member NoahK17's Avatar
    Join Date
    Apr 2008
    Location
    Atlanta, GA
    Posts
    518
    Vote Rating
    1
    NoahK17 is on a distinguished road

      0  

    Default


    Quote Originally Posted by mjlecomte View Post
    It opens.
    Lame. Well... I'm downloading a 60 day trial of MS Excel, so we'll see what happens...

    But do you have any idea why I am getting .PART returned as the extension? I googled it, but nothing really came up.
    Noah
    Senior Web Developer
    NBA.com

  5. #145
    Sencha - Community Support Team mystix's Avatar
    Join Date
    Mar 2007
    Location
    Singapore
    Posts
    6,236
    Vote Rating
    5
    mystix will become famous soon enough

      0  

    Default


    Quote Originally Posted by NoahK17 View Post
    Lame. Well... I'm downloading a 60 day trial of MS Excel, so we'll see what happens...

    But do you have any idea why I am getting .PART returned as the extension? I googled it, but nothing really came up.
    .part is the file extension Firefox tacks on to in-progress downloads.
    there should be an accompanying file without the .part extension lying around somewhere.

  6. #146
    Sencha - Ext JS Dev Team Animal's Avatar
    Join Date
    Mar 2007
    Location
    Notts/Redwood City
    Posts
    30,496
    Vote Rating
    44
    Animal has a spectacular aura about Animal has a spectacular aura about Animal has a spectacular aura about

      0  

    Default


    OpenOffice uses McSoft's proprietary XLS format of spreadsheets.

    It does not use the open, documented XML format.

  7. #147
    Ext User
    Join Date
    Feb 2008
    Posts
    275
    Vote Rating
    0
    Rafael is on a distinguished road

      0  

    Default


    Why this undefined in excel ?

    I test with alert

    Code:
    alert(this.title);
    and return undefined .


    On the Problem of .part, i I decided with the following code http://extjs.com/forum/showthread.ph...047#post188047
    Attached Images

  8. #148
    Sencha - Ext JS Dev Team Animal's Avatar
    Join Date
    Mar 2007
    Location
    Notts/Redwood City
    Posts
    30,496
    Vote Rating
    44
    Animal has a spectacular aura about Animal has a spectacular aura about Animal has a spectacular aura about

      0  

    Default


    The Grid's title?

  9. #149
    Ext User
    Join Date
    Feb 2008
    Posts
    275
    Vote Rating
    0
    Rafael is on a distinguished road

      0  

    Default


    yes

  10. #150
    Ext User
    Join Date
    Dec 2008
    Posts
    1
    Vote Rating
    0
    TheBim is on a distinguished road

      0  

    Default


    i'm trying to use the code in the post 1, but something goes wrong. I'm using an EditorGridPanel....can i use that code with EditorGridPanel?

Thread Participants: 140

  1. alexb (1 Post)
  2. galdaka (3 Posts)
  3. ghyster (1 Post)
  4. Condor (1 Post)
  5. TopKatz (1 Post)
  6. Jul (1 Post)
  7. mystix (3 Posts)
  8. Foggy (2 Posts)
  9. bloon (1 Post)
  10. fshort (1 Post)
  11. antimatter15 (1 Post)
  12. cocinerox (1 Post)
  13. tobiu (1 Post)
  14. ajaxE (2 Posts)
  15. andreyz (1 Post)
  16. devnull (4 Posts)
  17. mjlecomte (4 Posts)
  18. kevinwu8 (1 Post)
  19. rakesh (1 Post)
  20. hendricd (2 Posts)
  21. gelleneu (1 Post)
  22. isaac (1 Post)
  23. huling (1 Post)
  24. ckr (1 Post)
  25. roopa (1 Post)
  26. loveyeah (1 Post)
  27. zhfxu_cs (1 Post)
  28. Mthor (1 Post)
  29. johnlicy (1 Post)
  30. thoreking (2 Posts)
  31. csqjean (1 Post)
  32. mankz (1 Post)
  33. vietschv (1 Post)
  34. verbi (1 Post)
  35. sanjshah (2 Posts)
  36. mask_hot (1 Post)
  37. calavera (1 Post)
  38. vsmike (1 Post)
  39. vizcano (1 Post)
  40. lakehouse (1 Post)
  41. alaska (2 Posts)
  42. radtad (3 Posts)
  43. jmcneese (1 Post)
  44. Rafael (4 Posts)
  45. calvouze (1 Post)
  46. Joyfulbob (1 Post)
  47. angeldimitrov (2 Posts)
  48. Jack_S (2 Posts)
  49. g13013 (2 Posts)
  50. DamienValentine (5 Posts)
  51. Marcelo Delgado (1 Post)
  52. NoahK17 (8 Posts)
  53. anujg (1 Post)
  54. aproust94 (3 Posts)
  55. pokerking400 (1 Post)
  56. Ronhead (1 Post)
  57. krzak (3 Posts)
  58. cvieira (1 Post)
  59. Efex (5 Posts)
  60. gthe (2 Posts)
  61. miihiir (2 Posts)
  62. pops (1 Post)
  63. emredagli (12 Posts)
  64. larsa (2 Posts)
  65. maggiesnyder (3 Posts)
  66. sam.zhang (1 Post)
  67. kristalgic (1 Post)
  68. wiznia (3 Posts)
  69. frpucci (1 Post)
  70. tinakonda (1 Post)
  71. tBSTAR (1 Post)
  72. tdg2008 (1 Post)
  73. iwagon (1 Post)
  74. psarunkumar (1 Post)
  75. kimmking (1 Post)
  76. sKuD24 (1 Post)
  77. MartinL (2 Posts)
  78. BitPoet (2 Posts)
  79. snoir (3 Posts)
  80. naranda (1 Post)
  81. zhw511006 (1 Post)
  82. bobjbain (1 Post)
  83. korto (1 Post)
  84. wp.joju (1 Post)
  85. hastiok (6 Posts)
  86. dtondo (4 Posts)
  87. Dumas (1 Post)
  88. vvreddy@12 (4 Posts)
  89. TheBim (1 Post)
  90. whodat (2 Posts)
  91. Skunkerbr (2 Posts)
  92. stevenhzj (4 Posts)
  93. Naokai (1 Post)
  94. wayned@escc (2 Posts)
  95. MuadDib-DK (1 Post)
  96. jsundquist (1 Post)
  97. hardc0re (2 Posts)
  98. hzwei (4 Posts)
  99. Galileo_Galilei (1 Post)
  100. SantaBarbarian (4 Posts)
  101. stevieke (1 Post)
  102. megmefleg (1 Post)
  103. Boccara Jonathan (1 Post)
  104. Surinder singh (2 Posts)
  105. KrullWarKing (1 Post)
  106. brandnewdrew (1 Post)
  107. MrRoyce (1 Post)
  108. Spongerusher (1 Post)
  109. teraphy (2 Posts)
  110. Pekka Karalahti (3 Posts)
  111. Sergii (1 Post)
  112. Cassio11 (1 Post)
  113. myth (1 Post)
  114. spor (6 Posts)
  115. StagnantIce (2 Posts)
  116. shailendra (2 Posts)
  117. ext_user1 (1 Post)
  118. kenny_mk (1 Post)
  119. mpacheco (1 Post)
  120. Centurus (1 Post)
  121. andyfly (1 Post)
  122. darmandovargas@gmail.com (1 Post)
  123. zjuthhy (3 Posts)
  124. robshim (3 Posts)
  125. Tod (1 Post)
  126. bipen (2 Posts)
  127. alisyah (1 Post)
  128. Monz87 (1 Post)
  129. alssst (1 Post)
  130. aggie (1 Post)
  131. bradelsky (1 Post)
  132. lagrezd (1 Post)
  133. ma1986 (1 Post)
  134. Sabareesh (2 Posts)
  135. top_1 (1 Post)
  136. Vasanthoo7 (1 Post)
  137. garrek99 (2 Posts)
  138. opik (1 Post)
  139. shankar8rajah1 (1 Post)
  140. tdobberphul (4 Posts)