엑셀 데이터를 불러올 때

엑셀에서 특정 열만 가지고 오고 싶은데
혹시 방법 있을까요?

현재는 read range사용해서 전체를 읽은 다음에
dt1에 넣어주고 for each로 특정 컬럼값을 로우마다 넣어주고 있는데
시간이 꽤 오래걸리더라구요.

@hj2

Welcome to our uipath community.

Yes you can read only specific columns from Excel file.

After reading data from Excel file and then try below expression.

   Dt1.DefaultView.ToTable(False,"Column 1","Column 2",...."Column N")
1 Like

Thanks to you :slight_smile:
It’s solved.

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.