HYTOS

            try

            {

            }

            catch (Exception)

            {

                throw;

            }

            finally

            {

                GC.Collect(2);

                GC.Collect(2);

            }

        private string GetColumnName(int column)

        {

            int dividend = column;

            string columnName = string.Empty;

            while (dividend > 0)

            {

                int modulo = (dividend - 1) % 26;

                columnName = Convert.ToChar(65 + modulo) + columnName;

                dividend = (dividend - modulo) / 26;

            }

            return columnName;

        }

        public ImportResult ExcelDataImport(List<ExcelData> ExcelData)

        {

            ImportResult result = new ImportResult();

            StringBuilder sbErrMsg = new StringBuilder();

            try

            {

                int rowCount = ExcelData.Max(x=>x.ROW_INDEX);

                int columnCount = ExcelData.Max(x => x.COUMMN_INDEX);

                int exRow = 9;

                #region Excel 유효성검사

                //Excel 포멧체크

                if (rowCount < 10 || columnCount != 45)

                {

                    result.Error = "Please, check the excel.";

                    return result;

                }

                #region 엑셀 필수값 체크(도면 : 이름,담당자, 난이도, Typical)

                ExcelData.Where(col => col.ROW_INDEX > exRow)

                        .Where(col => col.COUMMN_INDEX > 5 && col.COUMMN_INDEX < 11 && col.ROW_INDEX > exRow && string.IsNullOrEmpty(col.VALUE))

                       .ToList()

                       .ForEach(p => sbErrMsg.Append(", " + p.TopLeftCell));

                if (sbErrMsg.Length > 0)

                {

                    string errMsg = sbErrMsg.ToString().Substring(2);

                    if (errMsg.Length > 100)

                    {

                        errMsg = $"{errMsg.Substring(0, 100)}...";

                    }

                    result.Error = $"Please, check null value in excel.\n{errMsg}";

                    return result;

                }

                #endregion

                #region 엑셀 도명명 중복 값 체크

                ExcelData.Where(col => col.COUMMN_INDEX == 7 && col.ROW_INDEX > exRow)

                        .GroupBy(g => g.ROW_INDEX)

                        .Select(p => new

                        {

                            rowIndex = p.Key,

                            docNo = p.Select(x => x.VALUE.ToString()).FirstOrDefault()

                        })

                        .GroupBy(g => g.docNo)

                        .Where(p => p.Count() > 1)

                        .Select(p => p.Select(x => (x.rowIndex + 1).ToString())

                                                                .Aggregate((x, y) => x.ToString() + "," + y.ToString())

                                                                .ToString())

                        .ToList().ForEach(p => sbErrMsg.Append("\n" + p.ToString()));

                if (sbErrMsg.Length > 0)

                {

                    sbErrMsg.Insert(0, "\n중복 된 도면명 Excel row : ");

                    string errMsg = sbErrMsg.ToString();

                    if (errMsg.Length > 100)

                    {

                        errMsg = $"{errMsg.Substring(0, 100)}...";

                    }

                    result.Error = $"Please, check the duplicate value in excel.\n{errMsg}";

                    return result;

                }

                #endregion

                #endregion

                result.documents = new List<Documents>();

                foreach (var row in ExcelData.Where(row => row.ROW_INDEX > exRow).GroupBy(x => x.ROW_INDEX))

                {

                    var document = new Documents();

                    foreach (var cell in row)

                    {

                        var value = cell.VALUE.DefalutValue();

                        switch (cell.COUMMN_INDEX)

                        {

                            case 6:

                                document.RefProjectCode = value;

                                break;

                            case 7:

                                document.DocumentNo = value;

                                break;

                            case 8:

                                document.PersonInCharge = this.GetUser(value).ID;

                                break;

                            case 9:

                                document.JobLevel = value;

                                break;

                            case 10:

                                document.IsTypical = value;

                                break;

                            case 11:

                                document.RevisonNo = value;

                                break;

                            case 12:

                                document.ToIsDiscussion = value;

                                break;

                            case 13:

                                document.ToRemarks = value;

                                break;

                            case 14:

                                document.ToCreator = this.GetUser(value).ID;

                                break;

                            case 17:

                                document.FrReviewStatus = value;

                                break;

                            case 18:

                                document.FrRemarks = value;

                                break;

                            case 19:

                                document.FrCreator = this.GetUser(value).ID;

                                break;

                            case 22:

                                document.IsID2Work = value;

                                break;

                            case 24:

                                document.ID2StartDate = string.IsNullOrEmpty(value) ? (DateTime?)null : Convert.ToDateTime(value);

                                break;

                            case 25:

                                document.ID2EndDate = string.IsNullOrEmpty(value) ? (DateTime?)null : Convert.ToDateTime(value);

                                break;

                            case 27:

                                document.ID2Status = value;

                                break;

                            case 28:

                                document.ID2Issues = value;

                                break;

                            case 30:

                                document.AVEVAConvertDate = string.IsNullOrEmpty(value) ? (DateTime?)null : Convert.ToDateTime(value);

                                break;

                            case 31:

                                document.AVEVAReviewDate = string.IsNullOrEmpty(value) ? (DateTime?)null : Convert.ToDateTime(value);

                                break;

                            case 32:

                                document.AVEVAStatus = value;

                                break;

                            case 33:

                                document.AVEVAIssues = value;

                                break;

                            case 36:

                                document.ProdReviewer = this.GetUser(value).ID;

                                break;

                            case 37:

                                document.ProdIsResult = value;

                                break;

                            case 38:

                                document.ProdRemarks = value;

                                break;

                            case 39:

                                document.ClientReviewer = this.GetUser(value).ID;

                                break;

                            case 40:

                                document.ClientIsResult = value;

                                break;

                            case 41:

                                document.ClientRemarks = value;

                                break;

                            case 42:

                                document.DTIsGateWay = value;

                                break;

                            case 43:

                                document.DTIsImport = value;

                                break;

                            case 44:

                                document.DTIsRegSystem = value;

                                break;

                            case 45:

                                document.DTRemarks = value;

                                break;

                        }

                    }

                    result.documents.Add(document);

                }

            }

            catch (Exception)

            {

                throw;

            }

            return result;

        }

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace ID2.Manager.Common.Helpers

{

    public static  class StringHelper

    {

        public static string DefalutValue(this string value)

        {

            if(string.IsNullOrEmpty(value))

            {

                return string.Empty;

            }

            else

            {

                return value;

            }

        }

    }

}

    <Compile Include="Helpers\StringHelper.cs" />

using ID2.Manager.Dapper.Repository;

using ID2.Manager.Data.Models;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace ID2.Manager.Controller.Controllers

{

    public  class ExcelDataController : BaseController

    {

        public IEnumerable<ExcelData> GetExcelData(string FileName, string WorksheetName)

        {

            IEnumerable<ExcelData> result = null;

            using (ExcelDataRepository repository = new ExcelDataRepository(this._MSSQLCONNSTR))

            {

                result = repository.GetExcelData(FileName, WorksheetName);

            }

            return result;

        }

        public IEnumerable<ExcelDataInfo> GetExcelDataInfo()

        {

            IEnumerable<ExcelDataInfo> result = null;

            using (ExcelDataRepository repository = new ExcelDataRepository(this._MSSQLCONNSTR))

            {

                result = repository.GetExcelDataInfo();

            }

            return result;

        }

    }

}

    <Compile Include="Controllers\ExcelDataController.cs" />

    <Compile Include="Repository\ExcelDataRepository.cs" />

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using Dapper;

using ID2.Manager.Data.Models;

namespace ID2.Manager.Dapper.Repository

{

    public class ExcelDataRepository : BaseRepository

    {

        public ExcelDataRepository(string connectionStr) : base(connectionStr) { }

        public IEnumerable<ExcelData> GetExcelData(string FileName,string WorksheetName)

        {

            try

            {

                string query = $@"select * from dbo.ImportExcel where [FILE_NAME] = @FileName and WORKSHEET_NAME = @WorksheetName";

                var dynamicParameters = new DynamicParameters();

                dynamicParameters.Add("@FileName", FileName);

                dynamicParameters.Add("@WorksheetName", WorksheetName);

                return Query<ExcelData>(query, dynamicParameters);

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }

        public IEnumerable<ExcelDataInfo> GetExcelDataInfo()

        {

            try

            {

                string query = $@"select [FILE_NAME],WORKSHEET_NAME from dbo.ImportExcel group by [FILE_NAME],WORKSHEET_NAME";

                return Query<ExcelDataInfo>(query);

            }

            catch (Exception ex)

            {

                throw ex;

            }

        }

    }

}

    <Compile Include="Models\ExcelData.cs" />

    <Compile Include="Models\ExcelDataInfo.cs" />

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace ID2.Manager.Data.Models

{

    public class ExcelData

    {

        public string FILE_NAME { get; set; }

        public string WORKSHEET_NAME { get; set; }

        public int COUMMN_INDEX { get; set; }

        public int ROW_INDEX { get; set; }

        public string VALUE { get; set; }

        public string TopLeftCell { get; set; }

        public string OBJECT_TYPE { get; set; }

    }

}

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace ID2.Manager.Data.Models

{

    public class ExcelDataInfo : INotifyPropertyChanged

    {

        private string fILE_NAME;

        private string wORKSHEET_NAME;

        public string FILE_NAME { get => fILE_NAME;

            set {

                    if (fILE_NAME != value)

                    {

                        fILE_NAME = value;

                         OnNotifyPropertyChanged("FILE_NAME");

                        OnNotifyPropertyChanged("FullName");

                    }

                }

        }

        public string WORKSHEET_NAME

        {

            get => wORKSHEET_NAME;

            set

            {

                if (wORKSHEET_NAME != value)

                {

                    wORKSHEET_NAME = value;

                    OnNotifyPropertyChanged("WORKSHEET_NAME");

                    OnNotifyPropertyChanged("FullName");

                }

            }

        }

        public string FullName

        {

            get

            {

                return $"{FILE_NAME} :{WORKSHEET_NAME}";

            }

        }

        #region INotifyPropertyChanged Implementation 

        public event PropertyChangedEventHandler PropertyChanged;

        private void OnNotifyPropertyChanged(string property)

        {

            if (this.PropertyChanged != null)

            {

                this.PropertyChanged(this, new PropertyChangedEventArgs(property));

            }

        }

        #endregion

    }

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using Telerik.WinControls.UI;

namespace ID2.Manager.Controls

{

    public class DetailRowInfo : GridViewRowInfo

    {

        public DetailRowInfo(GridViewInfo viewInfo) : base(viewInfo)

        {

        }

        public override Type RowElementType

        {

            get

            {

                return typeof(RowDetailViewRowElement);

            }

        }

    }

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace ID2.Manager.Controls

{

    public class MarkupIconItem

    {

    }

}



namespace ID2.Manager.Forms

{

    partial class SelectExcelData

    {

        /// <summary>

        /// Required designer variable.

        /// </summary>

        private System.ComponentModel.IContainer components = null;

        /// <summary>

        /// Clean up any resources being used.

        /// </summary>

        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>

        protected override void Dispose(bool disposing)

        {

            if (disposing && (components != null))

            {

                components.Dispose();

            }

            base.Dispose(disposing);

        }

        #region Windows Form Designer generated code

        /// <summary>

        /// Required method for Designer support - do not modify

        /// the contents of this method with the code editor.

        /// </summary>

        private void InitializeComponent()

        {

            this.tableLayoutPanel1 = new System.Windows.Forms.TableLayoutPanel();

            this.drpSelectExcel = new Telerik.WinControls.UI.RadDropDownList();

            this.tableLayoutPanel2 = new System.Windows.Forms.TableLayoutPanel();

            this.btnCancel = new Telerik.WinControls.UI.RadButton();

            this.btnOK = new Telerik.WinControls.UI.RadButton();

            this.tableLayoutPanel1.SuspendLayout();

            ((System.ComponentModel.ISupportInitialize)(this.drpSelectExcel)).BeginInit();

            this.tableLayoutPanel2.SuspendLayout();

            ((System.ComponentModel.ISupportInitialize)(this.btnCancel)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.btnOK)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this)).BeginInit();

            this.SuspendLayout();

            // 

            // tableLayoutPanel1

            // 

            this.tableLayoutPanel1.ColumnCount = 1;

            this.tableLayoutPanel1.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 100F));

            this.tableLayoutPanel1.Controls.Add(this.drpSelectExcel, 0, 0);

            this.tableLayoutPanel1.Controls.Add(this.tableLayoutPanel2, 0, 1);

            this.tableLayoutPanel1.Dock = System.Windows.Forms.DockStyle.Fill;

            this.tableLayoutPanel1.Location = new System.Drawing.Point(0, 0);

            this.tableLayoutPanel1.Name = "tableLayoutPanel1";

            this.tableLayoutPanel1.RowCount = 2;

            this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 100F));

            this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Absolute, 40F));

            this.tableLayoutPanel1.Size = new System.Drawing.Size(392, 170);

            this.tableLayoutPanel1.TabIndex = 0;

            // 

            // drpSelectExcel

            // 

            this.drpSelectExcel.Dock = System.Windows.Forms.DockStyle.Top;

            this.drpSelectExcel.DropDownAnimationEnabled = true;

            this.drpSelectExcel.ItemHeight = 50;

            this.drpSelectExcel.Location = new System.Drawing.Point(3, 3);

            this.drpSelectExcel.Name = "drpSelectExcel";

            this.drpSelectExcel.Size = new System.Drawing.Size(386, 20);

            this.drpSelectExcel.TabIndex = 0;

            // 

            // tableLayoutPanel2

            // 

            this.tableLayoutPanel2.ColumnCount = 2;

            this.tableLayoutPanel2.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 50F));

            this.tableLayoutPanel2.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 50F));

            this.tableLayoutPanel2.Controls.Add(this.btnCancel, 1, 0);

            this.tableLayoutPanel2.Controls.Add(this.btnOK, 0, 0);

            this.tableLayoutPanel2.Dock = System.Windows.Forms.DockStyle.Fill;

            this.tableLayoutPanel2.Location = new System.Drawing.Point(3, 133);

            this.tableLayoutPanel2.Name = "tableLayoutPanel2";

            this.tableLayoutPanel2.RowCount = 1;

            this.tableLayoutPanel2.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 100F));

            this.tableLayoutPanel2.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Absolute, 20F));

            this.tableLayoutPanel2.Size = new System.Drawing.Size(386, 34);

            this.tableLayoutPanel2.TabIndex = 1;

            // 

            // btnCancel

            // 

            this.btnCancel.Dock = System.Windows.Forms.DockStyle.Left;

            this.btnCancel.Location = new System.Drawing.Point(203, 3);

            this.btnCancel.Margin = new System.Windows.Forms.Padding(10, 3, 10, 3);

            this.btnCancel.Name = "btnCancel";

            this.btnCancel.Size = new System.Drawing.Size(110, 28);

            this.btnCancel.TabIndex = 1;

            this.btnCancel.Text = "Cancel";

            // 

            // btnOK

            // 

            this.btnOK.Dock = System.Windows.Forms.DockStyle.Right;

            this.btnOK.Location = new System.Drawing.Point(73, 3);

            this.btnOK.Margin = new System.Windows.Forms.Padding(10, 3, 10, 3);

            this.btnOK.Name = "btnOK";

            this.btnOK.Size = new System.Drawing.Size(110, 28);

            this.btnOK.TabIndex = 0;

            this.btnOK.Text = "Ok";

            // 

            // SelectExcelData

            // 

            this.AutoScaleDimensions = new System.Drawing.SizeF(7F, 12F);

            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;

            this.ClientSize = new System.Drawing.Size(392, 170);

            this.Controls.Add(this.tableLayoutPanel1);

            this.Name = "SelectExcelData";

            this.Text = "SelectExcelData";

            this.Load += new System.EventHandler(this.SelectExcelData_Load);

            this.tableLayoutPanel1.ResumeLayout(false);

            this.tableLayoutPanel1.PerformLayout();

            ((System.ComponentModel.ISupportInitialize)(this.drpSelectExcel)).EndInit();

            this.tableLayoutPanel2.ResumeLayout(false);

            ((System.ComponentModel.ISupportInitialize)(this.btnCancel)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.btnOK)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this)).EndInit();

            this.ResumeLayout(false);

        }

        #endregion

        private System.Windows.Forms.TableLayoutPanel tableLayoutPanel1;

        private Telerik.WinControls.UI.RadDropDownList drpSelectExcel;

        private System.Windows.Forms.TableLayoutPanel tableLayoutPanel2;

        private Telerik.WinControls.UI.RadButton btnCancel;

        private Telerik.WinControls.UI.RadButton btnOK;

    }

}

using ID2.Manager.Common;

using ID2.Manager.Controller.Controllers;

using ID2.Manager.Data.Models;

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using Telerik.WinControls;

using Telerik.WinControls.Layouts;

using Telerik.WinControls.UI;

namespace ID2.Manager.Forms

{

    public partial class SelectExcelData : RadForm

    { 

        readonly Informations informations = Informations.Instance;

        /// <summary>

        /// 선택된 엑셀 파일에 대한 데이터

        /// </summary>

        public List<ExcelData> SelectItems = new List<ExcelData>();

        /// <summary>

        /// 선택된 엑셀 파일

        /// </summary>

        public ExcelDataInfo SelectInfo = null;

        public SelectExcelData()

        {

            InitializeComponent();

            this.FormBorderStyle = FormBorderStyle.FixedDialog;

            btnOK.Click += BtnOK_Click;

            btnCancel.Click += BtnCancel_Click;

            drpSelectExcel.ItemDataBinding += DrpSelectExcel_ItemDataBinding;

            drpSelectExcel.CreatingVisualListItem += new CreatingVisualListItemEventHandler(DrpSelectExcel_CreatingVisualListItem);

            drpSelectExcel.DropDownSizingMode = SizingMode.UpDownAndRightBottom;

            drpSelectExcel.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDownList;

            drpSelectExcel.DropDownAnimationEnabled = false;

        }

        private void BtnCancel_Click(object sender, EventArgs e)

        {

            this.SelectItems = new List<ExcelData>();

            this.DialogResult = DialogResult.Cancel;

            this.Close();

        }

        private void BtnOK_Click(object sender, EventArgs e)

        {

            if (drpSelectExcel.SelectedItem != null)

            {

                this.SelectInfo = drpSelectExcel.SelectedItem.DataBoundItem as ExcelDataInfo;

                SelectItems = new ExcelDataController().GetExcelData(this.SelectInfo.FILE_NAME, this.SelectInfo.WORKSHEET_NAME).ToList();

                this.DialogResult = DialogResult.OK;

                this.Close();

            }

            else

            {

                MessageBox.Show("선택된 Sheet가 없습니다.");

            }

        }

        private void DrpSelectExcel_CreatingVisualListItem(object sender, CreatingVisualListItemEventArgs args)

        {

            args.VisualItem = new ExcelVisualItem();

        }

        private void DrpSelectExcel_ItemDataBinding(object sender, ListItemDataBindingEventArgs args)

        {

            args.NewItem = new ExcelDataItem();

        }

        private void SelectExcelData_Load(object sender, EventArgs e)

        {

            var info = new ExcelDataController().GetExcelDataInfo();

            drpSelectExcel.DisplayMember = "FullName";

            drpSelectExcel.ValueMember = "FullName";

            drpSelectExcel.DataSource = info;

            drpSelectExcel.AutoSizeItems = true;

            drpSelectExcel.SelectedIndex = -1;

            drpSelectExcel.ShowDropDown();  

        }

    }

    public class ExcelDataItem : RadListDataItem

    {

        public static readonly RadProperty FileNameProperty = RadProperty.Register("FileName", typeof(string), typeof(ExcelDataItem), new RadElementPropertyMetadata(""));

        public static readonly RadProperty SheetNameProperty = RadProperty.Register("SheetName", typeof(string), typeof(ExcelDataItem), new RadElementPropertyMetadata(""));

        public string FileName

        {

            get

            {

                return (string)this.GetValue(ExcelDataItem.FileNameProperty);

            }

            set

            {

                this.SetValue(ExcelDataItem.FileNameProperty, value);

            }

        }

        public string SheetName

        {

            get

            {

                return (string)this.GetValue(ExcelDataItem.SheetNameProperty);

            }

            set

            {

                this.SetValue(ExcelDataItem.SheetNameProperty, value);

            }

        }

        private void item_PropertyChanged(object sender, PropertyChangedEventArgs e)

        {

            if (e.PropertyName == "FileName")

            {

                this.FileName = (this.DataBoundItem as ExcelDataInfo).FILE_NAME;

            }

            if (e.PropertyName == "SheetName")

            {

                this.SheetName = (this.DataBoundItem as ExcelDataInfo).WORKSHEET_NAME;

            }

        }

        protected override void SetDataBoundItem(bool dataBinding, object value)

        {

            base.SetDataBoundItem(dataBinding, value);

            if (value is INotifyPropertyChanged)

            {

                INotifyPropertyChanged item = value as INotifyPropertyChanged;

                item.PropertyChanged += item_PropertyChanged;

            }

        }

    }

    public class ExcelVisualItem : RadListVisualItem

    {

        #region Fields 

        private LightVisualElement lbFileName = new LightVisualElement();

        private LightVisualElement lbSheetName = new LightVisualElement();

        #endregion

        #region Initialization 

        static ExcelVisualItem()

        {

            RadListVisualItem.SynchronizationProperties.Add(ExcelDataItem.FileNameProperty);

            RadListVisualItem.SynchronizationProperties.Add(ExcelDataItem.SheetNameProperty);

        }

        #endregion

        #region Overrides 

        protected override Type ThemeEffectiveType

        {

            get

            {

                return typeof(RadListVisualItem);

            }

        }

        protected override void CreateChildElements()

        {

            base.CreateChildElements();

            this.lbFileName.StretchHorizontally = true;

            this.lbFileName.DrawImage = false;

            this.lbFileName.DrawText = true;

            this.lbFileName.TextAlignment = ContentAlignment.MiddleLeft;

            this.lbSheetName.StretchHorizontally = true;

            this.lbSheetName.DrawImage = false;

            this.lbSheetName.DrawText = true;

            this.lbSheetName.TextAlignment = ContentAlignment.MiddleLeft;

            StackLayoutPanel stack = new StackLayoutPanel();

            stack.Orientation = Orientation.Vertical;

            stack.Children.Add(lbFileName);

            stack.Children.Add(lbSheetName);

            this.Children.Add(stack);

        }

        protected override void PropertySynchronized(RadProperty property)

        {

            ExcelDataInfo dataItem = (ExcelDataInfo)this.Data.DataBoundItem;

            this.Text = "";

            if (property == ExcelDataItem.FileNameProperty)

            {

                this.lbFileName.Text = dataItem.FILE_NAME;

            }

            if (property == ExcelDataItem.SheetNameProperty)

            {

                this.lbSheetName.Text =$" - {dataItem.WORKSHEET_NAME}";

            }

        }

        #endregion

    }

}

<?xml version="1.0" encoding="utf-8"?>

<root>

  <!-- 

    Microsoft ResX Schema 

    Version 2.0

    The primary goals of this format is to allow a simple XML format 

    that is mostly human readable. The generation and parsing of the 

    various data types are done through the TypeConverter classes 

    associated with the data types.

    Example:

    ... ado.net/XML headers & schema ...

    <resheader name="resmimetype">text/microsoft-resx</resheader>

    <resheader name="version">2.0</resheader>

    <resheader name="reader">System.Resources.ResXResourceReader, System.Windows.Forms, ...</resheader>

    <resheader name="writer">System.Resources.ResXResourceWriter, System.Windows.Forms, ...</resheader>

    <data name="Name1"><value>this is my long string</value><comment>this is a comment</comment></data>

    <data name="Color1" type="System.Drawing.Color, System.Drawing">Blue</data>

    <data name="Bitmap1" mimetype="application/x-microsoft.net.object.binary.base64">

        <value>[base64 mime encoded serialized .NET Framework object]</value>

    </data>

    <data name="Icon1" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">

        <value>[base64 mime encoded string representing a byte array form of the .NET Framework object]</value>

        <comment>This is a comment</comment>

    </data>

    There are any number of "resheader" rows that contain simple 

    name/value pairs.

    Each data row contains a name, and value. The row also contains a 

    type or mimetype. Type corresponds to a .NET class that support 

    text/value conversion through the TypeConverter architecture. 

    Classes that don't support this are serialized and stored with the 

    mimetype set.

    The mimetype is used for serialized objects, and tells the 

    ResXResourceReader how to depersist the object. This is currently not 

    extensible. For a given mimetype the value must be set accordingly:

    Note - application/x-microsoft.net.object.binary.base64 is the format 

    that the ResXResourceWriter will generate, however the reader can 

    read any of the formats listed below.

    mimetype: application/x-microsoft.net.object.binary.base64

    value   : The object must be serialized with 

            : System.Runtime.Serialization.Formatters.Binary.BinaryFormatter

            : and then encoded with base64 encoding.

    mimetype: application/x-microsoft.net.object.soap.base64

    value   : The object must be serialized with 

            : System.Runtime.Serialization.Formatters.Soap.SoapFormatter

            : and then encoded with base64 encoding.

    mimetype: application/x-microsoft.net.object.bytearray.base64

    value   : The object must be serialized into a byte array 

            : using a System.ComponentModel.TypeConverter

            : and then encoded with base64 encoding.

    -->

  <xsd:schema id="root" xmlns="" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">

    <xsd:import namespace="http://www.w3.org/XML/1998/namespace" />

    <xsd:element name="root" msdata:IsDataSet="true">

      <xsd:complexType>

        <xsd:choice maxOccurs="unbounded">

          <xsd:element name="metadata">

            <xsd:complexType>

              <xsd:sequence>

                <xsd:element name="value" type="xsd:string" minOccurs="0" />

              </xsd:sequence>

              <xsd:attribute name="name" use="required" type="xsd:string" />

              <xsd:attribute name="type" type="xsd:string" />

              <xsd:attribute name="mimetype" type="xsd:string" />

              <xsd:attribute ref="xml:space" />

            </xsd:complexType>

          </xsd:element>

          <xsd:element name="assembly">

            <xsd:complexType>

              <xsd:attribute name="alias" type="xsd:string" />

              <xsd:attribute name="name" type="xsd:string" />

            </xsd:complexType>

          </xsd:element>

          <xsd:element name="data">

            <xsd:complexType>

              <xsd:sequence>

                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />

                <xsd:element name="comment" type="xsd:string" minOccurs="0" msdata:Ordinal="2" />

              </xsd:sequence>

              <xsd:attribute name="name" type="xsd:string" use="required" msdata:Ordinal="1" />

              <xsd:attribute name="type" type="xsd:string" msdata:Ordinal="3" />

              <xsd:attribute name="mimetype" type="xsd:string" msdata:Ordinal="4" />

              <xsd:attribute ref="xml:space" />

            </xsd:complexType>

          </xsd:element>

          <xsd:element name="resheader">

            <xsd:complexType>

              <xsd:sequence>

                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />

              </xsd:sequence>

              <xsd:attribute name="name" type="xsd:string" use="required" />

            </xsd:complexType>

          </xsd:element>

        </xsd:choice>

      </xsd:complexType>

    </xsd:element>

  </xsd:schema>

  <resheader name="resmimetype">

    <value>text/microsoft-resx</value>

  </resheader>

  <resheader name="version">

    <value>2.0</value>

  </resheader>

  <resheader name="reader">

    <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>

  </resheader>

  <resheader name="writer">

    <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>

  </resheader>

</root>

    <Compile Include="Forms\SelectExcelData.cs">

      <SubType>Form</SubType>

    </Compile>

    <Compile Include="Forms\SelectExcelData.Designer.cs">

      <DependentUpon>SelectExcelData.cs</DependentUpon>

    </Compile>

    <EmbeddedResource Include="Forms\SelectExcelData.resx">

      <DependentUpon>SelectExcelData.cs</DependentUpon>

    </EmbeddedResource>

            this.tableLayoutPanelCondition.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Absolute, 86F));

            this.radDropDownListFrReviewStatus.Location = new System.Drawing.Point(342, 32);

            this.radDropDownListFrReviewStatus.Size = new System.Drawing.Size(108, 20);

            this.radDropDownListToIsDiscussion.Size = new System.Drawing.Size(108, 20);

            this.radLabelFrReviewStatus.Location = new System.Drawing.Point(256, 34);

            this.radLabelAVEVAStatus.Location = new System.Drawing.Point(256, 62);

            this.radLabelIsID2Work.Location = new System.Drawing.Point(457, 34);

            this.radLabelJobLevel.Location = new System.Drawing.Point(457, 6);

            this.radButtonSearch.Location = new System.Drawing.Point(873, 4);

            this.radDropDownListProject.Size = new System.Drawing.Size(108, 20);

            this.radLabelDocumentNo.Location = new System.Drawing.Point(658, 6);

            this.radTextBoxDocumentNo.Location = new System.Drawing.Point(744, 4);

            this.radTextBoxDocumentNo.Size = new System.Drawing.Size(108, 20);

            this.radLabelPersonInCharge.Location = new System.Drawing.Point(256, 6);

            this.radDropDownListPersonInCharge.Location = new System.Drawing.Point(342, 4);

            this.radDropDownListPersonInCharge.Size = new System.Drawing.Size(108, 20);

            this.radDropDownListJobLevel.Location = new System.Drawing.Point(543, 4);

            this.radDropDownListJobLevel.Size = new System.Drawing.Size(108, 20);

            this.radLabel10.Location = new System.Drawing.Point(256, 90);

            this.radDropDownListIsID2Work.Location = new System.Drawing.Point(543, 32);

            this.radDropDownListIsID2Work.Size = new System.Drawing.Size(108, 20);

            this.radDropDownListID2Status.Size = new System.Drawing.Size(108, 20);

            this.radDropDownListAVEVAStatus.Location = new System.Drawing.Point(342, 60);

            this.radDropDownListAVEVAStatus.Size = new System.Drawing.Size(108, 20);

            this.radDropDownListProdIsResult.Size = new System.Drawing.Size(108, 20);

            this.radDropDownListClientIsResult.Location = new System.Drawing.Point(342, 89);

            this.radDropDownListClientIsResult.Size = new System.Drawing.Size(108, 20);

            var form =  new Forms.SelectExcelData();

            var dialogResult = form.ShowDialog();

            if (dialogResult == DialogResult.OK)

            {

                using (ID2Excel excel = new ID2Excel())

                {

                    var result = excel.ExcelDataImport(form.SelectItems);

                    if (result.Error != null)

                    {

                        RadMessageBox.Show(result.Error, "Information", MessageBoxButtons.OK, RadMessageIcon.Info);

                    }

                    else

                    {

                        this.documents.AddRange(result.documents);

                        if (this.orgDocuments == null) this.orgDocuments = new List<Documents>();

                        this.DocumentListBinding();

                    }

                }

            }

        }

        private void RadButtonElementExcelImport_Click_gembox(object sender, EventArgs e)

        {