1. #111
    Sencha User emredagli's Avatar
    Join Date
    Jun 2008
    Posts
    300
    Vote Rating
    0
    emredagli is on a distinguished road

      0  

    Default export grid to excel with GroupingStore and group summary

    export grid to excel with GroupingStore and group summary


    Hi Mr. Animal,
    I plan to use your extension to export grid to excel.
    But my grid use GroupingStore and I have group headers.
    I also have group summary rows.
    Is there a way to show these rows in excel?

    I paste your code to GridView3 Grouping example.
    But It is not export grouping headers to excel.

    Thanks for your advance.

  2. #112
    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


    You'll have to add them yourself. Here's a link to the MS documentation:

    http://msdn.microsoft.com/en-us/libr...ffice.10).aspx

    What I would do is practice handcoding the XML to represent the grouping rows, and then write the code to generate that XML.

    It's pretty simple if you look at the generated XML. It's just a glorified <table>

  3. #113
    Sencha User emredagli's Avatar
    Join Date
    Jun 2008
    Posts
    300
    Vote Rating
    0
    emredagli is on a distinguished road

      0  

    Default


    Mr. Animal you are right. It is not too difficult to modify.
    And I am use renderer functions to show field values.
    Code:
    t += cm.getRenderer(j)(v);
    And also I have to modify ss:ExpandedRowCount property to add extra rows (group headers rows).

    Thanks for your advance.

  4. #114
    Sencha User Ronhead's Avatar
    Join Date
    May 2008
    Location
    Santiasko,Chile
    Posts
    38
    Vote Rating
    0
    Ronhead is on a distinguished road

      0  

    Default


    hi animal

    i have a problem with your plugin, error is

    Code:
    document.location='data:application/vnd.ms-excel;base64,' +Base64.encode(grid.getExcelXml());
    in ff running too fast but in IE fail it

    if you know anything please tell me

    saludos!
    ron.

  5. #115
    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


    Quote Originally Posted by POST #1
    This needs a browser that supports data URLs. FF, Opera and IE8 will support this.
    .

  6. #116
    Sencha User emredagli's Avatar
    Join Date
    Jun 2008
    Posts
    300
    Vote Rating
    0
    emredagli is on a distinguished road

      0  

    Default setting excel file name

    setting excel file name


    Hii, Mr Animal,
    I search all messages in this thread and people asked that "how can we set file name?".
    Given solution is:
    Content-Disposition:attachment;filename=export_filename.xls

    Should I post new html page with header contains this parameters?

    thanks.

  7. #117
    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


    I don't think you can do this with data: URLs

    http://tools.ietf.org/html/rfc2397

  8. #118
    Sencha User emredagli's Avatar
    Join Date
    Jun 2008
    Posts
    300
    Vote Rating
    0
    emredagli is on a distinguished road

      0  

    Default


    Hii Mr. Animal,
    I search the link you post. But I couldn't find the solution...
    I try many combinations like:
    Code:
    linkButton.getEl().child('a', true).href = 'data:application/vnd.ms-excel;Content-Disposition:attachment;filename=export_filename.xls;name=hebe.xls;base64,' + Base64.encode(grid.getExcelXml());
    ...
    linkButton.getEl().child('a', true).href = 'data:application/vnd.ms-excel;Content-Disposition:attachment;file=export_filename.xls;name=hebe.xls;base64,' + Base64.encode(grid.getExcelXml());
    When I search in google I found a thread and in there they says that there is no way to do this.
    http://groups.google.com/group/mozil...dd1b37053742a4

    Do I miss something?
    you may regret to writing this component... (Because of questions...)

  9. #119
    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


    You missed my last post it seems.

  10. #120
    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


    Really, I only wrote it to illustrate how XML spreadsheets can be easily built using XML.

    People should take whats illustrated here, and write some code in their server-side to generate the XML.

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)