SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Wizard
    Join Date
    Feb 2007
    Location
    Southern California
    Posts
    1,338
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Exporting database content as Excel file to display on Windows 7 appears corrupted

    How do you export a MySQL database content to open up in Excel 2010? The file will download and open up fine in an XP or Vista machine, but in Windows 7, Excel 2010 and earlier says the file is corrupted and advices us to use the Repair tool on the file. Using the Repair tool simply fails silently and the file does not open. Changing the xls extension to csv doesn't open the file in Excel 2010 either. It appears to be a Windows 7 issue, since it displays in Excel in earlier versions of Windows.

    Did you have to make any particular updates to your code for display on Windows 7? Is so, what were they?

  2. #2
    SitePoint Wizard
    Join Date
    Feb 2007
    Location
    Southern California
    Posts
    1,338
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Does anyone format MySQL data to be downloaded as Excel? I thought it was pretty common. With this format on Win7, it seems that we need to take another look at our code.


Bookmarks

Posting Permissions

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