Python将结果保存到.xls文件

Question

我正在做一个项目，我必须把结果保存到excel文件中。我在项目结束时发出命令，运行良好，但现在出现以下错误：

Traceback (most recent call last):
  File "C:\Users\5460\Desktop\Code\scikit-learn svm_body.py", line 139, in <module>
    main()
  File "C:\Users\5460\Desktop\Code\scikit-learn svm_body.py", line 136, in main
    wb.save('SVMResults_body001.xls')
  File "C:\Python27\lib\site-packages\xlwt\Workbook.py", line 662, in save
    doc.save(filename, self.get_biff_data())
  File "C:\Python27\lib\site-packages\xlwt\Workbook.py", line 637, in get_biff_data
    shared_str_table   = self.__sst_rec()
  File "C:\Python27\lib\site-packages\xlwt\Workbook.py", line 599, in __sst_rec
    return self.__sst.get_biff_record()
  File "C:\Python27\lib\site-packages\xlwt\BIFFRecords.py", line 76, in get_biff_record
    self._add_to_sst(s)
  File "C:\Python27\lib\site-packages\xlwt\BIFFRecords.py", line 91, in _add_to_sst
    u_str = upack2(s, self.encoding)
  File "C:\Python27\lib\site-packages\xlwt\UnicodeUtils.py", line 55, in upack2
    raise Exception('String longer than 32767 characters')
Exception: String longer than 32767 characters

我的部分代码如下：

^{pr2}$

你知道我做错了什么吗？谢谢！在

Answer 1

您正在写入的字符串超出了接口允许的长度-超过32k（带符号短整数的最大值）。你需要把绳子剪成较短的部分。在