Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
When my clients download an excel file via views data export they get the following error message when they try to open the file:
Error opening file: "The file format differs from the format that the file name extension specifies. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?"
Obviously, if they just choose yes the file opens just fine, but is there anything we can do to avoid flagging excel about the format differing from the file extension?
Thanks,
Comments
Comment #1
rclai CreditAttribution: rclai commentedI get this as well.
Comment #2
johnvIndeed, the export is not a true xls. See #1008246: XLS-output is not recognised by Excel 2007
There is also a new project PHPExcel, that should generate correct files.