Welcome to python-forum.io

Results

Search Results

Post

Author

Forum

Replies

Views

Posted [asc]

Thread: Assigning iter_row value to variable
Post: RE: Assigning iter_row value to variable

Although I feel really dumb I just wanted to share the problem in case anyone finds the thread in the future.... The problem was that I left the column headers in the sheet one of which was 'occurren...

ankey

General Coding Help

9,054

Sep-24-2018, 03:51 PM

Thread: Assigning iter_row value to variable
Post: RE: Assigning iter_row value to variable

(Sep-18-2018, 08:59 PM)volcano63 Wrote: (Sep-18-2018, 07:48 PM)ankey Wrote: Output: --------------------------------------------------------------------------- ValueError Traceback (most recent ca...

ankey

General Coding Help

9,054

Sep-19-2018, 12:27 PM

Thread: Assigning iter_row value to variable
Post: RE: Assigning iter_row value to variable

Thanks for the help. Here's the full code: # Import `load_workbook` module from `openpyxl` from openpyxl import load_workbook # Load in the workbook wb = load_workbook('myFile.xlsx') #activate a sh...

ankey

General Coding Help

9,054

Sep-18-2018, 07:48 PM

Thread: Assigning iter_row value to variable
Post: RE: Assigning iter_row value to variable

(Sep-18-2018, 03:48 PM)Larz60+ Wrote: if int(row[1].value) == 1: Thanks for the input Larz60+ but when I try the suggested change I get the following error: ValueError: invalid literal for int() wi...

ankey

General Coding Help

9,054

Sep-18-2018, 04:35 PM

Thread: Assigning iter_row value to variable
Post: Assigning iter_row value to variable

I'm trying to load and read through an excel file and based on the value of a cell write the row to another file. Problem I'm having now is that row[1].value is a string and I need to convert it to a...

ankey

General Coding Help

9,054

Sep-18-2018, 03:45 PM

Thread: Very basic help - python & Excel
Post: RE: Very basic help - python & Excel

Thanks for the help and pointers - much appreciated. I am still working through through the datacamp lessons but it takes time. In parallel I'm now starting to get somewhere with my project but faili...

ankey

Data Science

3,782

Sep-18-2018, 08:16 AM

Thread: Very basic help - python & Excel
Post: RE: Very basic help - python & Excel

Thanks for the input Larz60+ Still can't seem to find reference in those links that help. I have now started to get somewhere with the following: # Import `load_workbook` module from `openpyxl` fro...

ankey

Data Science

3,782

Sep-17-2018, 08:11 PM

Thread: Very basic help - python & Excel
Post: Very basic help - python & Excel

Hi All, I have an excel file with two columns: table and number. All I want to do is use Python to load an excel file, loop through each row and write the row to a new file as many times as the resp...

ankey

Data Science

3,782

Sep-17-2018, 03:39 PM

Results

User Panel Messages

Announcements