Search code examples
c#linqtocsv

LinqToCsv Set Column Width

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?

Solution

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