how to iterate ods

This is the place for queries that don't fit in any of the other categories.

how to iterate ods

Postby verb » Sun Sep 25, 2016 8:26 pm

Hello everyone if you had any experience with pyexcel and know how to iterate over big ods file please let me know .. my file is over 50000 lines per sheet about 10 sheets thats why i prefer to iterate and not loading it in to the memory.
verb
 
Posts: 17
Joined: Fri Feb 22, 2013 8:15 pm

Re: how to iterate ods

Postby Larz60+ » Mon Sep 26, 2016 1:10 am

Hello,

Use pyexcel

Larz60+
Larz60+
 
Posts: 1307
Joined: Thu Apr 03, 2014 4:06 pm

Re: how to iterate ods

Postby verb » Tue Sep 27, 2016 12:20 pm

Hello Larz60+
my question was how to user pyexcel to iterate over any ods sheet ,, What i have tried until now is reading the sheet with the function get_data from pyexcel but it looks as it is trying to read whole file in memory and if i have huge file with 50000 lines per sheet it tooks long time to read it..That's why i want to iterate and print line by line.
verb
 
Posts: 17
Joined: Fri Feb 22, 2013 8:15 pm

Re: how to iterate ods

Postby sparkz_alot » Tue Sep 27, 2016 1:21 pm

It would be helpful if you were to post the relevant code you've written so far. This way people can look at it and offer suggestions on how to improve it.
THIS FORUM WILL BE CLOSING OCT 1, 2016. PLEASE STOP BY AND REGISTER AT THE NEW LOCATION
http://python-forum.io
User avatar
sparkz_alot
 
Posts: 269
Joined: Sat Dec 06, 2014 2:55 pm
Location: US

Re: how to iterate ods

Postby Ofnuts » Tue Sep 27, 2016 3:44 pm

verb wrote:Hello Larz60+
my question was how to user pyexcel to iterate over any ods sheet ,, What i have tried until now is reading the sheet with the function get_data from pyexcel but it looks as it is trying to read whole file in memory and if i have huge file with 50000 lines per sheet it tooks long time to read it..That's why i want to iterate and print line by line.


https://pyexcel.readthedocs.io/en/latest/bigdata.html
This forum has been moved to http://python-forum.io/. See you there.
User avatar
Ofnuts
 
Posts: 2659
Joined: Thu May 14, 2015 9:46 am
Location: Paris, France, EU, Earth, Solar system, Milky Way, Local Cluster, Universe #32987440940987


Return to General Coding Help

Who is online

Users browsing this forum: No registered users and 2 guests