How to read all excel files in a folder

Help Studio
, ,
5

Hi @mrupendrareddy123
assign

str= directory.GetFiles("Your path")

foreach file in str

path.GetExtension(file).Equals(".xlsx") or path.GetExtension(file).Equals(".xls")

if condition

path.GetExtension(file).Equals(".xlsx") or path.GetExtension(file).Equals(".xls")

Use Read Range Workbook to read the file.

2 Likes