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))
posted @ 2021-08-05 13:57  pythoner_wl  阅读(386)  评论(0编辑  收藏  举报