1. #111
    Sencha User
    Join Date
    Nov 2011
    Posts
    2
    Vote Rating
    0
    balajivaikar is on a distinguished road

      0  

    Default


    I'm having a datagrid with multi level of headers, and these header-text and row data for these headers are not getting exported to excel. Could anyone help me out ?

  2. #112
    Sencha User
    Join Date
    Aug 2007
    Posts
    11
    Vote Rating
    0
    isaac is on a distinguished road

      0  

    Default


    I have tried both the example downloads as well as tried to use this in my grid. The sw is working great. But MS Office for Mac 2011 cannot open the xls file (which I rename to xlsx, since xls is binary format) It complains about the format of the file being incorrect. OpenOffice on my linux box will open the downloaded file. But open office and office 2011 on my mac will not. Also, google docs will produce an error when trying to import the xlsx. I think the resulting xlsx file being generated is invalid. But I'm not sure how to proceed.

  3. #113
    Sencha User
    Join Date
    Jun 2008
    Posts
    157
    Vote Rating
    0
    wiznia is on a distinguished road

      0  

    Default


    Yeah, there are problems with different versions and programs, that's why I ended up using the csv exporter, which is included.
    For multi-header grids, I never tried it and it's probably not working right now, pull requests are wellcome in the github project.

  4. #114
    Ext JS Premium Member
    Join Date
    Jan 2012
    Posts
    33
    Vote Rating
    0
    Vasanthoo7 is on a distinguished road

      0  

    Default


    HI Wiznia, this is a great post. I got everything through with the set up and when I tried to download the file as excel, it downloads it.

    When I open the excel file I get the following error.

    The file you are trying to open 'download.xls' is in a different format than specified by the extension, Verify that the file is not corrupted. I am using EXTJS4. Can you please help me out with this.

  5. #115
    Sencha User
    Join Date
    Jun 2008
    Posts
    157
    Vote Rating
    0
    wiznia is on a distinguished road

      0  

    Default


    As I said, there seems to be problems with different versions and programs to open the xls.Try it first with the csv exporter to see if the data gets exported correctly

  6. #116
    Ext JS Premium Member
    Join Date
    Jan 2012
    Posts
    33
    Vote Rating
    0
    Vasanthoo7 is on a distinguished road

      0  

    Default


    Hi Wiznia, Thanks for the quick reply. the CSV export works well except a few issues:

    The first column in the header is taking this character:  

    Also the date columns are showing as ####### as the value for start and end date.

    ===

    If you could also point me in the right direction for uploading excel or csv file onto a grid using EXTJS 4. that would be great.

  7. #117
    Sencha User
    Join Date
    Jun 2008
    Posts
    157
    Vote Rating
    0
    wiznia is on a distinguished road

      0  

    Default


    What is the config for the first column? It should be using the column text or name properties. As for the dates, is the xtype of the column "datecolumn"? Do you have a format specified?
    I don't know if it's possible to upload an excel or csv to a grid. You should probably receive the file server side and then serve it to the grid.

  8. #118
    Ext JS Premium Member
    Join Date
    Jan 2012
    Posts
    33
    Vote Rating
    0
    Vasanthoo7 is on a distinguished road

      0  

    Default


    HI Wiznia, Thank you for replying. I was able to do it successfully with CSV, now the excel, really need to get it working as a excel, It is downloading a excel file, when i open the excel with notepad i see the Grid data in the notepad.

    When i open as Excel, it gives me the following error:


    The file you are trying to open is in a difffernt format than specified by the extension. Verify that the file is from a trusted source before opening the file. Do you want to open the file now.

    When i click on yes, I still am nt able to open the file.

  9. #119
    Sencha User
    Join Date
    Jun 2008
    Posts
    157
    Vote Rating
    0
    wiznia is on a distinguished road

      0  

    Default


    mmm, you can try the fixes that are in this pull request:
    https://github.com/iwiznia/Ext.ux.Exporter/pull/3
    If it works I can merge it with the main branch.

  10. #120
    Sencha User
    Join Date
    Aug 2011
    Location
    Ankara
    Posts
    13
    Vote Rating
    0
    acteon is on a distinguished road

      0  

    Default


    I think exporter should not require Button since exporter works without it .

Thread Participants: 115

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