如何使用oledb读取excel中的所有列并在控制台中显示所有列

Question

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OleDb;


namespace ReadingExcel
{
    public class Program
    {
        public static void Main(string[] k)
        {

            string connectionString = @"Provider= Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\SaiKiran\Desktop\MyExl.xlsx;Extended Properties=Excel 12.0 Xml";

            //Create the connection

            System.Data.OleDb.OleDbConnection excelConnection = new System.Data.OleDb.OleDbConnection(connectionString);
            string excelQuery = @"Select * from [Sheet1$]";
            //string excelQuery1 = @"Select * from [Sheet1$]";
            System.Data.OleDb.OleDbCommand excelCommand = new System.Data.OleDb.OleDbCommand(excelQuery, excelConnection);
            excelConnection.Open();
            System.Data.OleDb.OleDbDataReader excelReader;
            excelReader = excelCommand.ExecuteReader();

            while (excelReader.Read())
            {
                //Globals.Sheet1.Cells[1, 3] = "Set my data";
                    Console.WriteLine("id={0}", excelReader[0].ToString());
                    Console.ReadLine();

            }
            excelConnection.Close();

        }
    }
}

我在.xlsx format.with中的excel中有A，B，C列，现在我只能读取一列。请告诉我读取所有列的循环或其他东西。

Answer 1

现在回答已经太晚了。但它可能会帮助那些寻找类似解决方案的人。

这里给出了一个解决方案：http://support.microsoft.com/kb/302096