ValueError: row index was 5, not allowed by .xls format

【Bug】ValueError: row index was 65536, not allowed by .xls format

行数达到上限,改成 to_csv

ValueError: row index was 5, not allowed by .xls format

发现 5 根本不是行数上限,把行列数,int 一下,因为这几个数据,是从 pandas.dataframe 取出来的,可能是numpy.int64 类型,不太兼容

self.worksheet.write_merge(int(j[0]), int(j[1]), int(idx), int(idx), self._fit_value(value))
原文地址:https://www.cnblogs.com/pythonwl/p/15103000.html