ng-csv icon indicating copy to clipboard operation
ng-csv copied to clipboard

Excel 2011 renders data all in one column

Open thierryskoda opened this issue 8 years ago • 3 comments

It works for me with my excel 2016, but with another computer and different version of excel, it puts all my data in on column divided by a comma.

Thank you for the help!

thierryskoda avatar Apr 07 '16 17:04 thierryskoda

I think you need a special header for excel.

I created a pull request to overpast this question but it wasn't merged yet :/

lneves12 avatar Apr 07 '16 17:04 lneves12

Thank you for the quick reply! I hope it will be merged soon haha!

thierryskoda avatar Apr 07 '16 17:04 thierryskoda

Depending on your locale Excel has a different list of field separators. More info Stackoverflow. This post also discusses the sep=, value written to the file.

waxxxd avatar May 12 '18 14:05 waxxxd