4 ms·
I used Excel recently and it added a BOM, which is pretty awful. Is there any way to stop that nonsense?
by shellac 5y ago
I used Excel recently and it added a BOM, which is pretty awful. Is there any way to stop that nonsense?
- cpach 5y agoAFAIK: Nope. Microsoft loves that BOM, for reasons I cannot comprehend.
- andylynch 5y agoAlmost certainly for backwards compatibility. Excel in particular uses the BOM as a single to open a file in a Unicode encoding, rather than cp1252 etc.
- dbsmith83 5y agoI use a script to strip it from the file. Definitely not ideal.