1. #161
    Sencha User
    Join Date
    Mar 2012
    Posts
    4
    Vote Rating
    0
    rdominelli is on a distinguished road

      0  

    Default


    Actually I do not think this is an excel 2010 thing. Prior to upgrading to 4.1 excel would give a warning but would open the file.

    Since upgrading to 4.1, the xml produced by the formatter is no longer valid xml. For example
    Code:
    <ss:Alignment ss:Vertical="Top" ss:WrapText="1"/> 0"><ss:Alignment ss:Vertical="Top" ss:WrapText="1"/>
    Cleaning up the dupes and removing the extra 0"> fixes the xml so excel is able to open the file again.
    Trying to pin down in the Style.js file where the issue is.
    Rch

  2. #162
    Sencha User
    Join Date
    Aug 2011
    Location
    Singapore
    Posts
    22
    Vote Rating
    0
    Aranair is on a distinguished road

      0  

    Default


    Mmm, that is possible too I guess.

    For me, I modified the code to remove ALOT of tags that were being generated and it does open in Excel 2010 thankfully. It no longer has any formatting though lol.

    Also, I'm on 4.1 mm

  3. #163
    Sencha User
    Join Date
    Mar 2012
    Posts
    4
    Vote Rating
    0
    rdominelli is on a distinguished road

      0  

    Default


    The attached replacement for Style.js seems to do the trick. Place this (after backing up the original) in exporter\excelFormatter

    I still get a warning opening the file in excel, but it will open it correctly now.

    Rich
    Attached Files

  4. #164
    Sencha User
    Join Date
    Aug 2011
    Location
    Singapore
    Posts
    22
    Vote Rating
    0
    Aranair is on a distinguished road

      0  

    Default


    Anyone know if its possible to create a REAL excel spreadsheet that doesn't consist of XML?:P

  5. #165
    Sencha User
    Join Date
    Jun 2011
    Posts
    12
    Vote Rating
    0
    shawon is on a distinguished road

      0  

    Default


    thanks rdominelli, your file did the trick now its showing the excel file, but shows an warning in the beginning.

    Can anyone have any solution for this?

  6. #166
    Sencha User
    Join Date
    Jun 2010
    Posts
    2
    Vote Rating
    0
    krishnarn1 is on a distinguished road

      0  

    Default Hi

    Hi


    Where can i download the latest code for export excel

  7. #167
    Sencha User
    Join Date
    Jan 2011
    Posts
    5
    Vote Rating
    0
    Mental is on a distinguished road

      0  

    Default


    I had successfully add button on my panel, but when i am clicking nothing happened, and i don't get any errors.
    What can i do with that ?

    code:
    Code:
            {
                   xtype: 'exporterbutton',
                   store: this.store,
                   formatter: 'excel',
                   downloadName: 'Trial licenses (new)',
                   swfPath: '/extjs/ux/exporter/downloadify.swf',
                   downloadImage: '/extjs/ux/exporter/download.png'
            }
    I don't using grid, I have panel with buttons and store with data.

    Plz help.

  8. #168
    Sencha User
    Join Date
    Jun 2011
    Posts
    12
    Vote Rating
    0
    shawon is on a distinguished road

      0  

    Default


    I also went through this kind of issues, its definitely failing on some where in the formatter, but that doesn't throws an error. Best is you have debug through the formatter, dig it down and see from which point it failing. I resolved that way.

  9. #169
    Sencha User
    Join Date
    Jan 2011
    Posts
    5
    Vote Rating
    0
    Mental is on a distinguished road

      0  

    Default


    It seems that this error is in Swf file, I have used flash with debuging and firefox gave this error.

    error.jpg

  10. #170
    Sencha User
    Join Date
    Jan 2011
    Posts
    5
    Vote Rating
    0
    Mental is on a distinguished road

      0  

    Default


    I found why I have this problem, it happens because I didn't set fields for the store and Exporter was not able to send fields to swf.

Thread Participants: 113

  1. dawesi (1 Post)
  2. feiji1983 (1 Post)
  3. isaac (1 Post)
  4. radtad (4 Posts)
  5. pavanextjs (5 Posts)
  6. aragm (1 Post)
  7. terjeio (1 Post)
  8. il Sergio (2 Posts)
  9. edspencer (1 Post)
  10. nitingautam (2 Posts)
  11. edykstra (3 Posts)
  12. kalchas (4 Posts)
  13. pardha (1 Post)
  14. shelly (1 Post)
  15. talha06 (3 Posts)
  16. vaucer (1 Post)
  17. SMMJ_Dev (7 Posts)
  18. Ekambos (1 Post)
  19. vispiron (1 Post)
  20. sdruckerfig (4 Posts)
  21. jwcraig (1 Post)
  22. dbrin (1 Post)
  23. scaddenp (2 Posts)
  24. grisevich (1 Post)
  25. semialcruz (3 Posts)
  26. krishnarn1 (1 Post)
  27. mikih (1 Post)
  28. Teemac (3 Posts)
  29. jpcoppol (1 Post)
  30. ssuarez (4 Posts)
  31. trinitrotoluen (1 Post)
  32. aladdina (1 Post)
  33. Mental (3 Posts)
  34. nuskin (5 Posts)
  35. droessner (5 Posts)
  36. HIG (1 Post)
  37. jjerome (4 Posts)
  38. bee (2 Posts)
  39. RAD001 (8 Posts)
  40. RNL (1 Post)
  41. shawon (4 Posts)
  42. parkcity (4 Posts)
  43. carlosgoias (1 Post)
  44. Ewoq (7 Posts)
  45. skotamreddy (1 Post)
  46. another_i (5 Posts)
  47. neerajbherwal (1 Post)
  48. nimda13 (2 Posts)
  49. acteon (2 Posts)
  50. ma1986 (2 Posts)
  51. pierrocknroll (1 Post)
  52. Aranair (7 Posts)
  53. clarkbanks (1 Post)
  54. linyajun (1 Post)
  55. delusion (2 Posts)
  56. Jay Tanwar (2 Posts)
  57. supermarcos (6 Posts)
  58. mmuzamil (1 Post)
  59. amishra06 (1 Post)
  60. hundare (1 Post)
  61. Ecthelion (1 Post)
  62. balajivaikar (2 Posts)
  63. jarobi (1 Post)
  64. ferchotipin (2 Posts)
  65. sebas2515 (3 Posts)
  66. arpeggian (3 Posts)
  67. a_kanin (1 Post)
  68. MeDigital (1 Post)
  69. Vasanthoo7 (3 Posts)
  70. jeora (1 Post)
  71. BlackLine (1 Post)
  72. mrhomer (7 Posts)
  73. KostasP (2 Posts)
  74. rdominelli (4 Posts)
  75. pksiv (1 Post)
  76. yoisen (2 Posts)
  77. opms (1 Post)
  78. Oxii (1 Post)
  79. sarz (6 Posts)
  80. gabsoftware (3 Posts)
  81. 9josh (1 Post)
  82. ananthk (2 Posts)
  83. psnprasad (1 Post)
  84. alex9311 (2 Posts)
  85. felix822 (2 Posts)
  86. mpasacrita@escholar.com (1 Post)
  87. Garry Hawkins (1 Post)
  88. chandrima31 (1 Post)
  89. this-is-sparta (1 Post)
  90. vitalz (7 Posts)
  91. Sheng_Yunzhou (2 Posts)
  92. xdengli (1 Post)
  93. sgscontact (1 Post)
  94. nitingogia@gmail.com (1 Post)
  95. Swetosuvro (1 Post)
  96. sudrak (1 Post)
  97. cdmein (1 Post)
  98. code4jhon (1 Post)
  99. felixfang (2 Posts)
  100. jayasingh1802 (2 Posts)
  101. abdul haq (3 Posts)
  102. luatbravo (1 Post)
  103. gilmaredo@gmail.com (1 Post)
  104. ricardo.lourival (1 Post)
  105. Sundarganesh Ramar (1 Post)
  106. madhavan281981 (1 Post)
  107. suvo (3 Posts)
  108. shankar8rajah1 (1 Post)
  109. benny_GI (1 Post)
  110. cojocarutudor (1 Post)
  111. arnoldvillasanta (4 Posts)
  112. tajashwin (1 Post)
  113. mangeshppatil (2 Posts)