Skip ke Konten
Pertanyaan ini telah diberikan tanda
excelxlsxwriter
2 Replies
5928 Tampilan
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
Buang
GrumpyKitty
Penulis

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
Penulis Jawaban Terbai

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
Buang
Avatar
Hemangi Rupareliya(rupareliyahemangi145@gmail.com)
Jawaban Terbai

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
Buang
Post Terkait Replies Tampilan Aktivitas
Cant download excel data from v11 using chrome anymore Diselesaikan
excel
Avatar
Avatar
1
Nov 22
3270
ODOO 12 how can we generate Excel report Diselesaikan
excel
Avatar
Avatar
Avatar
Avatar
7
Jan 24
16449
how to write an excel file into a field who is a field.Binary()?
excel
Avatar
0
Feb 17
4143
How to create execel report in openerp7
excel
Avatar
0
Mar 15
4689
How to use the module report_xls to generate XLS report in openerp ?
excel
Avatar
0
Mar 15
5914