def test_issue_83_ods_file_handle():
# this proves that odfpy
# does not leave a file handle open at all
proc = psutil.Process()
test_file = get_fixtures("issue_61.ods")
open_files_l1 = proc.open_files()
# start with a csv file
data = pe.iget_array(file_name=test_file, library="pyexcel-ods")
open_files_l2 = proc.open_files()
delta = len(open_files_l2) - len(open_files_l1)
# cannot catch open file handle
assert delta == 0
# now the file handle get opened when we run through
# the generator
list(data)
open_files_l3 = proc.open_files()
delta = len(open_files_l3) - len(open_files_l1)
# cannot catch open file handle
assert delta == 0
# free the fish
pe.free_resources()
open_files_l4 = proc.open_files()
# this confirms that no more open file handle
eq_(open_files_l1, open_files_l4)
# -*- coding: utf-8 -*-
"""
Created on Sun Apr 21 21:04:54 2019
@author: x230
"""
import pyexcel as p
records = p.iget_records(file_name="your_file.xls")
for record in records:
print("%s is aged at %d" % (record['Name'], record['Age']))
p.free_resources()
def test_isave_book_as():
content = _produce_ordered_dict()
io = pe.isave_book_as(dest_file_type="xls", bookdict=content)
book2 = pe.get_book(file_content=io.getvalue(), file_type="xls")
assert book2.to_dict() == content
pe.free_resources()
def tearDown(self):
pe.free_resources()
import pyexcel as pe
from pptx import Presentation
print("""
Exemplo de criação de apresentação PPTX simples utilizando dados de Excel
Day 24 Code Python - 23/05/2018
""")
records = pe.iget_records(file_name="/mnt/VersaoBeta/Python/PythonBasico/Projetos/apresentacao_automatica.xlsx")
texto = ['python-pptx funcionou legal!']
for record in records:
texto.append(str(record['nome']) + ' com idade ' + str(record['idade']))
pe.free_resources()
prs = Presentation()
title_slide_layout = prs.slide_layouts[0]
slide = prs.slides.add_slide(title_slide_layout)
title = slide.shapes.title
subtitle = slide.placeholders[1]
title.text = "Yes mano!"
subtitle.text = str(texto)
prs.save('/mnt/VersaoBeta/Python/PythonBasico/Projetos/apresentacao_automatica.pptx')
print(texto)
def free_resources(self):
"""
After you have used iget_array and iget_records, it's
recommended to call this function
"""
pe.free_resources()
"Age": 28
}, {
"Name": 'Beatrice',
"Age": 29
}, {
"Name": 'Ceri',
"Age": 30
}, {
"Name": 'Dean',
"Age": 26
}]
pyexcel.save_as(records=a_list_of_dictionaries,
dest_file_name="your_file.xlsx")
records = pyexcel.iget_records(file_name="your_file.xlsx")
print(type(records))
for record in records:
print("%s is aged at %d" % (record['Name'], record['Age']))
# search_field = 'Name'
# search_sub_field = 'Beatrice'
for record in records:
# print(type(record['Name']))
# if record[search_field] == record[search_sub_field]:
# print("oh hi, it's me!! | ")
print("%s is aged at %d" % (record['Name'], record['Age']))
pyexcel.free_resources()