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

gall.pavgal.gall at gmail.com gall.pavgal.gall at gmail.com
Thu Oct 8 05:58:41 EDT 2015


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/oneMoreTest.py", line 15, in <module>
    wb = load_workbook(filename='D:\WebPython\COX.DSG.Offering Product Catalog VANE.xlsx')
  File "C:\Python27\lib\site-packages\openpyxl\reader\excel.py", line 149, in load_workbook
    _load_workbook(wb, archive, filename, read_only, keep_vba)
  File "C:\Python27\lib\site-packages\openpyxl\reader\excel.py", line 236, in _load_workbook
    color_index=wb._colors)
  File "C:\Python27\lib\site-packages\openpyxl\reader\worksheet.py", line 327, in read_worksheet
    fast_parse(ws, xml_source, shared_strings, style_table, color_index)
  File "C:\Python27\lib\site-packages\openpyxl\reader\worksheet.py", line 315, in fast_parse
    parser.parse()
  File "C:\Python27\lib\site-packages\openpyxl\reader\worksheet.py", line 88, in parse
    stream = _get_xml_iter(self.source)
  File "C:\Python27\lib\site-packages\openpyxl\reader\worksheet.py", line 36, in _get_xml_iter
    xml_source = xml_source.encode("utf-8")
MemoryError



More information about the Python-list mailing list