User Interaction with Excel sheet

[ShruthiLS]

Hi Everyone,

I am new to python and wanted to open the excel file while .py script is running and it should wait for the user to enter the input to the excel file without using any module i.e.,(xlsxwriter,xlswt,xlrd)
Suggestions are welcome.

Thank you,
Shruthi LS

[Larz60+]

Are you saying you don't want to use xlsxwriter, xlswt, xlrd, etc.?

[snippsat]

user to enter the input to the excel file without using any module i.e.,(xlsxwriter,xlswt,xlrd)

There is no way to do this without using a connection(or write one yourself),the old was to use win32com.client.
In newer time there has come a lot of better tools than using win32,some do you mention or better OpenPyxl, Pandas, pyexcel.

[ShruthiLS]

Thank you all for the reply,Now I am able to read the excel file by changing to .csv format. But the requirement is as I change the data in the .csv file it should reflect automatically, and that is not happening and my python Interpreter doesn't support any module like I mentioned above. This is the test code attached and this should be integrated with the large module. What are the suggestions to improve the below code so that I can Interact with the .csv file on the fly.

from gi import *
filename=("hello12.csv")
file=open(filename,"r")
lines = file.read()
x = lines.split(",")
for i in range(len(x)):
print(x[i])

[Larz60+]

Reading a .csv file does just that, read the file. It's not designed to do anything else.
If you want to interact directly with excel file, use OpenPyxl, Pandas or pyexcel as suggested by snippsat.

[ShruthiLS]

Ok thank you, let me check. And can I pass the file object as an argument for the other function and access the file contents in the other function? Is it possible?? If so,please give me a articles to move forward.

[Larz60+]

Read the docs!
pyexcel: https://github.com/pyexcel/pyexcel
pandas: http://pandas.pydata.org/
OpenPyxl: https://openpyxl.readthedocs.io/en/stable/

[snippsat]

Reading a csv from excel is not a the same Excel file formats.
Excel can read and output text file formats as txt,csv ect...
If have csv file can read it as normal file or use csv module.

data.csv:

Output:
Year,Make,Model,Length
1997,Ford,E350,2.34
2000,Mercury,Cougar,2.38

import csv

with open('data.csv') as f:
    data = csv.reader(f, delimiter=',')
    for row in data:
        print(row)

Output:
['Year', 'Make', 'Model', 'Length']
['1997', 'Ford', 'E350', '2.34']
['2000', 'Mercury', 'Cougar', '2.38']

Ok thank you, let me check. And can I pass the file object as an argument for the other function and access the file contents in the other function? Is it possible?? If so,please give me a articles to move forward.

That's no problem,you most explain better what you want do.