Skip to Content
This question has been flagged
excelxlsxwriter
2 Replies
5904 Rodiniai
Portretas
GrumpyKitty

I'm still learning with this technology. May I know how to put all values in one column using python and xlsx writer?

Ex.

my_dict = {
'Bob': ['eating', 'watching', 'drinking'], 
'Ann': ['shopping', 'eating', 'drawing'], 
'May': ['riding', 'singing', 'dancing']
}

What I did was putting it in another column temporarily.

col_num = 0
row_num = 7
for key, value in my_dict.items():
    worksheet.write(row_num, col_num, key)
    worksheet.write_column(row_num + 1, col_num, value)
    col_num += 1


May I know how can I achieve this kind of format? Hoping to get your opinions and suggestions. Thank you

NameHobby
Bobeating

watching

drinking
Annshopping

eating

drawing
Mayriding

singing

dancing
Portretas
Atmesti
GrumpyKitty
Autorius

Hi @Hemangi Rupareliya

I am not able to reply to your comment below. I appreciate your response.

I tried the string but it only returned the single letter per row only. Do you have examples for strings instead of integer?

Portretas
GrumpyKitty
Autorius Best Answer

I got it now. This is what I did:



row_num = 7
        
for key, value in my_dict.items():
    col_num = 0
    worksheet.write(row_num, col_num, key)
    for i in value:
        col_num = 1
        worksheet.write(row_num, col_num, i)
        row_num += 1
Portretas
Atmesti
Portretas
Hemangi Rupareliya(rupareliyahemangi145@gmail.com)
Best Answer

Hi Moto Dzae,

You can try following code:

worksheet.write(0, 0, 'Name')

worksheet.write(0, 1, 'Value')

row_num = 1

for key, value in my_dict.items():

    col_num = 0

    worksheet.write(row_num, col_num, key)

    for val in value:

        col_num = 1

        worksheet.write_column(row_num, col_num, val)

        row_num += 1

        

Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
Cant download excel data from v11 using chrome anymore Solved
excel
Portretas
Portretas
1
lapkr. 22
3255
ODOO 12 how can we generate Excel report Solved
excel
Portretas
Portretas
Portretas
Portretas
7
saus. 24
16432
how to write an excel file into a field who is a field.Binary()?
excel
Portretas
0
vas. 17
4116
How to create execel report in openerp7
excel
Portretas
0
kov. 15
4663
How to use the module report_xls to generate XLS report in openerp ?
excel
Portretas
0
kov. 15
5896