Copy multiple excel data to different text files

Help
1

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

2

@anjalimishra

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

3

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

4

@anjalimishra,

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

5

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

6

@anjalimishra

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

Regards,
Mahesh

7

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 ?

image
image668×694 18.1 KB