Results 1 to 10 of 10

Thread: Unable to Open Excel File When Using Excel Export Plugin

  1. #1

    Default Unable to Open Excel File When Using Excel Export Plugin

    Hello all,

    I am using the 'gridexporter' plugin in my application and can export the grid fine. When I try to open the excel file I get the error, "Excel found unreadable content in 'file.xlsx'. Do you want to recover the contents of this workbook?"

    Is there anything I can do to eliminate getting this error when exporting?

    Thanks!

  2. #2
    Sencha User
    Join Date
    Feb 2013
    Location
    California
    Posts
    11,985
    Answers
    506

    Default

    With which version of Excel are you using seeing this? Is it able recover the contents if you choose that?

  3. #3

    Default

    I'm using Excel 2010. The contents recover fine and it displays without anything missing I was just trying to avoid that error message popping up.

    Thanks flr for the reply!

  4. #4
    Sencha User
    Join Date
    Feb 2013
    Location
    California
    Posts
    11,985
    Answers
    506

    Default

    That should be fine. With which version of Ext JS are you seeing this? if 6.2.1, can you test against a 6.2.2 nightly to see if this is the same issue as a bug that was recently fixed?

  5. #5
    Sencha User
    Join Date
    Sep 2017
    Posts
    19

    Default

    @Gary ,I'm facing this issue with 6.0.2 version and not able to view the contents in MS excel,any workaround for this ?

    Thanks,
    Ashok.

  6. #6
    Sencha Premium User wemerson.januario's Avatar
    Join Date
    Nov 2008
    Location
    Goiânia - GO, Brazil
    Posts
    902
    Answers
    15

    Default

    Quote Originally Posted by ashok9 View Post
    @Gary ,I'm facing this issue with 6.0.2 version and not able to view the contents in MS excel,any workaround for this ?

    Thanks,
    Ashok.
    Maybe you have an unaccepted especial character on sheet title. Can you posta code showing how you are saving document or a fiddle?
    Wemerson Januario @JanuarioCoder
    Novanti Tecnologia, Sencha MVP/ Ext JS Consultant
    ____________________________________________
    Hire me on UpWork:

    GitHub
    https://github.com/wemersonjanuario

    Treinamento e Consultoria Ext JS. QUALIFIQUE-SE JÁ!

  7. #7
    Sencha User
    Join Date
    Sep 2017
    Posts
    19

    Default

    Quote Originally Posted by wemerson.januario View Post
    Maybe you have an unaccepted especial character on sheet title. Can you posta code showing how you are saving document or a fiddle?
    The data/code doesn't have any special characters.

  8. #8
    Sencha Premium User wemerson.januario's Avatar
    Join Date
    Nov 2008
    Location
    Goiânia - GO, Brazil
    Posts
    902
    Answers
    15

    Default

    Can you post a code showing how you are saving document or a fiddle? this will help us to help you!
    Wemerson Januario @JanuarioCoder
    Novanti Tecnologia, Sencha MVP/ Ext JS Consultant
    ____________________________________________
    Hire me on UpWork:

    GitHub
    https://github.com/wemersonjanuario

    Treinamento e Consultoria Ext JS. QUALIFIQUE-SE JÁ!

  9. #9
    Sencha User
    Join Date
    Sep 2017
    Posts
    19

    Default

    Quote Originally Posted by wemerson.januario View Post
    Can you post a code showing how you are saving document or a fiddle? this will help us to help you!
    this.up('grid').saveDocumentAs({
    type: 'xls',
    fileName:Report+'.xls'
    });

  10. #10
    Sencha Premium User wemerson.januario's Avatar
    Join Date
    Nov 2008
    Location
    Goiânia - GO, Brazil
    Posts
    902
    Answers
    15

    Default

    Quote Originally Posted by ashok9 View Post
    this.up('grid').saveDocumentAs({
    type: 'xls',
    fileName:Report+'.xls'
    });

    try this: type: 'excel'

    Code:
    this.up('grid').saveDocumentAs({
        type: 'excel',
        title: 'MyReport',
        fileName:Report+'.xls'
    });
    Wemerson Januario @JanuarioCoder
    Novanti Tecnologia, Sencha MVP/ Ext JS Consultant
    ____________________________________________
    Hire me on UpWork:

    GitHub
    https://github.com/wemersonjanuario

    Treinamento e Consultoria Ext JS. QUALIFIQUE-SE JÁ!

Similar Threads

  1. how can I export a grid into a excel file?
    By betochh in forum Ext: Q&A
    Replies: 1
    Last Post: 9 Oct 2014, 6:17 AM
  2. Export Excel file in Extjs
    By VijayBhaskar in forum Ext: Q&A
    Replies: 4
    Last Post: 9 Oct 2013, 5:54 PM
  3. How to export GridPanel data into excel file?
    By orangejs in forum Ext 3.x: Help & Discussion
    Replies: 4
    Last Post: 14 Jun 2010, 6:00 PM
  4. Export to Excel File Name
    By sree in forum Ext 2.x: Help & Discussion
    Replies: 3
    Last Post: 22 Nov 2008, 12:07 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •