Excel VBA to

Hey guys. So I have started learning Alteryx recently.

I am looking to find a way in Alteryx using tools for a few excel VBA commands.

Range.ClearComments: Clears only the comments. And the data and formats of the range will remain then same.
Range.ClearContents: Will clear only the content/data of the range, formats will remain same.
Range.Clear: Will clear the data including cell formats.

Would be great if someone can provide a differentiated workaround for all the above 3 functions in a range of columns.

Help

Accepted answers

danilang

Hi @ShantanuDagar

In general, Alteryx only deals with data when writing to excel files. Aside from a few specific cases, such as the Overwrite range option in the Output Data tool and the Reporting tools which can apply formatting to data, Alteryx has no mechanism to manipulating non-data content in Excel files.

You can work with almost everything, comments, formulas, formatting, etc, by leveraging the xlsxwriter writer library in a Python tool. The documentation for this library is here.

Dan.

All comments

binu_acs

@ShantanuDagar I am not sure this can be done through Alteryx but would like to get some advice from @danilang

danilang

Hi @ShantanuDagar

You can work with almost everything, comments, formulas, formatting, etc, by leveraging the xlsxwriter writer library in a Python tool. The documentation for this library is here.

Dan.

nidrucomli

Very Good

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

Aguisande 317