[Python Script] Mob_Proto / Item_proto converters TXT to XLSX / XLSX to TXT

[KolenMG 1105]

This post is applied for guys that are using txt files instead of DB. Also, I think is useful for beginners since the advanced people may (or maynot) have a more advanced tools that are doing things in easiest ways. 

In the last days I've made some simples tools in python that helped me out in different circumstances. Today, I'm sharing 2 python scripts that are doing what the title describes. 

I've made them cause it was hard for me to look for different mobs / items as well as different Values / attr for them in these TXT files. 

1. Mostly these scripts are converting the txt files into Excel tabels.
2. Edit the Excel tables (like editing a txt file. Do not add new COLUMS / Do NOT MERGE cells / ETC) 
3. After finishing your work, use the 2nd script to convert back to txt file. 

 

If you know Python or know someone that know python, you can extend these scripts to be more easy to use (such as setting the input / output more easly with an GUI or smth.) 

I'll update these thread once I'll do the above  

 

Spoiler

Download: 

This is the hidden content, please

• Sign In
• or
• Sign Up

This is the hidden content, please

• Sign In
• or
• Sign Up

 

[Metin2 Dev 9199]

you dont really need these scripts, excel can load txt files and save them back to txt

[KolenMG 1105]

5 hours ago, Punszz said:

you dont really need these scripts, excel can load txt files and save them back to txt

Maybe yea. But I have trust issues due to what Excel surprised me in the last years. And to be said is that Importing directly txt file into excel, can be a bit stressful for non-Excel users since when you are opening the TXT file, you need to set up almost 3 "mini-pages" of options before seeing the txt file content in excel. So, maybe in a final variant, can be a great addition. 

[KolenMG 1105]

Ok so, I've made some changes. 

1. Now it should be more easy to use. 
2. Basically now it is just 1 python script that can be run in CMD. (no longer 2). 
3. it has the same options. 
4. it has now a GUI to work with. 
5. Using GUI you can select the input file / output directory as well as the type of conversion. 
6. It has a file preview cause why not, I wanted to fill some spaces. 
7. In the script, it has all the comments needed for each important section. So its easy to understand and maybe changing or modifying the script. 

 

Spoiler

Download Link: 

This is the hidden content, please

• Sign In
• or
• Sign Up

 

Unfortunately, I don't know how to edit the main post. 

Edited August 15, 2024 by Metin2 Dev International
Core X - External 2 Internal

[bunny2204 0]

1