将excel中的数据导入Griedview

Question

   如何将excel中的数据导入Griedview中把数据显示出来.我用的是C# 
    在excel中数据横着的可以导入了 现在就是竖着的不怎么到怎么导  大家帮帮忙!! 

Answer 1

DataTable Excel_UserInfo = new DataTable();
            FileInfo fileInfo = new FileInfo(Path.Combine(TEMP_DIRECTORY, Guid.NewGuid().ToString() + ".xlsx"));
            try
            {
                using (Stream xlsStream = new BufferedStream(fileInfo.Open(FileMode.CreateNew), 1024))
                {
                    xlsStream.Write(EmployeeBytes, 0, EmployeeBytes.Length);
                }
                string strConn = @"Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + fileInfo.FullName + ";" + "Extended Properties=\"Excel 12.0;HDR=YES;IMEX=1;\"";
                string strExcel = "select * from [Chengdu Resources$]";                using (OleDbDataAdapter adaptor = new OleDbDataAdapter(strExcel, strConn))
                {
                    DataSet ds = new DataSet();
                    adaptor.Fill(ds);
                    Excel_UserInfo = ds.Tables[0];
                }
            }
            finally
            {
                fileInfo.Delete();
            }Gridview绑定Excel_UserInfo就可以了