[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

Related Posts	Odpovědi	Zobrazení
Cant download excel data from v11 using chrome anymore Vyřešeno excel	1 lis 22	3273
ODOO 12 how can we generate Excel report Vyřešeno excel	7 led 24	16450
how to write an excel file into a field who is a field.Binary()? excel	0 úno 17	4146
How to create execel report in openerp7 excel	0 bře 15	4692
How to use the module report_xls to generate XLS report in openerp ? excel	0 bře 15	5915

This question has been flagged

Enjoying the discussion? Don't just read, join in!

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