Devexpress 엑셀 파일 읽기 Excel 로드 읽기

엑셀 관련된 참조 DLL

DevExpress.Data

DevExpress.Docs

DevExpress.Office

DevExpress.Spreadsheet

            using (DevExpress.Spreadsheet.Workbook workbook = new Workbook())
            {
                workbook.LoadDocument(filePath);

                foreach (Worksheet worksheet in workbook.Worksheets)
                {
                    for (int j = 1; j <= worksheet.Rows.LastUsedIndex; j++, i = 'A')
                    {
                        CellValue Name_LOT_NO = worksheet.Cells[$"{i}{j}"].Value;

                        //타이틀
                        if (j == 1)
                        {

                        }
                        else
                        {
                           
                            if (Name_LOT_NO.IsNumeric)
                                selectedRow["RESULT_VALUE_A"] = Name_LOT_NO.NumericValue;
                            else
                                selectedRow["RESULT_VALUE_A"] = Name_LOT_NO.TextValue; 
                        }
                    }
                } 
            }