Excel notebook

Unknown

Excel notebook

Unknown

I have a two tab excel notebook. One tab is a pivot table that relies on the second data worksheet.
I want to replace the data worksheet with the output of a csv flow/report from Decisions. Is there an easy way to do it?

Unknown

Attached is the sample project that should help your use case.

The flow takes in an excel file and removes the second worksheet and subsequently adds a new sheet. On the Run Report step select "Execl File" as the Return Data Option in the step properties. We then use a For Each Row step to pull row data from the Report. I was able to get this working by using the Get Row step and Split String step to dynamically build a list of input for row data. This list will then be mapped into the values input of the Set Values In Row step.

Hope this helps your case.

[i][b]Please Note: [/b]The examples attached were developed to be instructional, and were not developed as officially supported components. For more information or to engage our service team to develop fully supported, production quality solutions, please contact: [url=mailto:services@decisions.com]services@decisions.com[/url][/i]
[i]edited by cameron@decisions.com on 5/8/2020[/i]