Learn how to save time, get organised and reduce errors by using Python scripts for importing data from TXT or CSV files straight into Excel. This tutorial will show you a real-world example of importing data from a TXT file into Microsoft Excel.
🌎 :
Source Code:
⭐ :
00:00 – Intro
00:16 – Problem statement
01:29 – Coding out the solution
05:55 – Outro
◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️
:
🌎 Website:
📝 GitHub:
⭐ Discord:
▶️ Subscribe:
🎉 –
Get it here:
📚 &
Check out my recommendations:
☕ ❓
If you want to support this channel, you can buy me a coffee here:
…(read more)
Convert Word 2 PDF: Word to PDF Converter
Convert PowerPoint 2 PDF: PPT to PDF Converter
Convert Excel 2 PDF: Excel to PDF Converter
Convert an Image 2 PDF: Image to PDF Converter
Convert HTML 2 PDF: HTML to PDF Converter
More Tools: PDF Converter
Hi Sven,
Thanks for the detailed coding explanation. It is very helpful.
I also wnonder, if you change the file name from Student_number_Eng/Math to Student_Eng/Math_number, how would you change your code? Let say, the student number is from 001 to 100. I tried to use for loop, but it seems like python doesn't like it.
Hi, it is very helpful. I have an issue when I tried to do this. I got with xw.App(visible=False) as app: AttributeError: _enter_ . Do you know why it happens. Thank you.
It is really helpful ! Thank you so much 🙂
Very nice example! I have a small question, why do you define the current_dir like that? I am always using something like os.getcwd() but now I am not sure if this is more efficient or not. Would you know if there is any difference? Thanks in advance and congratz for your content!
That was helpful, much appreciated!
How wonderful! Superb!
Extremely helpful, thank you!!