Copy multiple excel data to different text files

excel

#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 ?