I have attached the VB script.txt which has code for making excel file as database. But, we have a requirement that this should be written in Python. I'm very new to python programming. can anyone please help me the script?
What exactly is difficult for you?
I can help, but I will not reorganize all your code.
Generally:
- you are able to declare and assign variables simultaneously
- use while not instead of Do Until
Better to read documentation to learn, what Python's constructions are equal to your VBScript code, and then ask more specific question - https://docs.python.org/3/
Google has a lot of references for "read excel in python"
This one looked useful to me, but you may see others that work better
https://automatetheboringstuff.com/chapter12/
You may want to start over from the beginning rather than trying to translate from one language to the other.
