Export a loop in Python to Excel

Question

I am starting with Python and I am running into difficulty. I am trying to pass the result of a loop in Python to a specific sheet and column of an Excel file.

I am doing it with XlsWriter but it doesn't work. For example, if you want to pass the result of this loop of random numbers, what is wrong with this code?

Example:

import xlsxwriter  
workbook = xlsxwriter.Workbook(r'C:\Users\Me\Downloads\ej.xlsx')
worksheet = workbook.add_worksheet("Hoja1")
worksheet.write('A1', 'NUMEROS')
from random import seed
from random import random
seed(1)
row =0
for _ in range(5):
    value = random()
    worksheet.write(row, 1, value)
    row += 1    
    print(value)

Sorry for my English, I am not a native speaker.

Thanks a lot.

JavMM · Accepted Answer · 2021-02-25 11:56:57Z

1

You need to close it.

import xlsxwriter  
workbook = xlsxwriter.Workbook(r'C:\Users\Me\Downloads\ej.xlsx')
worksheet = workbook.add_worksheet("Hoja1")
worksheet.write('A1', 'NUMEROS')
from random import seed
from random import random
seed(1)
row =0
for _ in range(5):
    value = random()
    worksheet.write(row, 1, value)
    row += 1    
    print(value)

workbook.close()

answered Feb 25, 2021 at 11:56

JavMM

812 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Export a loop in Python to Excel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related