Ir al contenido
Se marcó esta pregunta
excelxlsxwriter
2 Respuestas
5910 Vistas
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
Descartar
GrumpyKitty
Autor

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
Autor Mejor respuesta

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
Descartar
Avatar
Hemangi Rupareliya(rupareliyahemangi145@gmail.com)
Mejor respuesta

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
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
Cant download excel data from v11 using chrome anymore Resuelto
excel
Avatar
Avatar
1
nov 22
3257
ODOO 12 how can we generate Excel report Resuelto
excel
Avatar
Avatar
Avatar
Avatar
7
ene 24
16435
how to write an excel file into a field who is a field.Binary()?
excel
Avatar
0
feb 17
4117
How to create execel report in openerp7
excel
Avatar
0
mar 15
4664
How to use the module report_xls to generate XLS report in openerp ?
excel
Avatar
0
mar 15
5897