Create a xls file from a dict python [duplicate]

Question

Anyone knows how to create a xls file from a dict? I have a dictionary filled with words in a text, i want to put this DICT in a xls

def contar_Repetidas(texto):
    dic={}
    l=texto.split()
    for palabra in l:
        if palabra not in dic:
            dic[palabra] = 1
        else:
            dic[palabra] +=1
    return dic

It's diferent becorse, i want to create a MS Excel from a DICT, a DICT

its not duplicate,only XLS

Guillermo
– Guillermo

2013-08-26 16:47:56 +00:00
Commented Aug 26, 2013 at 16:47 — Guillermo
– Guillermo, Commented Aug 26, 2013 at 16:47

scohe001 · Accepted Answer · 2013-08-26 16:48:14Z

2

Using the xlwt module:

import xlwt

dic = contar_Repetidas("Some Text Here")

wb = xlwt.Workbook()
ws = wb.add_sheet("Your Sheet")

count = 0
for word, num in dic.items():
    count += 1
    ws.write(count, 1, word)
    ws.write(count, 2, num)

wb.save("/Path/To/Save/Example.xls")

answered Aug 26, 2013 at 16:48

scohe001

15.5k3 gold badges34 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create a xls file from a dict python [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related