Re: change data in large excel file(more than 240 000 rows on sheet)

2015-10-09 Thread alister
On Fri, 09 Oct 2015 01:21:37 -0700, gall.pavgal.gall wrote: > Thanks Laura! > But i need to change existing excel file and if i use the optimised > reader, i can read data only, but i can't change data. I know it does not help but if you have this amount of data being stored in a spreadsheet you

Re: change data in large excel file(more than 240 000 rows on sheet)

2015-10-09 Thread harirammanohar159
On Wednesday, 7 October 2015 19:44:12 UTC+5:30, gall.pav...@gmail.com wrote: > Hi Guys, > I need to change data in large excel file(more than 240 000 rows on sheet), > it's possible through win32com.client, but i need use Linux OS ... > Please, could you advise some-thing su

Re: change data in large excel file(more than 240 000 rows on sheet)

2015-10-09 Thread Laura Creighton
In a message of Fri, 09 Oct 2015 01:21:37 -0700, gall.pavgal.g...@gmail.com wri tes: >Thanks Laura! >But i need to change existing excel file and if i use the optimised reader, i >can read data only, but i can't change data. Hmmm. When I have this problem I have other problems as well, and the

Re: change data in large excel file(more than 240 000 rows on sheet)

2015-10-09 Thread gall . pavgal . gall
Thanks Laura! But i need to change existing excel file and if i use the optimised reader, i can read data only, but i can't change data. -- https://mail.python.org/mailman/listinfo/python-list

Re: change data in large excel file(more than 240 000 rows on sheet)

2015-10-08 Thread Laura Creighton
You need to use the optimised reader. https://openpyxl.readthedocs.org/en/latest/optimized.html Laura -- https://mail.python.org/mailman/listinfo/python-list

Re: change data in large excel file(more than 240 000 rows on sheet)

2015-10-08 Thread gall . pavgal . gall
thanks Guys! xlrd it's cool, but i need change existing file, which contains some sheets with large data...) So, if i use xlwt(i.e. create new excel document), i will lose data from other sheets. I tried use openpyxl, but got error : Traceback (most recent call last): File "D:/WebPython/oneMor

Re: change data in large excel file(more than 240 000 rows on sheet)

2015-10-07 Thread Joel Goldstick
On Wed, Oct 7, 2015 at 10:18 AM, Mark Lawrence wrote: > On 07/10/2015 15:13, gall.pavgal.g...@gmail.com wrote: > >> Hi Guys, >> I need to change data in large excel file(more than 240 000 rows on >> sheet), it's possible through win32com.client, but i need use Linu

Re: change data in large excel file(more than 240 000 rows on sheet)

2015-10-07 Thread Mark Lawrence
On 07/10/2015 15:13, gall.pavgal.g...@gmail.com wrote: Hi Guys, I need to change data in large excel file(more than 240 000 rows on sheet), it's possible through win32com.client, but i need use Linux OS ... Please, could you advise some-thing suitable! best regards, Pavel. http://www.p

change data in large excel file(more than 240 000 rows on sheet)

2015-10-07 Thread gall . pavgal . gall
Hi Guys, I need to change data in large excel file(more than 240 000 rows on sheet), it's possible through win32com.client, but i need use Linux OS ... Please, could you advise some-thing suitable! best regards, Pavel. -- https://mail.python.org/mailman/listinfo/python-list