I have an excel file i need to update data from “testexcel” to sample excel.
In testexcel i have sheets “data”, “value” and “first page”,i have to update from sheet(first page) to sample excel, for that i created workflow like
1.Get file path using(directory.getfiles)
2.Passed that file path to for each.
3.Created an excel application scope and passed filename. created output as Inputdata.
4.Again passed that Inpudata(excel application scope output) to for each and provided one message box to find which sheet it is reading,it is reading sheet"data".
5.If it has to read sheet “firstpage” at first what change i have to do in the workflow.
Can any one please suggest a solution for this.
TestExcel.xlsx (9.7 KB)