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)
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)
Currently you’re overwriting the data in the datable. Try using different data table for each sheet, and then join them, if they have the same structure.
if I create different data table for each sheet, is there a way to combine all the data tables into one in ‘for each row’ activity? for e.g output_dt + output1_dt? is there such coding?
Use merge datatable activity to merge all data table
thanks
hey buddy @Palaniyappan
it seems that I always have problem opening the file as the activity could not be loaded because of the errors.
I can’t see the sequence in the excel application scope. possible to screenshot the sequence pls.
if u do know how to resolve the activity not loaded, do let me know ya
No worries buddy here is the file zipped again
@PopoFile.zip (10.7 KB)
and heree is the screenshots buddy
can I also see the variables that was created and the type argument for workbook.getsheets?
Is that working buddy
Cheers
@Palaniyappan am I doing anything wrong? it seems theres error at the read range activity. need your help to let me know how to amend. don’t need to amend the xaml file:)
Read Excel File v090519 415pm.xaml (17.3 KB)
Buddy @Popo kindly change the type arguments of for each loop to string that was the issue buddy
like this
Cheers
Kindly let know if it works
and kindly add a clear data table activity next to this for each row loop buddy @Popo
like this
Cheers
thanks buddy @Palaniyappan
but when I run the bot, there’s a error “for each: object reference not set to an instance of an object”
I have added the clear data table. let me know if I did it correctly ya. Read Excel File v090519 415pm-2.xaml (27.1 KB)
Keep like this in for each loop input buddy
out_workbook.getsheets.ToList
Cheers
Buddy @Popo inside the for each loop at which activty we are getting this error buddy
Lets sort this out buddy
Cheers