Python Forum
iterate read data from excel sheet
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
iterate read data from excel sheet
#1
In my excel sheet1 I have data like below:
Header1
textdata1
textdata2
...

Each loop I want to read the data to another app but I'm not sure how to do this. At the moment my code just repeatedly reading the textdata1. I have done my code as below:

while exists("someimage.png"):            
     with open(file) as f:
     data = csv.reader(f) 
     i = 1                
     data = [row[0] for row in data]                
     type(data[i])


Could someone please help me? Thanks
Reply
#2
It seems like your question is "how can I read the data to another app?" I don't know what that means - is there a specific app you're trying to "read" to? What does "read" mean here?
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Help with to check an Input list data with a data read from an external source sacharyya 3 408 Mar-09-2024, 12:33 PM
Last Post: Pedroski55
  How to copy work sheet data one workbook to other? sayyedkamran 2 696 Nov-03-2023, 09:10 AM
Last Post: Larz60+
  Python and pandas: Aggregate lines form Excel sheet Glyxbringer 12 1,857 Oct-31-2023, 10:21 AM
Last Post: Pedroski55
  Copy data from Excel and paste into Discord (Midjourney) Joe_Wright 4 2,050 Jun-06-2023, 05:49 PM
Last Post: rajeshgk
  Reading data from excel file –> process it >>then write to another excel output file Jennifer_Jone 0 1,102 Mar-14-2023, 07:59 PM
Last Post: Jennifer_Jone
  Correctly read a malformed CSV file data klllmmm 2 1,941 Jan-25-2023, 04:12 PM
Last Post: klllmmm
  how to read txt file, and write into excel with multiply sheet jacklee26 14 9,958 Jan-21-2023, 06:57 AM
Last Post: jacklee26
  How to properly format rows and columns in excel data from parsed .txt blocks jh67 7 1,878 Dec-12-2022, 08:22 PM
Last Post: jh67
  Trying to Get Arduino sensor data over to excel using Python. eh5713 1 1,712 Dec-01-2022, 01:52 PM
Last Post: deanhystad
  Read nested data from JSON - Getting an error marlonbown 5 1,367 Nov-23-2022, 03:51 PM
Last Post: snippsat

Forum Jump:

User Panel Messages

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