New to Dataiku DSS? Try out our NEW Quick Start Programs today and get onboarded on the product in just one hour! Let's go

Run Macro xlsm file on Dataset

sweet_shyam2001
Level 1
Run Macro xlsm file on Dataset

I have dataset in my project called abc_stacked, I have Macro file called xyz.xlsm which has Macro enabled, please let me know how to run macro on dataset in project?

0 Kudos
3 Replies
Clément_Stenac
Dataiker
Dataiker

Hi,

Unfortunately, to our knowledge, there is no way to run Excel macros on Unix (and hence within DSS)

0 Kudos
sweet_shyam2001
Level 1
Author

Hi,

Any other way to run VBA code? I mean using Python, R or Shell script language.

Thanks.

0 Kudos
Liev
Dataiker
Dataiker

Hi @sweet_shyam2001 ,

While you can probably execute a macro through Python, see here for some hints, it will require to have Excel as an application installed on the machine this is being executed. 

In the context of DSS, I would suggest rewriting the logic from VBA into a Python recipe. This will help you in keeping things transparent since, even if you managed to execute the VBA itself, it would be on a hidden layer from anything else in your project.

I hope this helps!

0 Kudos
A banner prompting to get Dataiku DSS