Export python loop results to corresponding columns in Excel using xlsxwriter

Question

I have a loop which retrieves two lists of values from some json. I would like to export each one of the values list (1000 results each one) with its header to Exscel. All values are available when I'm printing the results, but Excel sheet contains only header and a single row. Perhaps, I'm missing some loop to add. Any help is appreciated!

list = x.json() 
    
workbook = xlsxwriter.Workbook('test.xlsx')
worksheet = workbook.add_worksheet()

for item in list:
    item1 = value1['valueID1']
    item2 = value2['valueID2']

    data = {"item1": [item1],"item2": [item2]}

    col_num = 0
    for key, value in data.items():
        worksheet.write(0, col_num, key)
        worksheet.write_column(1, col_num, value)
        col_num += 1
    workbook.close()

Python Bang · Accepted Answer · 2022-07-28 08:35:22Z

1

You need to increment the row value as well.

list = x.json() 
    
workbook = xlsxwriter.Workbook('test.xlsx')
worksheet = workbook.add_worksheet()

for item in list:
    item1 = value1['valueID1']
    item2 = value2['valueID2']

    data = {"item1": [item1],"item2": [item2]}

    col_num = 0
    row_num = 0

    for key, value in data.items():
        worksheet.write(row_num , col_num, key)
        worksheet.write_column(row_num , col_num, value)
        col_num += 1
    row_num=row_num+1
workbook.close()

edited Jul 28, 2022 at 8:35

answered Jul 28, 2022 at 6:17

Python Bang

4827 silver badges20 bronze badges

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

5 Comments

l3xand3r Over a year ago

Thank you, unfortunately, this didn't help.

jmcnamara Over a year ago

@l3xand3r you do need to apply this fix. You also need to move the close() out of the loop. You are closing the file on the first iteration.

Python Bang Over a year ago

@I3xand3r i have edited the code as per jmcnamara comment.

l3xand3r Over a year ago

No luck with this as well... Still get a single row result

Python Bang Over a year ago

Please post the sample input data for us to test

Collectives™ on Stack Overflow

Export python loop results to corresponding columns in Excel using xlsxwriter

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related