Copy multiple excel data to different text files

[anjalimishra (Anjali)]

The requirement is to
Fetch data from cells of Excel having multiple sheets and populate it in a csv/txt file in uipath.
Note that , we can have multiple excel sheets with different sheet name with same requirement

[jkallem (JK)]

@anjalimishra

Here is the sample, I hope this will help you.
Main.xaml (7.0 KB)

[anjalimishra (Anjali)]

Hi @jkallem,
This solution is copying everything to the CSV file, but the need is to get only selected range of records to csv/flat file

[jkallem (JK)]

@anjalimishra,

You can get specific range data by modifying the range property of Read Range Activity.

[anjalimishra (Anjali)]

got it!
but how to get all the sheets of the excel to csv file?

[MAHESH1 (MAHESHKUMAR JV)]

@anjalimishra

Try this it might help you for ur requirement to get all the sheets from a workbook

Loop through different excel sheets

Hi, I have gone through various discussions and couldn’t find any answer. I have a excel workbook which has 300 sheets. I want to copy all these sheets into a new excel workbook. I am using for each to do this. but still its giving only one sheet output. It’s not going through the loop. I have attached my flow . Please help me out. Main.xaml (14.6 KB)

Regards,
Mahesh

[anjalimishra (Anjali)]

I have created below solution , where I reading one row and writing it to csv file and reading another row and appending it again to same csv.
I need to repeat this activity for 30-40 different excels, is it possible to do this ?