[Update] How to put all values in a column in Python using xlsxwriter

Question

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

Ma

GrumpyKitty · Accepted 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

Hemangi Rupareliya(rupareliyahemangi145@gmail.com) · 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

Gerelateerde posts	Antwoorden	Weergaven
Cant download excel data from v11 using chrome anymore Opgelost excel	1 nov. 22	2554
ODOO 12 how can we generate Excel report Opgelost excel	7 jan. 24	15184
how to write an excel file into a field who is a field.Binary()? excel	0 feb. 17	3246
How to create execel report in openerp7 excel	0 mrt. 15	3925
How to use the module report_xls to generate XLS report in openerp ? excel	0 mrt. 15	5121

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Name	Hobby
Bob	eating
	watching
	drinking
Ann	shopping
	eating
	drawing
May	riding
	singing
	dancing