python tool - to get indent of excel
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
PangHC
12 - Quasar
‎07-21-2024
09:23 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
output1: same as input tool, (added recordid)
output2:
limitation:
- start with line one that is header
- 1 sheet only
- 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? 😆
Labels:
- Labels:
- Preparation
- Python
- Tips and Tricks
1 REPLY 1
Raj
16 - Nebula
‎07-22-2024
03:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@PangHC
great work....!
