How to make Excel file as database using Python scripts?
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to make Excel file as database using Python scripts?
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?
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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/
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Marsha_R
[Community Hero]
____
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame
