Page 15 of 30 FirstFirst ... 5131415161725 ... LastLast
Results 141 to 150 of 296

Thread: GridPanel directly to Excel.

  1. #141
    Sencha User
    Join Date
    Feb 2009
    Posts
    13
    Vote Rating
    0
      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
      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
      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 User mystix's Avatar
    Join Date
    Mar 2007
    Location
    Singapore
    Posts
    6,236
    Vote Rating
    5
      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,615
    Vote Rating
    55
      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
      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 Attached Images

  8. #148
    Sencha - Ext JS Dev Team Animal's Avatar
    Join Date
    Mar 2007
    Location
    Notts/Redwood City
    Posts
    30,615
    Vote Rating
    55
      0  

    Default

    The Grid's title?

  9. #149
    Ext User
    Join Date
    Feb 2008
    Posts
    275
    Vote Rating
    0
      0  

    Default

    yes

  10. #150
    Ext User
    Join Date
    Dec 2008
    Posts
    1
    Vote Rating
    0
      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?

Page 15 of 30 FirstFirst ... 5131415161725 ... LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •