I am trying to create an excel sheet with (1) each of the sheet names from a list of excel workbooks, and (2) a specific cell value from each of those sheets (say, cell “E73”). Ideally, my new excel file would have column A with all the sheet names from the different source files and column B with the output of a read cell activity in each of those sheets. What happens so far is that I can read the sheet names and values I want but do not manage to put them on excel (can only see them in the output pane).
Can you help me?
You can find attached my workflow
Thank you!Main.xaml (26.9 KB)