Export CSV indhold til Excel

En af Process.Start overloads vil jeg tro.

kan du være lidt mere specifik?

Jeg brugte ClosedXML reference til at export CSV data i et excel ark.

Til andre:


        List<string> csvlines = new List<string>();


        try
        {
            using (StreamReader sr = new StreamReader(@"C:\Users\" + username + "\\Desktop\\TimeTracking.txt"))
            {
                string currentLine;
                // currentLine will be null when the StreamReader reaches the end of file
                while ((currentLine = sr.ReadLine()) != null)
                {
           
                    csvlines = currentLine.Split(',').ToList();
                      // csvlines.Add(currentLine);
                }
            }
        }

        catch(Exception ee)
        {
            System.Windows.MessageBox.Show(ee.Message);
        }
        var workbook = new XLWorkbook();
        var worksheet = workbook.Worksheets.Add("Time");

        worksheet.Cell(1, 1).Value = "TaskName";
        worksheet.Cell(1, 2).Value = "SpentTime";
        worksheet.Cell(1, 3).Value = "Date";

        var rangeWithList = worksheet.Cell(2, 1).InsertData(csvlines);

      // foreach (string csv in csvlines)
        //{
         
              // worksheet.Cell(1,7).Value = csv.ToString();
      // }
        workbook.SaveAs("C:\\Users\\"+username+"\\Desktop\\Timeregistration.xlsx");
    }

Det er lige ud af landevejen.

Demo:

using System;
using System.Diagnostics;

namespace E
{
    public class Program
    {
        public static void Main(string[] args)
        {
            Process.Start(@"C:\Office14\EXCEL.EXE", @"C:\Work\z.csv");
        }
    }
}

Ahh :) Tak lig et svar:)

svar