Hi,
I was getting the following error message when opening spreadsheets generated using the Views Excel Export module.
"The format of the file you are trying to open, 'filename.xls' is different from that specified by the file extension. Before opening the file, verify that it is not damaged and that comes from a trusted source."
I did some research and discovered that the problem was the php-excel class being used to generate spreadsheets. The class is outdated and is no longer supported by Microsoft Excel.
To correct the problem, I downloaded and installed the PHPExcel Library to the sites/all/libraries folder of my Drupal site. Next, I updated the Views Excel Export module to load the PHPExcel library and generate spreadsheets using the PHPExcel class provided.
My solution worked, and I am now able to generate spreadsheets which do not produce the "file format" error message when opened.
In the event that my solution is helpful to others, I will create a patch and attach it to this thread. Patch to follow.
Thanks,
Gordon
Comment | File | Size | Author |
---|---|---|---|
#5 | 2669920-port-to-phpexcel-5.patch | 14.4 KB | kristofferwiklund |
#2 | 2669920-port-to-phpexcel.patch | 15.64 KB | gturnbull |
Comments
Comment #2
gturnbull CreditAttribution: gturnbull commentedComment #3
ilaz CreditAttribution: ilaz commentedThe .patch works.
Comment #4
gturnbull CreditAttribution: gturnbull commentedComment #5
kristofferwiklund CreditAttribution: kristofferwiklund at Websystem commentedHere comes a patch for applying on latest dev branch.