Python Forum
how to use pyexcel to read ods
Thread Rating:
  • 3 Vote(s) - 3 Average
  • 1
  • 2
  • 3
  • 4
  • 5
how to use pyexcel to read ods
#1
Hello everyone

I have posted this on the previous forum but didn't resolve this issue. I  have big ods file ( HERE )

and i am trying to read only some parts of the file for example first row but whatever i tried pyexcel tries to load whole sheet in memory before it read anything from the file and this takes a lot of time. Here is my code if anyone has idea how to read single row please let me know

from pyexcel_ods import get_data


part_data=get_data("arhiv.ods",start_row=4,row_limits=1)
print(json.dumps(part_data))

here is the code :

from pyexcel_ods import get_data

part_data=get_data("arhiv.ods",start_row=4,row_limits=1)
print(json.dumps(part_data))
Reply


Messages In This Thread
how to use pyexcel to read ods - by verb - Oct-14-2016, 10:16 AM
RE: how to use pyexcel to read ods - by snippsat - Oct-14-2016, 10:36 AM
RE: how to use pyexcel to read ods - by verb - Oct-14-2016, 11:12 AM
RE: how to use pyexcel to read ods - by snippsat - Oct-14-2016, 02:49 PM
RE: how to use pyexcel to read ods - by verb - Oct-15-2016, 09:39 AM
RE: how to use pyexcel to read ods - by Larz60+ - Oct-15-2016, 12:51 PM
RE: how to use pyexcel to read ods - by pystarter - Feb-02-2017, 09:29 PM

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020