Script Options

DataNitro scripts support some custom behaviors. You can change what a script does by modifying its filename.

User-Defined Functions

Naming a script “functions.py” will make the Python functions in that file available directly in Excel. You can read more about UDF’s here.

Hidden Shell

You can prevent the black Python shell from coming up when a script is run by ending the file with “_hidden.py”. For example, a file named “test_hidden.py” will run with no shell.

This is helpful for distributing scripts to non-techincal end-users. However, it can make debugging difficult, so it’s best to only hide scripts which are already bug-free.

Autostart

You can have a script start automatically when a spreadsheet is opened by ending the file with “_autostart.py”. For example, a file named “test_autostart.py” will run as soon as the spreadsheet it’s been imported into is opened.