Run Macro xlsm file on Dataset

sweet_shyam2001
sweet_shyam2001 Registered Posts: 2 ✭✭✭

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?

Answers

  • Clément_Stenac
    Clément_Stenac Dataiker, Dataiku DSS Core Designer, Registered Posts: 753 Dataiker

    Hi,

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

  • sweet_shyam2001
    sweet_shyam2001 Registered Posts: 2 ✭✭✭

    Hi,

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

    Thanks.

  • Liev
    Liev Dataiker Alumni Posts: 176 ✭✭✭✭✭✭✭✭

    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!

  • avrama03
    avrama03 Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1

    Hi everyone,

    Any updates on this? Are xlsm files still not supported? I am using v12

Setup Info
    Tags
      Help me…