1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Exporting special characters from php to Excel problem

Discussion in 'PHP' started by rekha, Jan 5, 2010.

  1. rekha

    rekha New Member

    Joined:
    Jan 17, 2008
    Messages:
    83
    Likes Received:
    0
    Trophy Points:
    0
    Hi,

    I am exporting my data from php to Excel.For example if my data is -R2500.00 this value is not exporting properly.It is exported as zero and in some cases it may result in invalid #name error.I used double quotes but still the problem is not solved.

    Anyone pls help....
     
  2. vb_reader

    vb_reader New Member

    Joined:
    Nov 4, 2009
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    0
    Home Page:
    how are you exporting the data? if you are using response, and content type. then change the charset appropriately . if you can tell what you are trying to export and what is actually exported. I can be more specific in what to do.
     
  3. rekha

    rekha New Member

    Joined:
    Jan 17, 2008
    Messages:
    83
    Likes Received:
    0
    Trophy Points:
    0
    Hi,

    Thanks for your reply.I have used header("Content-type: application/csv");
     
  4. rekha

    rekha New Member

    Joined:
    Jan 17, 2008
    Messages:
    83
    Likes Received:
    0
    Trophy Points:
    0
    Anyone pls solve my issue.
     

Share This Page