locked
Setting Row Headers In A CSV

Respuestas

  • No error checking here to ensure that each row actually contains the columns, but you get the idea:

       List<string[]> parsedData = new List<string[]>();
    
       using (StreamReader readfile = new StreamReader(path))
       {
        string line;
        string[] row;
    
        while ((line = readfile.ReadLine()) != null)
        {
         row = line.Split(',');
         parsedData.Add(new string[]{row[5], row[8]});
        }
       }

    Additionally, I would look for a better storage mechanism than a List of strings, perhaps a List of classes that would better describe the data.

    It would be greatly appreciated if you would mark any helpful entries as helpful and if the entry answers your question, please mark it with the Answer link.


    martes, 13 de marzo de 2012 12:38

Todas las respuestas

  • No error checking here to ensure that each row actually contains the columns, but you get the idea:

       List<string[]> parsedData = new List<string[]>();
    
       using (StreamReader readfile = new StreamReader(path))
       {
        string line;
        string[] row;
    
        while ((line = readfile.ReadLine()) != null)
        {
         row = line.Split(',');
         parsedData.Add(new string[]{row[5], row[8]});
        }
       }

    Additionally, I would look for a better storage mechanism than a List of strings, perhaps a List of classes that would better describe the data.

    It would be greatly appreciated if you would mark any helpful entries as helpful and if the entry answers your question, please mark it with the Answer link.


    martes, 13 de marzo de 2012 12:38
  • hi,

    I have a CSV and need to be able to brake down each row and column so that I can select indervidual cells within the CSV and set them as an object (i think). I would like to select the "Date" from the CSV which may be in "C3" and a value which may be in "C7" and nothing else.

    Is this possible? 

    martes, 13 de marzo de 2012 15:41
  • You may want to take a look at this post:

    http://social.msdn.microsoft.com/Forums/en-US/csharplanguage/thread/12c8f825-966c-4900-b1e6-d1bc520e5520

    Since it is almost identical to what you had posted there.


    It would be greatly appreciated if you would mark any helpful entries as helpful and if the entry answers your question, please mark it with the Answer link.


    • Editado TSoftware martes, 13 de marzo de 2012 15:55
    • Propuesto como respuesta servy42 martes, 13 de marzo de 2012 18:30
    martes, 13 de marzo de 2012 15:55