Open, close, and save Excel in Alteryx

Is there a way to simply open, close, and save an excel document with Alteryx?

I am working on a two part workflow and I am facing challenging with existing Excel formulas.

Part I performs data manipulations and drops new data in excel columns ABC. Excel has existing formulas in columns DEF referencing the data in columns ABC.

Part II is a separate workflow which reads from the file I just created with data in ABC and formulas in DEF. The formulas won't update until the workbook has opened. Is there a way to bypass manually opening the excel document?

In reality there a lot more formulas than DEF. I am trying to avoid adding the formulas in Alteryx and simply leverage what is on the existing Excel document.

Workflow

Accepted answers

catmar

Hi all,

Thank you for the input. I must admit that I am a bit a bit intimidated by the execute run commands tool and created all formulas in the workflow instead. I'll revisit this topic at a later point.

All comments

cjaneczko

You could do it with the Run Command tool by creating a bat file. Easier way would probably be to add the formulas to the alteryx workflow and just have Alteryx do the DEF formulas.

<a href="/profile/4194">@Echo</a> off
start excel.exe "C:\path\to\your\file.xlsx"
timeout /t 5 /nobreak  > NUL
taskkill /F /IM excel.exe

ddiesel

Hi @catmar !

I second @cjaneczko suggestion to use run commands.

I also wanted to add that you can execute run commands using the events tab before or after your workflow runs, which is often how I apply them.

And a friendly word of caution: Running executable commands can be powerful, but it is important to be careful, especially if you are not very experienced with them. Don't ask me about how I learned this the hard way 😁

danilang

Hi @catmar

Another point to be aware of is that batch commands that invoke Excel.exe don't necessarily work on the gallery. This is because most server environments don't have the Office Suite installed. There can also be issues involving deadlocks and unstable execution when running MS Office apps in unattended mode.

Dan

Qiu

@catmar
I happened to have an idea before for the weekly challenge but give up anyway.
It reads the input of Kanji from Data Stream 1 and output to one Excel and gets the Hiragawa of Japanese then read back.

Pretty much the same as your intention here.

Take a look.

WeeklyChanllege-Ja-20210309.yxzp

catmar

schuprov

@catmar i have recently started using a Python module with openpyxl package and I found that to be much more user-friendly and easier than running BAT files.

catmar

Thank you @schuprov I will play with it.

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335