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