Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

python tool - to get indent of excel

Pang_Hee_Choy
12 - Quasar

I create a tool to get the indent of an excel via python code. which easier than vba outside of alteryx.

 

the idea come from @caltang's post in idea

 

input: sheetname and fullpath

Screenshot 2024-07-22 121657.png

output1: same as input tool, (added recordid)

Screenshot 2024-07-22 121609.png

 

output2:

Screenshot 2024-07-22 121615.png

 

 

limitation:

  1. start with line one that is header
  2. 1 sheet only
  3. huge file may take time as loop is used.

 

Can anyone have a try and let me know any point for improvement?

and did it qualify for the alteryx marketplace? 😆

1 REPLY 1
Raj
16 - Nebula

@Pang_Hee_Choy 
great work....!

Labels