bd62
Last Activity: Mar 15 '10, 03:02 PM
Joined: Mar 9 '10
Location:
-
Yes thanks bvdet. Took me a little while to test it and respond from your previous post but sheet_object.ro w_values(row_nu mber) worked perfectly. That's exactly what I needed. Thanks for your help -
Thanks Glenton. Code tags, I will remember that.
cell.ctype will return False when it checks a cell that has no data in it PROVIDING there's data somewhere within the same column, just on a different row, than the cell resides. i hope that makes sense. where I get the error is when it hits a column that has absolutely no data in any of it's rows.
I agree with your second thought. I'm certain there's another way to do...Leave a comment:
-
how to find the next available column in an excel spreadsheet.
I want to output the results of a Python script to the next available column (one without any data in it) of a specified row in an excel spreadsheet (XLS). Below is the portion of my code to do that:
...Code:col_test = 1 col_num = open_workbook(subnet) sheet = col_num.sheet_by_index(0) cell = sheet.cell(1,col_test) cell.ctype == XL_CELL_TEXT while cell.ctype == True: col_test = col_test +
No activity results to display
Leave a comment: