iterate through query result

[deanhystad]

No idea about adding tuples to a spreadsheet. The help text for whatever spreadsheet package you are using will provide that information. You mentioned your code worked when you used fetchone(). How does the fetchone() return value differ from the fetchall() return value? Is there a way you can process the fetchall() return value to get what you want?

Why do you think fetchone() and fetchall() return different data types? There has to be a reason. When you understand that reason I think you will no longer have a problem adding values to the spreadsheet.