Ask a Question

How to make Excel file as database using Python scripts?

Daniellovesmith
Contributor

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?

2 REPLIES 2
baxatob
Community Hero

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.  


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
cancel
Showing results for 
Search instead for 
Did you mean: