|
So we got an call from a client complaining that he couldn't open a CSV file we generated.
Excel gave the error that the file format was incorrect for the SYLK file type.
Apparently, Excel treats a file as SYLK (whatever that is) when it starts with "ID": "SYLK: File format is not valid" error message when you open file[^]
We changed the column from "ID" to "Id" and all works as expected.
What the hell Microsoft... 
|
|
|
|
|
Sander Rossel wrote: client
Sander Rossel wrote: Excel
Sander Rossel wrote: CSV
Sander Rossel wrote: Microsoft
Reads like the ingredients for a dish best served cold...
|
|
|
|
|
A recipe for disaster! 
|
|
|
|
|
So thats what has been causing it. renamed the first column and all is well, thanks for this info
WTE Microsoft, whats with these magic values??
|
|
|
|
|
|
Did you just do my Googling for me?
That must be a first on CP!
|
|
|
|
|
|
|
404, although my post has a link to KB as well
|
|
|
|
|
That's weird. It went right to it when I posted it. Now I've got a Not Found, too.
|
|
|
|
|
Did you start your URL with "ID"?
|
|
|
|
|
|
Just tried in Excel 2016, and it's sort-of fixed.
First you get a message telling you that the file format and extension do not match; the file is corrupt or unsafe; don't open it unless you trust the source.
When you click "Yes" to open it anyway, you get another message telling you that Excel decided it was an SYLK file, but couldn't load it; either the file has errors, or it's not an SLYK file; click "OK" to try opening it in a different format.
When you click "OK" in that message, the file opens as expected.
Interestingly, if you save the file from Excel, you don't get any warnings, and it doesn't insert the apostrophe listed in the "Workaround" section from that KB article. Probably because that would break the file for applications which don't try to second-guess the file type based on the content. 
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Yeah, we could ignore the warnings too, but stuff like this is just annoying, magical and logic defying.
|
|
|
|
|
The wheels are loose everywhere today and the things we took for granted are no longer.
Those kids with the far away look in their eyes are now at the controls. There is no other way to explain what we are seeing today in terms of things that should never be in software.
|
|
|
|
|
Ron Anders wrote: There is no other way to explain what we are seeing today
It is explained by the new retro:
RETRO-EVOLUTION
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
I was working on a PIC project, I had a '.s' extension on an assembler source file, and it would fail to build, after much ado (me beating my head against a wall) I changed it to '.S' and it worked like a champ, aaarrrggg!!!
"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment
"Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
|
|
|
|
|
Wow 
I was recently working with Groovy and it picks up any .groovy, .gvy, .gy and .gsh files.
I guess that's the other extreme
|
|
|
|
|
Educator Piss maybe for this inspection (5,7)
Audit process
We can’t stop here, this is bat country - Hunter S Thompson RIP
modified 18-Jul-17 9:39am.
|
|
|
|
|
Oscar dispute? ( no idea...)
|
|
|
|
|
Nope
We can’t stop here, this is bat country - Hunter S Thompson RIP
|
|
|
|
|
And I still have not a clue what it is - the best I could come up with was anagrams of "Educator piss":
audit corpses
caped suitors
cider outpass None of which were particularly relevant... 
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Yup - or "Peer review" with extra letters added somehow?
|
|
|
|
|
Ah! Missed that!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
