Tag Archives: comma-separated-value file

Load a CSV file in Excel in C#

Loading a CSV file (comma-separated value file) into Excel isn’t too hard once you know the tricks. Using the same tricks you can load a file that uses any delimiter, not just a comma. First at design time, add a … Continue reading

Posted in Excel, files, Office | Tagged , , , , , , , , , , , , | 5 Comments

Read a CSV file into an array in C#

The following LoadCsv method reads the CSV file into a two-dimensional array of strings. // Load a CSV file into an array of rows and columns. // Assume there may be blank lines but every line has // the same … Continue reading

Posted in files, strings | Tagged , , , , , , , , , , , | 39 Comments