[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

관련 게시물	답글	화면
Cant download excel data from v11 using chrome anymore 해결 완료 excel	1 11월 22	2555
ODOO 12 how can we generate Excel report 해결 완료 excel	7 1월 24	15186
how to write an excel file into a field who is a field.Binary()? excel	0 2월 17	3256
How to create execel report in openerp7 excel	0 3월 15	3927
How to use the module report_xls to generate XLS report in openerp ? excel	0 3월 15	5124

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!

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