Not able to export data into Excel using xlsxwriter library-CodePudding

I'm trying to iterate a For Loop such that the elements in the two lists get exported to excel in columns A and B. However, whenever I run the code it only displays a single number in column B row 1 (B1).

The entire code is too long so I'm attaching just a snippet of the code where I am stuck.

consider the given lists => prod_codes, ID_codes. The below code will write each list as a column in an excel sheet. The parameters of worksheet.write() are as shown below

worksheet.write(row_number,column_number,value_to_be_written)

    prod_codes = [1001,1002,1003,1004,1005,1006]
    ID_codes = [123,345,567,789,908,345]
    with xlsxwriter.Workbook('PATH for XLSX to be created') as workbook:
            worksheet = workbook.add_worksheet("NAME_ME")
            for index,value in enumerate(ID_codes):
                   worksheet.write(index,0,value)
            
            for index,value in enumerate(prod_codes):
                   worksheet.write(index,1,value)

Please go through the official documentation, it's clear how to perform what you need to perform.