Exporting to CSV with Leading Zeroes from a StreamWriter
April 12, 2017
12:04 pm
When you are exporting a DataRow value using a Stream Writer to formats like CSV, we write as dr[counter].ToString(). If this value starts with zero, Excel removes the leading zeroes (unless the column is formatted as text). In order to fix this, we would need to manually write that as