I've got a project that I'm sending output to a CSV file.
Some of the fields have commas in them and some of the fields have spaces.
When I attempt to open the file with a double click or Process.Start, the
default application opens it: MS Excel. This is fine.
However, every time Excel opens one of these files, it defaults to a "Fixed
Width" data type.
I have tried encapsulating each of my cells in quotes, and I have replaced
all of the commas with dots, but neither has solved this problem.
I understand how to go into the Text Import Wizard of Excel to set the data
type as a delimited file using commas, but this app is going out to
supervisors and managers in our plant that aren't so good with computers.
Is there some setting that I can use to ensure that my files default as a
delimited file without physically creating a proprietary MS Excel file?
I can not replace the spaces in the cells, because those are required to
have a proper model numbers in our company.
I appreciate any help.