Reading numerous excel files

[pabaleloh]

Good morning, I’m trying to process/read numerous excel files from a folder. What activity can I use for this? Previously, I was processing a single file manually using the read range workbook. Now, I want the bot to process/read every file in a folder.

[Krishna_Raj]

@pabaleloh

How to read all excel in one folder

@mashy2 Follow these steps: String excelFiles [ ] = Directory.GetFiles(“folderPath”,“*.xlsx”) Above expression will read all Excel files from folder and will give output as String array. Then use For Each loop Activity to itreate that array of files and use Read Range Activity to read Excel data and use this Activity inside Excel Application Scope Activity.

How to read all excel files in a folder

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.

check the reference

[pabaleloh]

@Krishna_Raj
Hello, could you please send me a screenshot? thank you

[Krishna_Raj]

@pabaleloh

[pabaleloh]

@Krishna_Raj
Thank you so much

[Krishna_Raj]

@pabaleloh
most welcome
got a solution means mark it as solution to avoid looping

[pabaleloh]

You mean like this right ?