1. #51
    Ext JS Premium Member
    Join Date
    Jun 2008
    Posts
    19
    Vote Rating
    0
    larsa is on a distinguished road

      0  

    Default


    How do i set the filename to be used for saving?
    /Lars

  2. #52
    Ext JS Premium Member
    Join Date
    May 2007
    Posts
    46
    Vote Rating
    1
    fshort is on a distinguished road

      0  

    Default


    in the response header, set:

    Content-Disposition:attachment;filename=export_filename.xls

  3. #53
    Ext JS Premium Member
    Join Date
    Jun 2008
    Posts
    19
    Vote Rating
    0
    larsa is on a distinguished road

      0  

    Question set response header in javascript?

    set response header in javascript?


    But how do i set the response header in the client, with Javascript?
    /Lars

    Code:
     
    bbar: new Ext.Toolbar({
    buttons: [{
    id: 'grid-excel-button',
    text: 'Exportera till Excel...',
    handler: function(){
    document.location='data:application/vnd.ms-excel;base64,' + Base64.encode(Ext.getCmp("mygrid").getExcelXml());
    }
    }]
    })
     
    }

  4. #54
    Ext User
    Join Date
    Nov 2007
    Posts
    63
    Vote Rating
    0
    thoreking is on a distinguished road

      0  

    Smile null cell cause problem

    null cell cause problem


    Hi,
    nice addon indeed.
    I have some date in my grid and each time a cell is null ( no date ), the code report an error in

    Code:
    if (cellType[k] == 'DateTime') {
    		t += v.format('d-m-Y');
    because v does not exist.

    any idea how I could fix it ?

    Thanks very much

    T

  5. #55
    Ext User
    Join Date
    May 2007
    Location
    jakarta
    Posts
    9
    Vote Rating
    0
    bloon is on a distinguished road

      0  

    Default


    I think should be add with Ext.isEmpty ?
    like this
    Code:
    if (cellType[k] == 'DateTime') {
    if (Ext.isEmpty(v)==false) {
    t+=v.format('d-m-Y');
    }
    Last edited by mystix; 19 Jun 2008 at 5:46 PM. Reason: use [code][/code] tags

  6. #56
    Ext User
    Join Date
    Nov 2007
    Posts
    63
    Vote Rating
    0
    thoreking is on a distinguished road

      0  

    Default


    thank you.

    I fixed the error with empty date cell by doing that :
    Code:
    if (cellType[k] !== "None") {
    						if (!v) {t += '<ss:Cell ss:StyleID="' + cellClass +'"></ss:Cell>';}
    							
    						else {
    							t += '<ss:Cell ss:StyleID="' + cellClass + cellTypeClass[k] + '"><ss:Data ss:Type="' + cellType[k] + '">';
    								if (cellType[k] == 'DateTime') {
    									t += v.format('Y-m-d');
    								} else {
    									t += v;
    								}
    							t +='</ss:Data></ss:Cell>';
    						}
                        }
    and everything is fine.

    still no idea how to make it work on ie ?

  7. #57
    Ext User
    Join Date
    May 2008
    Posts
    21
    Vote Rating
    0
    miihiir is on a distinguished road

      0  

    Default


    Hi,

    I am using this .. but getting the following error -

    fld has no properties

    switch(fld.type) {
    on line 164 of ExportGridToExcel.js ...

    Any idea?

    I have a Grouping enabled grid that has first column as hidden.

    Thanks.

    Mihir

  8. #58
    Ext User
    Join Date
    May 2008
    Posts
    59
    Vote Rating
    0
    gthe is on a distinguished road

      0  

    Default


    Quote Originally Posted by miihiir View Post
    Hi,

    I am using this .. but getting the following error -

    fld has no properties

    switch(fld.type) {
    on line 164 of ExportGridToExcel.js ...

    Any idea?

    I have a Grouping enabled grid that has first column as hidden.

    Thanks.

    Mihir
    First, sorry for my English.
    I have same error. That because I add RowAction in ColumnModel and it create field, that don't have cm.getDataIndex() property and it generate error.
    To fix :
    1. (about 148 row)
    Code:
    for (var i = 0; i < cm.getColumnCount(); i++) {
    if ((includeHidden || !cm.isHidden(i)) && (cm.getDataIndex(i))) {
    2. (about 204 row):
    Code:
     ss:ExpandedColumnCount="' + (visibleColumnCount +2) +
    '" ss:ExpandedRowCount="' + (this.store.getCount() + 2) + '">' +
    May be it is dirty, but work for me

  9. #59
    Ext User
    Join Date
    Apr 2008
    Location
    PARIS
    Posts
    9
    Vote Rating
    0
    aproust94 is on a distinguished road

      0  

    Exclamation UTF8 issue

    UTF8 issue


    Hi All,

    Animal, Thanks for this great extension.

    I get an issue with utf-8 encoding. If I have a word like this one 'Cr
    http://www.123messagepro.com convert your text into vocal message with background music !!

  10. #60
    Sencha - Community Support Team mankz's Avatar
    Join Date
    Nov 2007
    Location
    Stockholm, Sweden
    Posts
    2,748
    Vote Rating
    106
    mankz is a name known to all mankz is a name known to all mankz is a name known to all mankz is a name known to all mankz is a name known to all mankz is a name known to all

      0  

    Default a

    a


    It's all in the first post: This needs a browser that supports data URLs. FF, Opera and IE8 will support this.
    Last edited by mankz; 26 Jun 2008 at 3:44 AM. Reason: a

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)