win32com.client .Cells

2015-10-09 Thread gall . pavgal . gall
Hi Guys, i wrote small function : Excel = win32com.client.Dispatch("Excel.Application") excel_book=Excel.Workbooks.Open('D:\WebPython\Config3.xlsx') s_config=excel_book.Worksheets('VA Prices') def writtenCell(row,col,value): try: global s_config print "row --

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 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

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