Hi all, currently my sequence is able to only read 1 sheet from the excel with specific conditions. how do I get the bot to read all the sheets in the excel with the specific conditions that I wanted? my files are here File.zip (10.1 KB)

@Popo Hey buddy i think i have found the issue…you have passed the variable out_workbook like this to for each loop [image] But where does it take the value from , where the source for this variable,it should be from Excel Application Scope activity as output variable, but its not there obtained…

Read different excel sheets with For each and If activity

Help

indra (Indra) May 9, 2019, 7:19am 4

@Popo Refer this Post and download zip file.

Topic		Replies	Views
Merge Datatable activity not working Help	7	1797	June 25, 2020
How to read multiple excel sheets Activities excel , activities , question	5	1453	April 13, 2023
Is it possible to read the multiple sheets using for each data table Help excel , uiautomation , activities	28	4646	October 29, 2018
How to read data from 2 different excel with different sheet names? Forum question	7	1112	March 1, 2021
Merge multiple sheets in a excel Robot robot , question	9	656	November 22, 2022

Most Active Users - Yesterday
mkankatala
ashokkarale
ppr
Guru_Koli21
supermanPunch
Anil_G
akashjariwala
mojo001
Ramya_25
tharani.natarajan
More details...

Read different excel sheets with For each and If activity

Related Topics