[CLOSED] Excel exporting issue

  1. #1

    [CLOSED] Excel exporting issue

    I'm trying to export a gridpanel to an excel file like in this example:
    https://examples1.ext.net/#/GridPane...ort_Data_Ajax/

    After the file is exported i can't open it. Excel says it "cannot open fles of this type", and scalc (openoffice) open a file with a single cell with all the information misconfigured.
    What should i do to make it work?
    Last edited by Daniil; Oct 21, 2010 at 2:21 PM. Reason: [CLOSED]
  2. #2
    Hi Pablo,

    Please provide us with your sample code.

    Can you open files which are produced in the example you mentioned?
    https://examples1.ext.net/#/GridPane...ort_Data_Ajax/
    Last edited by Daniil; Oct 20, 2010 at 4:10 PM.
  3. #3

    Excel 2007

  4. #4
    Daniil, i can't open the files generated by the example either. Same error.
    mxp, i guess that's not the problem, since i tried excel viewer 2006 with same results.
  5. #5
    I just tried to open a file generated by the example. Successful.

    Seems the issue with your applications or OS.

    Please post here .xls file (zipped). I will try to open it on my machine.
  6. #6
    Thanks Daniil. Here goes the file: submittedData.zip
  7. #7
    Successful.

    Now it's obviously that the issue is related to applications that you use to open a file or (and) OS.
  8. #8
    Ok. Thanks for the help. Could you please just tell me your version of excel / windows?
  9. #9
    Hi,

    That export sample is just for demonstrate how to download file via ajax. It doesn't guarantee that export format is correct (because it is not target of sample). Excel exporting just transform to XML (which can be readable by Excel), it is not real XLS format. If you need real Excel transformation then I think you have to use another 3rd party toolkits are designed for export to another formats (like iTextSharp)
  10. #10
    Sure.

    Windows 7 Home Premium
    Microsoft Office 2007

Similar Threads

  1. Exporting Grid Data for Excel, CSV, XML, HTML, PDF [EXAMPLE Codes]
    By fatihunal in forum Examples and Extras
    Replies: 6
    Last Post: Oct 07, 2016, 1:50 PM
  2. [CLOSED] hide a field while exporting data to Excel
    By Fahd in forum 1.x Legacy Premium Help
    Replies: 4
    Last Post: Jun 20, 2012, 4:46 PM
  3. Exporting gridpanel content to excel
    By sonlas7y20 in forum 1.x Help
    Replies: 2
    Last Post: Dec 13, 2011, 8:01 PM
  4. exporting to excel with gridfilters on
    By norphos in forum 1.x Help
    Replies: 0
    Last Post: Oct 18, 2011, 1:14 PM
  5. Replies: 0
    Last Post: Sep 05, 2011, 10:01 AM

Posting Permissions