Python 3 writing in excel

Mike Dean

I'm kind of new programming, and I have learnt something in python. So, I want to creat a program, which adds data to an excel file. Each time a run it, it should creat a new colunm and type the information x,y,z,w which is asked, hope the print helps:

Expand|Select|Wrap|Line Numbers

 import csv

day=str(intput("day?"))

x=int(input("question1?"))

y=int(input("question2?"))

z=int(input("question3?"))

i stucked here....

Thanks for your time, Mike

Post Reply

bvdet

To write the data to a file:

Expand|Select|Wrap|Line Numbers

 >>> day = "Friday"

>>> x = 1

>>> y = 2

>>> z = 3

>>> f = open("data.csv", "w")

>>> f.write(",".join([str(item) for item in (day,x,y,z)]))

>>> f.close()

That creates a file with 4 columns on one row. If you want one column with 4 rows:

Expand|Select|Wrap|Line Numbers

>>> f.write("\n".join([str(item) for item in (day,x,y,z)]))

Mike Dean

I have saved a excell file named data in python's folder, but he's not writing there...

I have python 3 installed on my pc, do I have to install in module?

bvdet

In order to write to a new excel file, you will need module xlwt.

Python 3 writing in excel

✓ answered by bvdet

Post your reply

Question stats

Most Active

Most Questions Answered

Top Questions

Latest Questions

More