[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

Verknüpfte Beiträge	Antworten	Ansichten
Cant download excel data from v11 using chrome anymore Gelöst excel	1 Nov. 22	3273
ODOO 12 how can we generate Excel report Gelöst excel	7 Jan. 24	16454
how to write an excel file into a field who is a field.Binary()? excel	0 Feb. 17	4147
How to create execel report in openerp7 excel	0 März 15	4698
How to use the module report_xls to generate XLS report in openerp ? excel	0 März 15	5918

Diese Frage wurde gekennzeichnet

Diskutieren Sie gerne? Treten Sie bei, statt nur zu lesen!

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