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