How to write in excel sheet using nested loop

Question

import xlsxwriter
row = 0
col = 0
a = ['1', '2', '3','4','5']
with xlsxwriter.Workbook('D:\\Master\\Codingfiles\\' + 'SSDATA5.xlsx') as workbook:
    worksheet1 = workbook.add_worksheet
    for x in a:
        worksheet1.write(row, col,x)
        row+=1

Hi i am a beginner,When i run this code it runs properly and write in values from 'a' in first 5 rows of excel sheet but I want to create a code using nested loop like this

import xlsxwriter
row = 0
col = 0
a = ['1', '2', '3','4','5']
with xlsxwriter.Workbook('D:\\Master\\Codingfiles\\' + 'SSDATA5.xlsx') as workbook:
    worksheet1 = workbook.add_worksheet()
for i in a:
    for x in a:
        worksheet1.write(row, col,x)
        row+=1

This code does not write above data in excel sheet. Please Help me

You should probably tag the programming language you are using so the SME can be alerted. — Scott Craner
– Scott Craner, Commented Oct 5, 2021 at 19:29

ipj · Accepted Answer · 2021-10-05 19:52:54Z

2

In python intendation matters, so try:

import xlsxwriter
row = 0
col = 0
a = ['1', '2', '3','4','5']
with xlsxwriter.Workbook('D:\\Master\\Codingfiles\\' + 'SSDATA5.xlsx') as workbook:
    worksheet1 = workbook.add_worksheet()
    for i in a:
        for x in a:
            worksheet1.write(row, col,x)
            row+=1

More: https://www.geeksforgeeks.org/indentation-in-python/

answered Oct 5, 2021 at 19:52

ipj

3,5981 gold badge17 silver badges18 bronze badges

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

Comments

Mahrkeenerh · Accepted Answer · 2021-10-05 19:52:15Z

0

Seems like your for loop from the second code is not tabbed properly, and is outside with.

answered Oct 5, 2021 at 19:52

Mahrkeenerh

1,1201 gold badge11 silver badges27 bronze badges

Collectives™ on Stack Overflow

How to write in excel sheet using nested loop

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related