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

Popular posts from this blog

objective c - Change font of selected text in UITextView -

php - Accessing POST data in Facebook cavas app -

c# - Getting control value when switching a view as part of a multiview -