r/PythonLearning • u/Usdmal-tech • 1d ago

Python script to convert tree output to .xlsx – looking for edge cases and feedback

I wrote a small utility that converts tree output into an Excel file. The code is far from ideal, but it does handle Cyrillic filenames on my own test data.

To make it more robust, I need to test it on real-world data with rare encodings, varying nesting depths, special characters, long names and paths, and so on.

The project is still under development, so I'd appreciate any feedback, criticism, or advice – especially on edge cases and code structure.

Rep: https://github.com/Usdmal-tech/tree-to-excel

Thanks!

3 Upvotes
  • permalink
  • reddit

81% Upvoted

3 comments sorted by

1

u/IPYNB-To-PDF 1d ago

For Excel side you can try checking what happens when the tree is very large since performance and Excel’s row limit could become an issue. Other than that random real-world directory dumps should probably reveal some interesting cases you haven’t considered yet.

2

u/Usdmal-tech 1d ago

And of course, I forgot to attach the link to the repository with the program that needs to be broken)

1

u/Usdmal-tech 1d ago

Yes, I understand this could be a problem. Unfortunately, I cannot generate all possible outputs of the `tree` command. So I hope someone here will break the program and we'll see what exactly can go wrong)