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
-- 
https://mail.python.org/mailman/listinfo/python-list

Reply via email to