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.If the header of the first column of your CSV is "ID", Excel will complain when opening the file.
The file format and extension of 'file.csv' don't match. The file could be corrupted or unsafe. Unless you trust its source, don't open it. Do you want to open it anyway?
Excel has detected that 'file.csv' is a SYLK file, but cannot load it. Either the file has errors or it is not a SYLK file format. Click OK to try to open the file in a different format.
This is document at https://support.microsoft.com/en-us/kb/323626. The solution is to wrap "ID" in quotes.
While I acknowledge that this is a ridiculous Excel issue I believe it would be quite common to have ID as the first column header and a workaround could be provided in this module.
| Comment | File | Size | Author |
|---|---|---|---|
| #5 | csv-to-sylk-2802081-3.patch | 1.1 KB | Vernit |
| #2 | csv-to-sylk-2802081-2.patch | 631 bytes | Vernit |
| |||
Comments
Comment #2
VernitAlthough Header values should be in camel case. So i have submitted the patch for if mistakenly putted the ID or all uppercase values in headers.
Comment #3
VernitComment #4
VernitComment #5
VernitRevised patch with updation in tests classes.
Comment #6
grasmash CreditAttribution: grasmash commentedWhy is the solution to change everything to uppercase? Shouldn't you be checking to see if the first column header is ID and then conditionally modify it?
Comment #7
VernitYou may be right but my recommendation, Column header's character of each word should be uppercase. There are may be chance with other words in xls that breaks the functionality.
Comment #8
VernitComment #9
steinmb CreditAttribution: steinmb as a volunteer commentedComment #10
markdorisonPlease reopen with a merge request against 4.x if this issue is still relevant.