Breaking News: Grepper is joining You.com. Read the official announcement!

c# how to convert excel to csv

Add Answer

Al-khatab Yaseen answered on February 28, 2021 Popularity 10/10 Helpfulness 1/10

answer c# how to convert excel to csv

related how to convert csv to excel

related from excel to csv

related convert excel to csv

related csv to excel c#

c# how to convert excel to csv

Comment

// a c# method to convert excel files to csv using excel introp
using System;
using System.Text;
using Microsoft.Office.Interop.Excel;

static void ExcelToCsv(string sourceFilePath, string targetFilePath)
{
    Application application = null;
    Workbook wb = null;
    Worksheet ws = null;

    try
    {
        application = new Application();
        application.DisplayAlerts = false;
        wb = application.Workbooks.Open(sourceFilePath);
        ws = (Worksheet)wb.Sheets[1];
        ws.SaveAs(targetFilePath, XlFileFormat.xlCSV);
    }
    catch (Exception e)
    {
        // Handle exception
    }
    finally
    {
        if (application != null) application.Quit();
        if (ws != null) System.Runtime.InteropServices.Marshal.ReleaseComObject(ws);
        if (wb != null) System.Runtime.InteropServices.Marshal.ReleaseComObject(wb);
        if (application != null) System.Runtime.InteropServices.Marshal.ReleaseComObject(application);
    }
}

Popularity 10/10 Helpfulness 1/10 Language csharp

Source: Grepper

Tags: c# csv excel

Link to this answer
Share Copy Link

Contributed on Jun 22 2023

Al-khatab Yaseen

0 Answers Avg Quality 2/10

Closely Related Answers

how to convert csv to excel

Comment

import pandas as pd

# Read CSV file
df = pd.read_csv('input.csv')

# Convert DataFrame to Excel file
df.to_excel('output.xlsx', index=False)

Popularity 10/10 Helpfulness 2/10 Language python

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

from excel to csv

Comment

import pandas as pd

# Read Excel file
excel_file = pd.read_excel('path/to/excel_file.xlsx')

# Convert to CSV
csv_file_path = 'path/to/output_file.csv'
excel_file.to_csv(csv_file_path, index=False)

print(f'Successfully converted Excel file to CSV: {csv_file_path}')

Popularity 10/10 Helpfulness 2/10 Language python

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

convert excel to csv

Comment

#UI
File>> Save As>> Rename the file .csv>> Save

#Online
https://www.zamzar.com/convert/xls-to-csv/

Popularity 10/10 Helpfulness 2/10 Language whatever

Source: Grepper

Tags: csv

Link to this answer
Share Copy Link

Contributed on Feb 28 2021

Snippets

0 Answers Avg Quality 2/10

csv to excel c#

Comment

private IEnumerable<string[]> ReadCsv(string fileName, char delimiter = ';')
{
    var lines = System.IO.File.ReadAllLines(fileName, Encoding.UTF8).Select(a => a.Split(delimiter));
    return (lines);
}

Popularity 9/10 Helpfulness 1/10 Language csharp

Source: stackoverflow.com

Tags: c# csv

Link to this answer
Share Copy Link

Contributed on Feb 19 2024

Cheerful Chipmunk

0 Answers Avg Quality 2/10

csv to excel c#

Comment

private IEnumerable<string[]> ReadCsv(string fileName, char delimiter = ';')
{
    var lines = System.IO.File.ReadAllLines(fileName, Encoding.UTF8).Select(a => a.Split(delimiter));
    return (lines);
}

Popularity 9/10 Helpfulness 1/10 Language csharp

Source: stackoverflow.com

Tags: c# csv

Link to this answer
Share Copy Link

Contributed on Feb 20 2024

Cheerful Chipmunk

0 Answers Avg Quality 2/10

csv to excel c#

Comment

private IEnumerable<string[]> ReadCsv(string fileName, char delimiter = ';')
{
    var lines = System.IO.File.ReadAllLines(fileName, Encoding.UTF8).Select(a => a.Split(delimiter));
    return (lines);
}

Popularity 9/10 Helpfulness 1/10 Language csharp

Source: stackoverflow.com

Tags: c# csv c

Link to this answer
Share Copy Link

Contributed on Feb 20 2024

Cheerful Chipmunk

0 Answers Avg Quality 2/10

csv to excel c#

Comment

private static bool ConvertWithNPOI(string excelFileName, string worksheetName, IEnumerable<string[]> csvLines)
{
    if (csvLines == null || csvLines.Count() == 0)
    {
    return (false);
    }

    int rowCount = 0;
    int colCount = 0;

    IWorkbook workbook = new XSSFWorkbook();
    ISheet worksheet = workbook.CreateSheet(worksheetName);

    foreach (var line in csvLines)
    {
    IRow row = worksheet.CreateRow(rowCount);

    colCount = 0;
    foreach (var col in line)
    {
        row.CreateCell(colCount).SetCellValue(TypeConverter.TryConvert(col));
        colCount++;
    }
    rowCount++;
    }

    using (FileStream fileWriter = File.Create(excelFileName))
    {
       workbook.Write(fileWriter);
       fileWriter.Close();
    }

    worksheet = null;
    workbook = null;

    return (true);
}

Popularity 9/10 Helpfulness 1/10 Language csharp

Source: stackoverflow.com

Tags: c# csv c

Link to this answer
Share Copy Link

Contributed on Feb 20 2024

Cheerful Chipmunk

0 Answers Avg Quality 2/10

c# how to convert excel to csv

Contents

More Related Answers

c# how to convert excel to csv

Closely Related Answers

how to convert csv to excel

from excel to csv

convert excel to csv

csv to excel c#

csv to excel c#

csv to excel c#

csv to excel c#

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.