Re:A straightforward way to extend CSV with metadata
by awild on Thursday August 19, 2021 @01:23PM
(#28236664)
Excel will strip leading zeros of your data, even when you're escaping it, it will also assume that that single cell of a Column of dot-separated floats is in fact a date. Excel is in fact so good at detecting formats that even if you construct an xls fill it with ids which partially start with zeros, properly mark them as strings, it will still nag you at every single cell of your file that there is something fishy about the file.
[ Parent
| on HN ]