OleDB를 이용한 엑셀 Loading
private void ReadExcel()
        {
            OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:/Find Service.xlsx;Extended Properties=Excel 8.0");
            OleDbDataAdapter da = new OleDbDataAdapter("select * from [Sheet1$]", con);
            DataTable dt = new DataTable("");
            dt.Columns.Add("FunctionName"typeof(String));
            dt.Columns.Add("ServiceName"typeof(String));
            da.Fill(dt);
        }


더보기

댓글,

착한사기꾼