Reading Excel File using C# (Want everything as string)

Question

I am reading an excel file using C# code into a data-table and displaying it into WPF data-grid. When I am reading dates from excel file and display them into data-grid the format of dates changes. I am using Oledb ADO.NET to read excel file.

The query I am using is:

SELECT * FROM [Sheet1$]

So basically I want to read data from excel, they it appears to user when he/she opens an excel and the same way I want to display it in my data-grid. Please guide me. If you need any other information about this problem, please ask me.

Regards, Priyank Thakkar

Could you provide connction string that you are using for Oledb? — Thit Lwin Oo
– Thit Lwin Oo, Commented Feb 7, 2012 at 13:41

Roy Goode · Accepted Answer · 2012-02-07 13:52:50Z

1

Use a connection string similar to this:

OLEDB;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";

As quoted from ConnectionStrings.com:

"IMEX=1;" tells the driver to always read "intermixed" (numbers, dates, strings etc) data columns as text. Note that this option might affect excel sheet write access negative.

edited Feb 7, 2012 at 13:52

answered Feb 7, 2012 at 13:43

Roy Goode

3,00023 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Olivier Jacot-Descombes Over a year ago

Also target the x86 platform, as the Jet drivers will not run in 64-bit mode.

bizah · Accepted Answer · 2012-02-07 13:57:53Z

0

You could save the file as a .csv and:

        string[] fileLines = File.ReadAllLines("path\file.csv");

        foreach (string s in fileLines)
        {
            string[] splitRow = s.Split(',');
            //do stuff w/ row columns
        }

answered Feb 7, 2012 at 13:57

bizah

2471 gold badge2 silver badges9 bronze badges

Collectives™ on Stack Overflow

Reading Excel File using C# (Want everything as string)

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related