DevExpress Excel 읽기.

        private void Form1_Load(object sender, EventArgs e)
        {
            OpenFileDialog openFileDialog1 = new OpenFileDialog();
            openFileDialog1.FileName = "";
            openFileDialog1.Filter = "xls파일(*.xls)|*.xls|xlsx파일(*.xlsx)|*.xlsx";
            openFileDialog1.Title = "엑셀 저장";
            if (openFileDialog1.ShowDialog() == DialogResult.OK)
            {
                try
                {
                    if (openFileDialog1.FileName != string.Empty)
                    {
                        
                        Workbook workBook = new Workbook();
                        using(FileStream sf = new FileStream(openFileDialog1.FileName, FileMode.Open))
                        {
                            workBook.LoadDocument(sf, DocumentFormat.Xls);
                            Worksheet ws = workBook.Worksheets[0];
                            Range range = ws.GetUsedRange();
                            DataTable dt = workBook.Worksheets[0].CreateDataTable(range, false);

                            for (int i = 0; i < workBook.Worksheets[0].Rows.LastUsedIndex + 1; i++)
                            {
                                DataRow dr = dt.NewRow();
                                for (int j = 0; j < workBook.Worksheets[0].Columns.LastUsedIndex + 1; j++)
                                {
                                    dr[j] = workBook.Worksheets[0].Cells[i, j].DisplayText;
                                }
                                dt.Rows.Add(dr);
                            }
                            gridControl1.DataSource = dt;
                        }
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show("엑셀 파일 드라이버가 잘못되었거나 엑셀파일이 문제가 있습니다." + "\r\n" + ex.ToString());
                }

            }