Python - Xlwt more than 256 columns -
i importing text files excel using xlwt module. allows 256 columns stored. there ways solve problem?
xlwt
supports creation of xls files of kind created excel 97-2003 , read excel 97 onwards. file format limited 256 columns , 65536 rows. no amount of changing 256 other number in xlwt
source code change that.
you have 3 options, in increasing order of complexity:
(1) suggested another, write csv file.
(2) openpyxl ... excel 2007+ xlsx/xlsm format
(3) win32 com (windows only)
Comments
Post a Comment