Guest User

Untitled

a guest
Feb 19th, 2017
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. import ezodf
  2. from . import db
  3.  
  4. ezodf.config.set_table_expand_strategy('all')
  5. current_spreadsheet = ezodf.opendoc(filename='./table1.ods')
  6. current_table = current_spreadsheet.sheets[-1]
  7. for row_num in range(current_table.nrows()):
  8. db.session.add(
  9. Model_1(
  10. id=current_table['a%s' % row_num].value,
  11. name=current_table['b%s' % row_num].value
  12. )
  13. )
  14.  
  15. db.session.commit()
  16.  
  17. with ezodf.opendoc(filename='./table1.ods') as spreadsheet:
  18. with spreadsheet.sheets[-1] as table:
  19. for row_num in range(table.nrows()):
  20. db.session.add(
  21. Model_1(
  22. id=table['a%s' % row_num].value,
  23. name=table['b%s' % row_num].value
  24. )
  25. )
  26.  
  27. File "uploader.py", line 36, in <module>
  28. with ezodf.opendoc(filename='./table_1.ods') as spreadsheet:
  29. AttributeError: __exit__
  30.  
  31. ezodf - 0.3.2
  32. lxml - 3.7.2
  33. python - 3.5
Add Comment
Please, Sign In to add comment