Reading from CSV using Microsoft.Office.Interop.Excel

See more:

MS-Excel

CSV

Hi,

I'm trying to load data from a CSV file using Microsoft.Office.Interop.Excel.

Here is the code I'm using:

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

                    Microsoft.Office.Interop.Excel.Application objExcelApplication = new Microsoft.Office.Interop.Excel.Application();

                    objExcelApplication.Workbooks.OpenText(strFilePath,
                                                        DataType: Microsoft.Office.Interop.Excel.XlTextParsingType.xlDelimited,
                                                        TextQualifier: Microsoft.Office.Interop.Excel.XlTextQualifier.xlTextQualifierNone,
                                                        ConsecutiveDelimiter: true,
                                                        Semicolon: true);

                    Microsoft.Office.Interop.Excel.Worksheet objExcelWorksheet = objExcelApplication.Workbooks[1].Sheets[strTableName];

                    if (objExcelWorksheet != null)
                    {
                        int columnCount = objExcelWorksheet.UsedRange.Columns.Count;
                        for (int i = 1; i < columnCount + 1; i++)
                        {
                            if (objExcelWorksheet.Cells[1, i].Value != null)
                            {
                                if (!lstColumnsNames.Contains(objExcelWorksheet.Cells[1, i].Value.ToString()))
                                    lstColumnsNames.Add(objExcelWorksheet.Cells[1, i].Value.ToString());
                            }
                        }
                    }

                    objExcelApplication.Workbooks[1].Close();

When I do load a file having a csv as extension, it does not really separate according to semicolons (while it is specified it should be). but when the same file is saved as a text file, it does.

Is there something missing?

Regards and thanks in advance.