I have around 50 excels in a folder containing data. Now i have to extract data from each excel data and store all the values in another excel one by one.Please help
- Use Directory.getfiles(“YourFolderPath”) It will give you the array of String which Contains your Excel Files.
- Then use For each To Iterate File one by one.
- Inside the for each use Excel Application scope.
- Read the File and convert it in datatable using Read Range.
- And write the data using Write Range,
Thanks & Regards
1 Like
Thanks I will try
I have created build data table with around 15 data labels, inside for each i have given excel application scope inside which i have provided add data row. here I dnt know how to provide vaues for it.If possible can u send me a sample flow.
@Thilagavathy_Manivan
You can add data in Datatable Using Add Data row As follow
- If you Have data row then You can directly mention it in Data row property.
- If You have values in multiple variables and want to add it in Data table then add it as a Array of Object {Var1, Var2, Var3}
- Just mention the datatable where you want to add the data in Datatable.
Thanks I will try and update you