Python Forum
User Interaction with Excel sheet
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
User Interaction with Excel sheet
#4
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])
Reply


Messages In This Thread
User Interaction with Excel sheet - by ShruthiLS - Jun-14-2018, 12:05 PM
RE: User Interaction with Excel sheet - by Larz60+ - Jun-14-2018, 02:42 PM
RE: User Interaction with Excel sheet - by snippsat - Jun-14-2018, 03:33 PM
RE: User Interaction with Excel sheet - by ShruthiLS - Jun-15-2018, 05:50 AM
RE: User Interaction with Excel sheet - by Larz60+ - Jun-15-2018, 09:09 AM
RE: User Interaction with Excel sheet - by Larz60+ - Jun-15-2018, 01:48 PM
RE: User Interaction with Excel sheet - by snippsat - Jun-15-2018, 03:50 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Simple linear regression with interaction summary table Andrzej_Andrzej 0 410 Feb-21-2024, 07:44 AM
Last Post: Andrzej_Andrzej
  Split excel file and write output at specific row and set sheet position DSCA 0 2,085 May-12-2022, 07:29 PM
Last Post: DSCA
  Protein interaction chains Amniote 2 2,273 Jun-12-2019, 03:32 PM
Last Post: Amniote
  How to import dats from one sheet to another sheet based on Substring using python Vigneshkumarsakthivel 0 2,420 Sep-05-2018, 01:49 PM
Last Post: Vigneshkumarsakthivel

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020