LinqToCsv Set Column Width

Question

I am using LinqToCsv to export data from a database to a csv file. One of the columns is a DateTime object. Upon export, the DateTime column shows up as "#######" until I manually expand the column width to fit the entire DateTime output. Is there a way to manually set column widths so that I don't have to manually expand the row every time?

score 1 · Accepted Answer · answered Dec 27 '16 at 18:25

1

A csv file has no concept of column widths. You could possibly export an .xlsx file instead using a library such as EPPlus

answered Dec 27 '16 at 18:25

Stewart_R

13,764
11
60
106

score 0 · Answer 2 · answered Dec 27 '16 at 18:35

CSV has no format attached. It is a plain text file comma/semicolon separated. You see the file that way because Excel is showing "empty" style for it. If you open the file with a notepad you´ll see the data correctly. If you need any style you´ll have to migrate to a XLSX or XLS file.

LinqToCsv Set Column Width

2 Answers2