3 ms·
I ran into a nasty bug(?) recently in the way Excel processes CSVs. I create a well formed CSV from a Java Web app which the user downloads. They open the CSV
by ghiotion 19y ago
I ran into a nasty bug(?) recently in the way Excel processes CSVs. I create a well formed CSV from a Java Web app which the user downloads. They open the CSV up in Excel and modify the data for an eventual upload. However, during the save process, Excel truncates trailing commas. Which causes my well formed CSV to be a poorly formed CSV during upload and parsing. Not fun.
- edw519 19y agoNever knew that. Once I cut a CSV for someone else, I never wanted to see it again. Now I know why.
- malkia 19y agoFor such type of thing you should always have something at the last column, even return might be enough A,B,,,,,,,," " C,D,,,,,,,," " That's newline there between " and " I guess Excel loads that internally through a convertor, trims the rightmost unused columns, and then saves it that way.