ios - Programmatically generated CSV file format issue for Excel and Numbers -


in ios project, have programmatically generated csv file data. of time, looks microsoft excel , apple numbers open with.

but when cell data 5 - 60, seems excel automatically convert date value may-60, while numbers open correctly.

i have found thread: https://stackoverflow.com/a/165052/833885, solution makes excel happy using "=""5 - 60""". make numbers shows ="5 - 60"......

you can generate empty csv file test described above.

is possible generate csv file makes world happy???

thanks in advance.

you can create new file in excel , import data ribbon tab - gives options specify data types 'columns' in csv. bit of pain avoid issue.


Comments

Popular posts from this blog

Ansible warning on jinja2 braces on when -

Parsing a protocol message from Go by Java -

html - How to custom Bootstrap grid height? -