Combine xlsx and csv into one file

I have a workflow that I need to output as an xlsx file and then as a pipe delimited csv, and then either add the single csv column to the end of the xlsx file, or make it sheet2 in the same file. Using the Block Until Done tool I can get the 2 files outputted the way I want, but I don't know how to combine them in one of the ways I described..

Also, the csv portion would need the rows to end in a pipe, so the blank column is there, and I can manually remove the Col 6 heading after output

Workflow

Accepted answers

geraldo

@ppatane

An workflow example

Mixexcelcsv.yxmd

All comments

An workflow example

Thanks for the workflow! Though not exactly what I ended up doing, a number of things you did helped me to complete mine. Grazie!

Update...I ended up using a lot more of your workflow than I started out doing. Great job...thanks again!

lbardoe

You could use the add a Row Column to the data then transpose Rows to Columns tool to give you one column with all the values then use the Columns to Rows tool to concatenate the data using the | as the delimiter then append the 2 data sets together using the Row Column as the Join ID.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703