Skip to Content
This question has been flagged
excelxlsxwriter
2 Replies
4239 Views
Avatar
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
Avatar
Discard
GrumpyKitty
Author

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?

Avatar
GrumpyKitty
Author 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
Avatar
Discard
Avatar
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

        

Avatar
Discard
Related Posts Replies Views Activity
Cant download excel data from v11 using chrome anymore Solved
excel
Avatar
Avatar
1
Nov 22
1512
ODOO 12 how can we generate Excel report Solved
excel
Avatar
Avatar
Avatar
Avatar
7
Jan 24
13938
how to write an excel file into a field who is a field.Binary()?
excel
Avatar
0
Feb 17
2302
How to create execel report in openerp7
excel
Avatar
0
Mar 15
3098
How to use the module report_xls to generate XLS report in openerp ?
excel
Avatar
0
Mar 15
4365